How can i import Products via csv or excel with attributes generated automatically.

Question

I need to import around 200k textile products from excel. They have attributes like size and color. The color name varies a lot because there are a lot different manufacturers. So is there a way to import the data with the attributes automatically generated if they are not yet in the system? Otherwise it would boil down to manually copy paste 200k lines of information.
We currently try out the v13.
Thank you

Amadeo · Answer

When you import a product there is the option to click at the beggining of the column
*"create if does not exist"*
I am trying to do an importation doing that and it does not work for me, I do't know why, maybe a bug? or probabbly I am doing something wrong, I am not an expert. But I think this is the way to do that, you can try to export different field of a product and see the field that you need to import to set the attributes.
I hope it helps, regards,
Amadeo

Chris TRINGHAM · Answer

Unfortunately this is not simple to do.  For example, Odoo would not know whether a new variant was a colour or a size.
I found one third-party app:
https://apps.odoo.com/apps/modules/13.0/sh_import_product_var/ [1]  (but I haven't used it, so I can't offer any comment on it).

[1] https://apps.odoo.com/apps/modules/13.0/sh_import_product_var/

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Product import xslx Ratkaistu product import	3 elok. 25	1368
Import Products by SKU Ratkaistu product import	2 maalisk. 24	5422
import invoices from template in excel invoice product import csv xlsx	1 heinäk. 22	2226
PRODUCT LISTS IMPORTING ISSUE Ratkaistu product import	1 helmik. 22	2677
No import button Ratkaistu product import	5 marrask. 21	13350

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!