Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
importproductsattributevalue
1 Vastaa
3098 Näkymät
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
Hylkää
Avatar
Waleed Mohsen (CorTex IT Solutions)
Paras vastaus

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
Hylkää
Marc Bink
Tekijä

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
Tekijä

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
Tekijä

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

Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Updating imported products workflow... Ratkaistu
import products
Avatar
Avatar
1
maalisk. 15
4147
rowspan and colspan
import products snippets
Avatar
0
toukok. 24
2525
Can't import variants due to error on Attribute
import products variants
Avatar
Avatar
Avatar
2
tammik. 23
7942
Products import
import magento products
Avatar
Avatar
2
maalisk. 15
3890
Where are the import/export functions for products?
export import products
Avatar
Avatar
Avatar
4
maalisk. 15
11117