2) My store has over 9000 sku's...is there a way to set up the system so that items cannot ring out for less than cost? For new items I am entering "lower bound pricing", but for the thousands of old items....is there a way to set it up automatically for all of them without going to each individual item and entering the cost?
Thanks for your help!
You could use a query to set LowerBound to Cost (or Cost +/* X).
I think the query would look like this: UPDATE Item SET PriceLowerBound = Cost WHERE LowerBound < Cost
I tried this with ...WHERE ID = X for a single item and it worked.
Backup your database before you run any query.
HTH, Tom
Have something to add? Share your thoughts — no account required.
Ask the community — no account required