Odoo Help


import products with variant

Ralph LAvaud
on 9/26/15, 9:28 AM 2,122 views


I have a csv from my supplier with about 16000 Items. Some of the items have variant (color mostly)

What's the best procedure and csv format to use to get my products loaded in Odoo V 9


michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 9/26/15, 2:04 PM

I suggest that you create one product and its variants in Odoo

Then export that product with all relevant data, including variants data to a csv file(Utf-8/,)

open the csv file(Utf-8/,)

add only a second product to the csv file(Utf-8/,) with its data that must match with the 1st product lines

save the file and import it into Odoo; if this works then

add the 15998 other products to the csv file(Utf-8/,) with their data that must match with the first 2 product lines 

save the  csv file(Utf-8/,)

Reimport the csv file after deletion of the fist 2 product lines (to avoid duplication)

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 9/26/15, 9:28 AM
Seen: 2122 times
Last updated: 9/26/15, 2:04 PM