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/

المنشورات ذات الصلة	الردود	أدوات العرض
Product import xslx تم الحل product import	3 أغسطس 25	1355
Import Products by SKU تم الحل product import	2 مارس 24	5404
import invoices from template in excel invoice product import csv xlsx	1 يوليو 22	2184
PRODUCT LISTS IMPORTING ISSUE تم الحل product import	1 فبراير 22	2654
No import button تم الحل product import	5 نوفمبر 21	13324

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!