Hoppa till innehåll
Du måste vara registrerad för att kunna interagera med communityn.
Alla inlägg Personer Utmärkelser
Etiketter (Visa alla)
odoo accounting v14 pos v15
Om detta forum
Denna fråga har flaggats
importproductsattributevalue
1 Besvara
4082 Vyer
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
Avbryt
Avatar
Waleed Mohsen (CorTex IT Solutions)
Bästa svar

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
Avbryt
Marc Bink
Författare

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
Författare

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
Författare

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

Relaterade inlägg Svar Vyer Verksamhet
Updating imported products workflow... Löst
import products
Avatar
Avatar
1
mars 15
4873
rowspan and colspan
import products snippets
Avatar
0
maj 24
3383
Can't import variants due to error on Attribute
import products variants
Avatar
Avatar
Avatar
2
jan. 23
9273
Products import
import magento products
Avatar
Avatar
2
mars 15
4494
Where are the import/export functions for products?
export import products
Avatar
Avatar
Avatar
4
mars 15
12203