What is the query i would run in the administrator to turn all items OFF sale (unclick the ON SALE box)
Thanks!!
How to turn every produt in RMS OFF of sale
Apr 26, 2008
3 Replies
Hi Jessica
It appears the field that tracks the "item is on sale" flag is saletype, where if its zero it means the item is not "on sale", if its 1 then the item is on sale, and if 2 its on sale based on a schedule.
I ran this query to confirm this select itemlookupcode, description, saletype from item
Items not on sale all had their saletype set to zero. Once you're comfortable with your analysis, backup the database and run
update item set saletype = 0
This will set all items to "not > What is the query i would run in the administrator to turn all items OFF sale
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required