waynemiller Posted February 8, 2013 Share Posted February 8, 2013 Hi All, How do I set the quantity of all of my items to zero using sql, which tables do I need to change? Link to comment Share on other sites More sharing options...
Alex Simonchik BelVG Posted February 8, 2013 Share Posted February 8, 2013 Hi, what version do you use? do you use multistore feature? do you use advanced stock management? Regards Link to comment Share on other sites More sharing options...
waynemiller Posted February 8, 2013 Author Share Posted February 8, 2013 1.5.2 No No Link to comment Share on other sites More sharing options...
waynemiller Posted February 8, 2013 Author Share Posted February 8, 2013 Basically, I want to set everything to zero in categories 5 to 10 Link to comment Share on other sites More sharing options...
musicmaster Posted February 12, 2013 Share Posted February 12, 2013 From the top of my head (so test it first on test setup) it would be something like Update PS_PRODUCT set quantity="0" where id_category_default >"4" and id_category_default <"11" This assumes that all those products have those categories as default. If that is not the case it becomes a bit more complicated and you need to access the PS_CATEGORY_PRODUCT table too. 1 Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts