Community mailing list archives

community@mail.odoo.com

Import products and variants

by
Alejandro Perez Cosio
- 09/10/2015 15:53:53
Hello experts,
I'm facing a problem where I need to import many products which were managed in an excel sheet just like below:

Code
Name
Price
0301
Stethoscope Classic II Red 300
0302
Stethoscope Classic II Pink
300
0303
Stethoscope Classic II Olive
300
0304
Stethoscope Classic II Brown 300
0305
Stethoscope Classic II Sky
300
0306
Stethoscope Classic II Gold
320
0311
Stethoscope S.E. White
540
0312
Stethoscope S.E. Red
540
0313
Stethoscope S.E. Navy Blue
540
0314
Stethoscope S.E. Gray
540

And so on up to 700 products approximately.
I think the best way to keep these products in Odoo is with variants per color, but now, I really don't know how to import a template with each color attribute.
I success to create products templates and products variants in 2 csv files, but I don't know how to link them by the attribute color..

Do you have some trick to import them all?

Best regards
--
Alejandro