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?