*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.
André Arnaud de Cal... 290,867 Super User 2024 Season 2
Martin Dráb 229,173 Most Valuable Professional
nmaenpaa 101,156