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?
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.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 3/29/16, 5:40 PM|
|Seen: 334 times|
|Last updated: 5/2/16, 9:59 AM|