MohammadAmine Posted April 30, 2013 Share Posted April 30, 2013 hello guys, i have a ps multi store, i need to set all product's quantity to 1 for all stores using sql from phpmyAdmin. Thank you very much Link to comment Share on other sites More sharing options...
Trip Posted April 30, 2013 Share Posted April 30, 2013 A little more specific please. Do you use share available quantities or not? If I think you find it in ps_stock_available if not change quantities is ps_product. Link to comment Share on other sites More sharing options...
MohammadAmine Posted April 30, 2013 Author Share Posted April 30, 2013 Thnx for ur reply Mr. Trip, no i don't use shared Qty, and i already set quantity to 1 in ps_product table, but in ps backend i alwasy get "-" which means 0 or nothing. Thank you Link to comment Share on other sites More sharing options...
Trip Posted April 30, 2013 Share Posted April 30, 2013 No in my BO it shows a 0 (zero). If there is a "-" I guess you misconfigured something. I think I remember there is a '-' if share available quantities is on and you did not copy the quantities from ps_product to ps_stock_available or something else is wrong. Regards, trip Link to comment Share on other sites More sharing options...
Recommended Posts