Share
Report Anyone know how to reset stock levels for all items to 0?
*This post is locked for comments
You’re offline. This is a read only version of the page.
*This post is locked for comments
This will work ? it seems that you still get negative entries as the movements history is confusing the numbers...
how can we ERASE all the items including history , but without erasing SALES
Thanks!!
I'll try it out tomorrow. =)
Yes, all stock items in your database.
So make sure you make a backup!
Hi Tristan,
Thanks for the quick reply!! I really appreciate it. Will that update all items?
Open SO Administrator and connect to the database.
Select Query >> New
Type:
Update item
set quantity = 0
Press F5
Type in exacly as shon above.
Remember to make a backup before proceeding, just in case.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (