kamrava Posted October 24, 2015 Share Posted October 24, 2015 Hi I have added almost 900 products in PrestaShop (1.6.0) with quantity 0 Now, I need to change all products quantities to 1 How can I do such thing at once ? Thanks Link to comment Share on other sites More sharing options...
NemoPS Posted October 24, 2015 Share Posted October 24, 2015 If you are not using combos and advanced stock management, you can try running a sql query like UPDATE ps_product SET quantity = 10 1 Link to comment Share on other sites More sharing options...
Paulito Posted October 24, 2015 Share Posted October 24, 2015 Hello Nemo1 I was thinking this query was good? UPDATE ps_stock_available SET quantity = 1 Paul 2 Link to comment Share on other sites More sharing options...
kamrava Posted October 24, 2015 Author Share Posted October 24, 2015 If you are not using combos and advanced stock management, you can try running a sql query like UPDATE ps_product SET quantity = 10 Can I write that query from PrestaShop SQL Management? Because I have no access to the HOST. Link to comment Share on other sites More sharing options...
Paulito Posted October 24, 2015 Share Posted October 24, 2015 Hello I am not really clever at this but I think the SQL Manager will not allow this, most likely for security. The only way I know, and as I have said I am not an expert, is by php admin. Not sure why you cannot access this. Paul 2 Link to comment Share on other sites More sharing options...
NemoPS Posted October 26, 2015 Share Posted October 26, 2015 I confirm what Paul said, you can only run SELECT queries with the manager, as far as I know Link to comment Share on other sites More sharing options...
Recommended Posts