brownd92 Posted March 5, 2013 Share Posted March 5, 2013 Hi there, Anyone any idea how to bulk update quantities in a warehouse without having to go into each product individually? Ive lots of products and combinations and its taking ages! Even if someone has a sql statement which would help me on the way... THanks David Link to comment Share on other sites More sharing options...
brownd92 Posted March 5, 2013 Author Share Posted March 5, 2013 anyone any ideas?? Link to comment Share on other sites More sharing options...
Trip Posted March 6, 2013 Share Posted March 6, 2013 I once made an ajax updater for such purposes but it is not for 1.5. nor for the warehouse feature. I guess it could be adapted but that would need lot's of testing. I am not quite sure on what is necessary and what might become necessary with the warehouse feature. From a quick view I see the folowing tables are changed for the warehouse ps_stock_mvt and more important maybe ps_stock ... so if you don't need the stock movements it might be sufficient just to update the ps_stock table. A further logic to update the stock movement should not be to hard to implement but any quick solution would be a custom solution. To make it more generic it needs a lot more developement. My suggestion ... I would manage that, with a self made csv importer For example search for "class CsvImporter" here http://php.net/manual/de/function.fgetcsv.php ... maybe you know someone how can adopt that for your needs. Regards, trip Link to comment Share on other sites More sharing options...
ssertoglu Posted September 27, 2013 Share Posted September 27, 2013 I can create a formula only if i can find where the db field of quantity is in phpmyadmin.. Link to comment Share on other sites More sharing options...
Recommended Posts