Is there a way to edit the stocks of all products at a time without going in to each single product?

anton.askenstrom · #1 11-02-2010, 05:45 PM

Hi!
I have a question whether it is possible to open one page and then edit the inventory, which means I don't have to go in to each single product?
Sincerly
Anton

Mike C · #2 11-02-2010, 06:22 PM

Hi Anton, you can do it through importing of CSV files. I had the same question about updating prices all at once. Once you have your products, just export them to CSV, modify the csv so that it just has the name, sku and quantity, update the quantity column and re-import the file. Make sure not to check the box to erase the existing products though!!

anton.askenstrom · #3 11-02-2010, 08:11 PM

Thanks! But what is "Csv files"?
Sincerly
Anton

Mike C · #4 11-02-2010, 08:20 PM

See here: http://en.wikipedia.org/wiki/Comma-separated_values

If you're not experienced with CSV files, it can be easy to mess up. Best to work with them in a program like Excel or OpenOffice Calc How many products do you need to update the quantity for?

anton.askenstrom · #5 11-02-2010, 08:52 PM

I have about 60 products in stock and would like to view aproximately 40-50 of them.
Thanks for helping me!
I really do appreciate it!
Anton

Mike C · #6 11-02-2010, 09:00 PM

You're welcome! I use OpenOffice.org Calc for all my CSV related work. It's very easy to work with so I recommend it highly