Ir al contenido
Se marcó esta pregunta
importproductsattributevalue
1 Responder
3073 Vistas
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
Descartar
Avatar
Waleed Mohsen (CorTex IT Solutions)
Mejor respuesta

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
Descartar
Marc Bink
Autor

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
Autor

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
Autor

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

Publicaciones relacionadas Respuestas Vistas Actividad
Updating imported products workflow... Resuelto
import products
Avatar
Avatar
1
mar 15
4127
rowspan and colspan
import products snippets
Avatar
0
may 24
2510
Can't import variants due to error on Attribute
import products variants
Avatar
Avatar
Avatar
2
ene 23
7927
Products import
import magento products
Avatar
Avatar
2
mar 15
3887
Where are the import/export functions for products?
export import products
Avatar
Avatar
Avatar
4
mar 15
11109