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!
If you import three products with no data for one of them you will get this exact error for that row.
It seems that if you have the field id listed as something you want to import, it must be fully populated for each row.
To work with this as it is, simply remove the rows from your import if they don't have the location_ids/name/id info available for that product. Then do another import of the those missing items without that field being imported.
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: 10/1/14, 5:42 PM|
|Seen: 1502 times|
|Last updated: 3/21/16, 5:23 PM|