bruce-rez Posted April 24, 2013 Share Posted April 24, 2013 Hi, I have a product with 46 different colors (Attributes Value). How can I assign the Minimum Order Quantity to all 46 Attributes Value in one shot or bulk, not assigning one by one? Thank you for any help, realy appreciated. Link to comment Share on other sites More sharing options...
prestashopninja Posted April 24, 2013 Share Posted April 24, 2013 (edited) Hello, Open up your database manager, for example phpMyAdmin, and (assuming your database prefix is "ps_") run those two queries below, one by one. This will set the minimal quantity as two, for all the product attributes in the database. If you are not experienced enough with database managers, I would suggest to try it first on a test installation, as the wrong use of the database managers could ruin your whole installation. UPDATE `ps_product_attribute_shop` SET `minimal_quantity` = '2' UPDATE `ps_product_attribute` SET `minimal_quantity` = '2' I hope this helps. Edited April 24, 2013 by prestashopninja (see edit history) Link to comment Share on other sites More sharing options...
bruce-rez Posted April 25, 2013 Author Share Posted April 25, 2013 Hi, Thanks for your reply and suggestion. Unfortunatly I am not familirized with this kind of operation and I don't want to mess up my website. Actually I am looking for a solution in the Back Office (Dashboard) of the prestashop. Since I have about 2500 products with different sizes and colors so I am looking for some thing convenient and frindly that can help to setup my store. I would appreciate it If you know any other easier solution or suggestion to share. Thank you anyway. Link to comment Share on other sites More sharing options...
Recommended Posts