Inventory

0

Odoo 14.0 Initial Stock Setup Inventory Adjustment Error <class 'KeyError'>: 'product_id'

Avatar
Dennis

Dear Forum,

Dear members,


I am running a small company which is among other things supplying parts to workshops. We have so far been tracking our stock mostly in Excel based on the reports we get from our warehouse-provider. We now want to professionalize this, and I have set up a community version of odoo for experimentation on a Raspberry pi at my home.

I have tried to follow up on tutorials and videos, but cannot manage to import our stock (products with quantities) correctly in Odoo 14.0. We are tracking our products by their internal part number. I have created a test-excel that contains the information we are using, and based on this Excel I'm trying to learn how to correctly import my stock into the database. The file looks like this:

External ID
Name
Product Type
Internal Reference
Salex Price
Cost
Weight
Sales Description
Quantity on Stock
Location
J0000000001
Product 1
Storable Product
J0000000001
1000
500
1
Description
10
WH1/Stock
...
...
...
...
...
...
...
...
...
...



With this file, I have managed to import the products into the "Product" section of the Inventory module.

It is then at the next step where I have been failing for a while now, when I try to use an inventory adjustment using the import functionality with this file to get the stock quantities imported, I always get the following error and have not been able to understand it, or find a way to fix it.

"Unknown error during import: <class 'KeyError'>: 'product_id' at 10 different rows"

I assume I am making a very beginner mistake, and any support is appreciated.


Best regards,

Dennis

头像
丢弃