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/

Gerelateerde posts	Antwoorden	Weergaven
Product import xslx product import	2 mei 25	639
Import Products by SKU Opgelost product import	2 mrt. 24	2584
import invoices from template in excel invoice product import csv xlsx	1 jul. 22	1415
PRODUCT LISTS IMPORTING ISSUE Opgelost product import	1 feb. 22	2032
No import button Opgelost product import	5 nov. 21	12319

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!