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/

Post Terkait	Replies	Tampilan
Product import xslx Diselesaikan product import	3 Agu 25	1353
Import Products by SKU Diselesaikan product import	2 Mar 24	5403
import invoices from template in excel invoice product import csv xlsx	1 Jul 22	2161
PRODUCT LISTS IMPORTING ISSUE Diselesaikan product import	1 Feb 22	2652
No import button Diselesaikan product import	5 Nov 21	13323

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!