Microame Posted July 18, 2013 Share Posted July 18, 2013 Hi, Could anyone help me to update only the quantity of products via csv file? Regards Link to comment Share on other sites More sharing options...
Microame Posted July 18, 2013 Author Share Posted July 18, 2013 My Japanese friend, could you please explain in English please. Link to comment Share on other sites More sharing options...
vekia Posted July 18, 2013 Share Posted July 18, 2013 what ps version you use? Link to comment Share on other sites More sharing options...
parsifal Posted July 18, 2013 Share Posted July 18, 2013 (edited) Hello Microame. If I recall correctly, in PS 1.5.x, two columns in your CSV should be enough for quantity updating: "ID" and "Quantity". An example CSV: "ID";"Quantity" 9584;100 This CSV should update the product with internal (PrestaShop's database) ID of 9584 to a new quantity of 100. Edited July 18, 2013 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
Microame Posted July 18, 2013 Author Share Posted July 18, 2013 Vekia, I use 1.5.4.1 version. Parsifal, If we do as you have suggested will that not erase other data's? Link to comment Share on other sites More sharing options...
Totti Posted July 18, 2013 Share Posted July 18, 2013 But if I want to update only the price of the products, I'm forced to go over all the data in csv ? Link to comment Share on other sites More sharing options...
parsifal Posted July 18, 2013 Share Posted July 18, 2013 (edited) Parsifal, If we do as you have suggested will that not erase other data's? I just checked it in my shop (1.5.3.1) with one product.The quantity was updated correctly. No existing product data were erased except...it caused one minor problem with the product's category associations: I had this product belonging to 3 different categories and unfortunately the CSV changed the product's primary (default) category to "Home".Maybe this is a bug in 1.5.3.1, but please keep it in mind if you assign your products to more than one categories ... Edited March 25, 2014 by parsifal (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts