Greetings Odoo Community,
This is meant as a test case to better understand a specific how Odoo handles product importing.
The figure above showcases two separate attributes for an example factory. Exact names aren't important, the critical point is that there is a value matching in fields D2 & D4. This by itself is correct and will be accepted by Odoo, the values will be mapped to seperate attributes and thus no ambiguity on what goes where.
The figure above is the (simplified) next stage of importing a product, stripped down to only focus on the product attribute portion. When testing the import, Odoo will run into ambiguity on the matching values and the import will fail. If the product creation is done manually this will not occur, as the user selects their desired product attribute before choosing the values to associate.
The question then is how to correctly handle this scenario for a successful import? The simple answer is to avoid having matching attribute values at all via renaming, but there are cases where that may not be viable.
You should be able to do this using the External ID for the attribute rather than its name, because that has to be unique.
External ID rather than value is a possible solution for the import, albeit frustrating.
Expanding the product import table to hundreds of product templates, where each product could have multiple attributes & attribute values makes double checking correct value entry much more difficult. It also necessitates as a methodology process: