Help

0

Attribute values must be unique ?

Avatar
Marc Bink
importproductsattributevalue

Hi,
I am preparing my product data to import in Odoo.
I created categories, attributes and attribute values and imported all of this without errors.
As we have a lot of products I tried to split the attribute values and created different attributes to avoid very long value lists.
When trying to import the products I get error messages when the same value exists also in another attribute, used for an other article, here "523"
Example:
Product Z with Attribute X with values 3,3.5,12,26,32,523
Product Q with Attribute Y with values 500,510,520,521,523

So I suppose that an attribute value must be unique and can not be used in different attributes?
Thx for your reactions




Avatar
Discard
1 Answer
1
Avatar
Waleed Mohsen (CorTex IT Solutions)
Best Answer

Hi, 

If you have the same attribute value name in two different attributes, you have to use the attribute value External ID rather than the name.

Comment Share
3 Comments
Avatar
Discard
Avatar
Marc Bink
-

Hi Waleed, thanks for your reply.
This is the format we use to do the import:
attribute_line_ids/id attribute_line_ids/attribute_id attribute_line_ids/value_ids
__export__.product_attribute_30_fd08f25e
This is the complete import line
default_code name standard_price categ_id attribute_line_ids/id attribute_line_ids/attribute_id attribute_line_ids/value_ids id active sale_ok purchase_ok invoice_policy detailed_type type list_price
101H06.000.000 VERATOP 6mm stanshak 0,00 All / Saleable / Rubber / Stanshakken __export__.product_attribute_30_fd08f25e Hak maat H30,H32,H34,H36,H38,H40,H42,H44,H46,H48 1 TRUE TRUE Geleverde hoeveelheden Voorraadproduct Voorraadproduct 2
101H55.146.00 TOPALAN HAK DOOS 50 0,00 All / Saleable / Rubber / Stanshakken __export__.product_attribute_30_fd08f25e Hak maat H3 1 TRUE TRUE Geleverde hoeveelheden Voorraadproduct Voorraadproduct 2
101H60.000.00 TRADITION HAK 6MM 0,00 All / Saleable / Rubber / Vormhakken __export__.product_attribute_30_fd08f25e Hak maat H64,H66,H68,H70,H72,H74,H76 1 TRUE TRUE Geleverde hoeveelheden Voorraadproduct Voorraadproduct 2
101H70.000.00 SUPERTOP HAK 7MM 0,00 All / Saleable / Rubber / Vormhakken __export__.product_attribute_30_fd08f25e Hak maat H64,H66,H68,H70,H72,H74,H76 1 TRUE TRUE Geleverde hoeveelheden Voorraadproduct Voorraadproduct 2
101H72.000.00 TEMPO HAK TOPY 0,00 All / Saleable / Rubber / Vormhakken __export__.product_attribute_30_fd08f25e Hak maat H64,H66,H68,H70,H72,H74,H76 1 TRUE TRUE Geleverde hoeveelheden Voorraadproduct Voorraadproduct 2

Is this wrong ?

Avatar
Marc Bink
-

Hi Waleed, meanwhile I checked something and I am wondering if I have to add the Values/External ID (__export__.product_attribute_value_1127_8b6b15de) one by one separated with a comma also ?

Avatar
Marc Bink
-

Hi Waleed,
Thanks to your suggestion and the help of Odoo Buffalo all is clear now and we can go further to the next step of exporting the variants, give them a unique SKU en unique prices.
Regards and have a nice day