giuliopowa Posted March 12, 2014 Share Posted March 12, 2014 I'm searching a method to set the quantity in stock of all my products that I have in the BO. for example, I would to set all product quantity 1000 or another quantity I do not want to change them one by one ps 1.5.6.1 Link to comment Share on other sites More sharing options...
Maskca Posted March 13, 2014 Share Posted March 13, 2014 (edited) If you want adding identical quantity to all products, you can make sql query to "ps_stock_available" table and set in quantity column value that you want. Edited March 13, 2014 by Maskca (see edit history) Link to comment Share on other sites More sharing options...
giuliopowa Posted March 14, 2014 Author Share Posted March 14, 2014 why I have 34 lines? Link to comment Share on other sites More sharing options...
giuliopowa Posted March 14, 2014 Author Share Posted March 14, 2014 oh sorry , i was wrong db , now see db correct. but i have many many lines .no possible write another one ?? Link to comment Share on other sites More sharing options...
Maskca Posted March 14, 2014 Share Posted March 14, 2014 Have you combinations in your products? Link to comment Share on other sites More sharing options...
giuliopowa Posted March 14, 2014 Author Share Posted March 14, 2014 yes many , from min 1 to max 20 approximately Link to comment Share on other sites More sharing options...
Maskca Posted March 14, 2014 Share Posted March 14, 2014 In prestashop for each combination own quantity. And total product quantity consist of combinations quantity. And simple query do not help. If your products were without combinations you could just update "ps_stock_available" table. If you interested soon we finish the development of the module that export your products in Excel file, where you can change quantity for each combination, and import this file in your store where it update your quantity. Link to comment Share on other sites More sharing options...
giuliopowa Posted March 14, 2014 Author Share Posted March 14, 2014 eh i have approximately 30.000 lines . you have the module ready ?? link of the module?? i have ps 1.5.6.1 Link to comment Share on other sites More sharing options...
Maskca Posted March 14, 2014 Share Posted March 14, 2014 module will be ready in 2-3 days, and i give you link Link to comment Share on other sites More sharing options...
giuliopowa Posted March 14, 2014 Author Share Posted March 14, 2014 perfect Link to comment Share on other sites More sharing options...
vekia Posted March 14, 2014 Share Posted March 14, 2014 why not to update it in this table? update ps_stock_avaialble set quantity=1000 Link to comment Share on other sites More sharing options...
Maskca Posted March 14, 2014 Share Posted March 14, 2014 can, but total product quantity would be wrong Link to comment Share on other sites More sharing options...
Recommended Posts