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.
I assume I am making a very beginner mistake, and any support is appreciated.