Yan Studio Posted July 1, 2014 Share Posted July 1, 2014 Hi I make a migration for a client from joomla 1.5 to prestashop all went fine but i want to change some values all together is it possible I tried to export and edit the csv file... But when i try to save i get an error from excel and the file is not opening properly Maybe from a db is another solution please help Regards Link to comment Share on other sites More sharing options...
PSfever.com Posted July 2, 2014 Share Posted July 2, 2014 If you want to edit the quantity of all products to let's say 100, this SQL query should do the trick. In the selected database run this: UPDATE prefix_product SET quantity = 100; where you replace the prefix by your actual prefix. Link to comment Share on other sites More sharing options...
vekia Posted July 2, 2014 Share Posted July 2, 2014 im affraid that this will not work, we have to change ps_stock_available table UPDATE ps_stock_available SET quantity = 100; 1 Link to comment Share on other sites More sharing options...
Yan Studio Posted July 2, 2014 Author Share Posted July 2, 2014 Hi Thanks Man it works!!! Link to comment Share on other sites More sharing options...
vekia Posted July 3, 2014 Share Posted July 3, 2014 you're welcome :-) i marked topic title as solved with regards, Milos Link to comment Share on other sites More sharing options...
Recommended Posts