Odoo Help

Welcome!

This community 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.

1

Contradictory error message about ambiguous specification for field

By
Jeff Beidler
on 10/1/14, 5:42 PM 1,502 views

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!

0
Thomas
On 3/21/16, 5:22 PM

I have the same difficulty/impossibility to import an inventory from a csv file: the inventoried location I am providing is not accepted by the system; whatever value I am trying.


This seems to be a bug for the V8 I am Using (Odoo Saas option)

0
Damodar D.
On 3/21/15, 7:09 AM

If you import three products with no data for one of them you will get this exact error for that row.

name seller_ids/name/id

product1 __export__.res_partner_100

product2

product3 __export__.res_partner_101

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.

Your Answer

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

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 10/1/14, 5:42 PM
Seen: 1502 times
Last updated: 3/21/16, 5:23 PM