I'm still trying to import product quantities through the Inventory Adjustments screen. (This is how we did it in v7.) I created an inventory adjustment record for a stock location, then exported the record to get the ID. When I try to import product quantities using this ID, I get the following error message:
- Ambiguous specification for field 'Inventoried Product', only provide one of name, external id or database id at row 2 (60 more)
- Missing required value for the field 'Inventoried Product' (product_id) at row 2 (60 more)
If I only supply the name of the product, the validator complains that it wants the product_id. If I supply both the product_id and the name (as "Inventoried Product"), then I get the above message. If I drop the name and only use the product_id, then it complains that there is no "Inventoried Product"!!! It's like the system wants it both ways, but also dislikes both ways. What gives?
Any help toward importing initial QoH from a different system would be much appreciated!