Skip to Content
This question has been flagged
importproductsattributevalue
1 Reply
3226 Views
Avatar
Marc Bink

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

Avatar
Discard
Marc Bink
Author

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 ?

Marc Bink
Author

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 ?

Marc Bink
Author

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

Related Posts Replies Views Activity
Updating imported products workflow... Solved
import products
Avatar
Avatar
1
Mar 15
4230
rowspan and colspan
import products snippets
Avatar
0
May 24
2616
Can't import variants due to error on Attribute
import products variants
Avatar
Avatar
Avatar
2
Jan 23
8085
Products import
import magento products
Avatar
Avatar
2
Mar 15
3942
Where are the import/export functions for products?
export import products
Avatar
Avatar
Avatar
4
Mar 15
11214