Import Failed Due to Duplicate Attribute Values (‘10 ml’) of different Attributes

Question

Hello Everyone,
I have an attribute 'A' with values ​​like '10 ml', '20 ml', and an attribute 'B' with a value '10 ml'. While importing products—for example, product 'PQR' with attribute 'A' value '10 ml' and product 'XYZ' with attribute 'B' value '10 ml'—I'm encountering an error stating '10 ml found 2 times'. How can I resolve this issue when importing products via Excel into the Inventory module?

Protovec Technologies Pvt. Ltd. · Answer

Thank you done successfully :)

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,
steps:
1. Make attribute values unique globally
2, Use the attribute value ID in the import
Instead of using the display name (10 ml), use the ID/reference of the attribute value.

Go to Inventory → Products → Product Attributes → Attribute Values.

Note the External ID / XML ID of each attribute value.

In your Excel, instead of writing 10 ml, write the ID (like product_attribute_value_10_ml_A).

Hope it helps.

This question has been flagged

Enjoying the discussion? Don't just read, join in!