Skip to Content
This question has been flagged
productimportattributxlsx
3 Replies
6304 Views
Avatar
ss@elbster.de

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

Avatar
Discard
Chris TRINGHAM

Maybe anyone has an idea?

Avatar
Amadeo
Best 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


Avatar
Discard
Avatar
Chris TRINGHAM
Best 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/ (but I haven't used it, so I can't offer any comment on it).


Avatar
Discard
Related Posts Replies Views Activity
Import Products by SKU Solved
product import
Avatar
Avatar
2
Mar 24
1431
import invoices from template in excel
invoice product import csv xlsx
Avatar
Avatar
1
Jul 22
617
PRODUCT LISTS IMPORTING ISSUE Solved
product import
Avatar
Avatar
1
Feb 22
989
No import button Solved
product import
Avatar
Avatar
5
Nov 21
10797
Product import
product import
Avatar
Avatar
1
Mar 17
2158