Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I've been struggling with a stock import for the last 2 days. I want to set the QoH for the products in the WH/Stock location after I've imported the products. I've followed various guides and advice I found on the forum but it doesn't work.
I notice that when I create an example Inventory Adjustment with a few products and I export the adjustment as a CSV file, I can delete the original Inventory Adjustment and successfully import it again from CSV. But as soon as I include additional lines for products that I've never referenced in a previous Inventory Adjustment, I get this message: No matching record found for external id '__export__.product_product_2242' in field 'Inventories' between rows 2 and 379
For example, the above product ID is the ID of the first product that was not in the example export. It seems like the import mechanism only matches product ids to products that are already in the WH/Stock location?
Similarly, if I create a new Inventory Adjustment for 'All products' the list only contains those few I had in my initial example export.
So my assumption is that products imported by CSV is not associated to a location and by 'touching' a product once in a previous Inventory Adjustment, it becomes associated with the WH/Stock location and I can now use it in a CSV import.
How can I associate all my products to the WH/Stock location so that the Inventory Adjustment CSV import will succeed? Or maybe I missed something while I imported the products?
* Warehouse(s) created
* Products imported
* In Inventory Adjustments import CSV file with below fields:
name (e.g Initial Inventory, this field should have ONLY 1 record)
line_ids/product_qty (stock quantity in hand)
* One imported entry will be created in Draft status
* Open the entry and press Start Inventory
* Validate Inventory if everything ok
Have you exported your "known good" products after you have touched them? Make sure you export things like:
In particular "property_stock_inventory/id". Export them and see what you're getting. Chances are you'll have something like "stock.location_inventory", that you are missing that from your import csv file.
Good luck and keep us posted on how you get it working. I'll be migrating a database over shortly and will be very interested to know what you need to do to make it work.
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 3/29/16, 5:40 PM|
|Seen: 1326 times|
|Last updated: 5/26/17, 10:28 AM|