n0dlehs Posted June 3, 2013 Share Posted June 3, 2013 Hi Guys, Does anyone have a way of updating all products to show the quantity to more than 1000? I set all my products to 10 as default but want to increase all to 1000. Does anyone have a phpMyAdmin script handy to do this? Thanks Liam Link to comment Share on other sites More sharing options...
vekia Posted June 3, 2013 Share Posted June 3, 2013 what ps version you use? (this is most important question in this case) Link to comment Share on other sites More sharing options...
n0dlehs Posted June 3, 2013 Author Share Posted June 3, 2013 Apologies, we are running PS 1.5.4.0. Link to comment Share on other sites More sharing options...
vekia Posted June 3, 2013 Share Posted June 3, 2013 UPDATE ps_stock_available set quantity = '1000' Link to comment Share on other sites More sharing options...
n0dlehs Posted June 3, 2013 Author Share Posted June 3, 2013 I have hpg_stock_available in my list of tables, would it be this one? Link to comment Share on other sites More sharing options...
vekia Posted June 3, 2013 Share Posted June 3, 2013 yes, this is table related to the product stock in your store Link to comment Share on other sites More sharing options...
n0dlehs Posted June 3, 2013 Author Share Posted June 3, 2013 Any then run the UPDATE command in here? Sorry for being a tad anal about this... Link to comment Share on other sites More sharing options...
vekia Posted June 3, 2013 Share Posted June 3, 2013 you can run this query, for example, in the phpmyadmin in SQL query tool Link to comment Share on other sites More sharing options...
n0dlehs Posted June 3, 2013 Author Share Posted June 3, 2013 That worked great, thanks for your help Vekia Link to comment Share on other sites More sharing options...
vekia Posted June 3, 2013 Share Posted June 3, 2013 you're welcome so im going to mark this thread as [solved] if you've got any questions related to this case - feel free to continue discussion here regards Link to comment Share on other sites More sharing options...
Recommended Posts