Tito Posted February 3, 2013 Share Posted February 3, 2013 Hi, Am searching for SQL commands to completelly reset/delete all stock transactions, warehouses and other related records. We have enabled advanced stock before, but are having issues now. Simply disabling a'advanced stock' doesn't solve our issues. So: Besides truncating some tables (which? warehouses?orders?stock statusses?) , are there any fields we can reset on product level ? Goal would be to have all products quantity set to 0 , and all warehouses deleted. It does not matter if we loose orders and/or customers while deleting these. (Though we do not want to lose our products/categroies setup, or our product combinations, neither our multistore config) Thx in advance. Link to comment Share on other sites More sharing options...
saintofinternet Posted January 8, 2016 Share Posted January 8, 2016 well i am looking for a similar solution... Link to comment Share on other sites More sharing options...
SilverNodashi Posted June 30, 2016 Share Posted June 30, 2016 Such a solution doesn't exist. Link to comment Share on other sites More sharing options...
musicmaster Posted June 30, 2016 Share Posted June 30, 2016 From the top of my head (so no guarantees and make a backup): - truncate all ps_stock(*) tables except for ps_stock_available - in the ps_stock_available table set depends_on_stock to zero for all products Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now