mirekcerno Posted July 22, 2015 Share Posted July 22, 2015 Hello guys, I need little help from you. I plan to inventory my warehouse stock, I got over 4000 products. What I need is to set all stock to 0. Then I will add products what I have here. How to do it easily? My plan is to rewrite the counts in database. What do you think. Thx Mirek Link to comment Share on other sites More sharing options...
ozfragrance Posted July 22, 2015 Share Posted July 22, 2015 UPDATE `ps_product` SET `quantity`='0' WHERE `active`='1'; it will set quantity to zero for all active products. Link to comment Share on other sites More sharing options...
mirekcerno Posted July 22, 2015 Author Share Posted July 22, 2015 thx a lot Link to comment Share on other sites More sharing options...
mirekcerno Posted July 22, 2015 Author Share Posted July 22, 2015 Sorry I forgot to say I use advanced stock. Which of them update: ps_stock or ps_stock_available? Or both. Thx Mirek Link to comment Share on other sites More sharing options...
ozfragrance Posted July 22, 2015 Share Posted July 22, 2015 sorry mate, I never used advanced stock management so I couldn't tell which one to update. but my understanding you are updating ps_product table and I think that will update the products everywhere in the shop we are not running this query against the ps_stock table. Link to comment Share on other sites More sharing options...
Recommended Posts