Hello all,
I am wondering if there is a way to un-select the "Item is available on the website" option for multiple items at once. I have over 5000 items that need to be un-checked and it would take forever manually.
Maybe there is a SQL command, or something similar to how inventory wizard works??? I am totally new to SQL so any help is very much appreciated.
*This post is locked for comments
That worked wonders! Thank you SO MUCH happyamosfun
You can run that query in HQ admin, then run worksheet 260 for any items that were updated, this will send changes through to stores. Again, a backup is always recommended prior to making updates using SQL.
Thanks happyamosfun!
I am working in HQ Manager, not store manager. Will the same result work there?
To clarify, setting "webitem" to 1 will make everything available online, setting it to 0 will make them unavailable.
If you are looking to update every single item in inventory the following will do so all at once. I recommend backing up your database first.
UPDATE item
SET webitem = 1
There's a lot more that can be done to narrow down that group, but if you want a sweeping update in store manager, that will get it done.
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
