zYERz Posted November 16, 2013 Share Posted November 16, 2013 I have over 1000 of different combination of products on my website. What is the easiest way to add quantity for all my products? Lets say i have 5 in stock of a product and i want to update it and add 5 more. Right now i do it manually and change the quantity to 10 in BO. It will take way to long time to do this with 1000 products. When i want to update my stock, Can i somehow upload a CSV file that just adds to the quantity,? Many Thanks // zYERz Link to comment Share on other sites More sharing options...
vekia Posted November 17, 2013 Share Posted November 17, 2013 I have over 1000 of different combination of products on my website. What is the easiest way to add quantity for all my products? Lets say i have 5 in stock of a product and i want to update it and add 5 more. Right now i do it manually and change the quantity to 10 in BO. It will take way to long time to do this with 1000 products. When i want to update my stock, Can i somehow upload a CSV file that just adds to the quantity,? Many Thanks // zYERz you want to increase stock (+5) for each combination in your store? Or different values for each product/combination? Link to comment Share on other sites More sharing options...
zYERz Posted November 17, 2013 Author Share Posted November 17, 2013 Yes, I want to add different values for each products/combination. 1 Link to comment Share on other sites More sharing options...
veldmans Posted December 3, 2013 Share Posted December 3, 2013 zYERz, Got any solution so far? I'm in the same situation, got 500 products and want to change quantity of those products. Manually adjusting it is so much work each time. Already looked for a lot off options, but unable to find the right one. Kris Link to comment Share on other sites More sharing options...
RogueWaveLimited Posted December 3, 2013 Share Posted December 3, 2013 Is this something you want to do more than once? If so how often? Link to comment Share on other sites More sharing options...
veldmans Posted December 3, 2013 Share Posted December 3, 2013 In my situation yeah, atleast once a week orso.I was hoping that there was a easy way like enter the quantity value on the main product page or something like that, instead of opening each product one by one -> enter the value on the quantity page -> save it -> go back to main page -> open next product -> etc. etc. Link to comment Share on other sites More sharing options...
tuk66 Posted December 5, 2013 Share Posted December 5, 2013 The easiest way is usually to use a SQL query. I often use an Excel table with all important data and queries created through expressions (one row = one query). Very quick and easy for bulk updates. Link to comment Share on other sites More sharing options...
Recommended Posts