Someone also suggested that maybe there's a time limit for consigning things and once you've had an item consigned for too long, the whole thing stops working. No confirmation on this, though.
When Ambitions first came out, I was playing a sculptor and realized that I hadn't gotten a notice from the consignment shop for a few days. I went in to cancel my consignments and some of the items' days left were negative. I mean, it literally said -1 and -2 for some of them (instead of, I'm assuming, being returned unsold to my sim when they reached 0 days left to sell). I haven't had that happen since the patch but I am now much more careful to cancel my consignments right away when I notice the store being buggy. I wonder if anyone has actually had items returned unsold?
(Sorry, I realize it's a little late to be replying to something from July 19!)
Alsowe tried to reset it by picking up the store and setting it back down (there was only the one option of putting it back in the same spot, not moving it elsewhere for some reason)
You can only put it back down in the same spot because it's the only lot marked for the Consignment Shop. If you would like to set it elsewhere, you will need to change the Lot Type of another lot to Commercial > Consignment Shop.