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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156