Bulk upload of initial inventory

emyllymaki · **Joined:** Thu May 22, 2008 8:06 pm **Posts:** 154

Pickles wrote:

Hi,

I tried to followed the steps mentioned in the video, but cannot import my .csv file.

Error message: Error processing your first line of the file.
Field inventory_id;product_qty;location_id;product_id;product_uom is unknown!

What did I do wrong?

Thanks,

Pickles

without seeing the file my guess would be that your first line you used semicolons instead of commas to separate the field names. the "C" in "CSV" is for "Comma".

Spiraleye · **Posted:** Thu Jan 27, 2011 4:53 pm

ok, version 6 looks a little different. there is no place to import the csv!!

There is a "import inventory" link on the right sidebar but cant figre out how thats supposed to work.

Any ideas?

coolmanlg · **Joined:** Wed Mar 24, 2010 1:03 am **Posts:** 178

For those still struggling to upload stocks via csv, here is how I did it. Thanks to kjohn.

1. Click on Wharehouse->Inventory Control->Physical Inventory

2. Click on New and enter a name in "Inventory Reference" and save it.

3. Go back to the list view. If your the name you entered in the "Inventory Reference" above is not displayed, search for it and it should be there.

4. Look on right hand side and you should see "Import". Click on it to import your csv file. Below is my CSV header.

Quote:

inventory_line_id/location_id, inventory_line_id/product_id,inventory_line_id/product_uom, inventory_line_id/product_qty name

This should work. Hope it help someone.