Odoo Help


How to import Products from CSV ?

Girish Joshi
on 2/9/13, 6:43 AM 2,797 views

When I try to import products from CSV, it says product_tmpl_id is mandatory ? But this field is populated after product is created. please let us know your solution.

Which version? I imported product recently on v7 and it did not forced me to set a producttmplid.

Fabien Pinckaers (fp)
on 2/9/13, 9:51 AM

OE Version 6

Girish Joshi
on 2/9/13, 9:58 AM

Note that the import_data method and UI has been redeveloped from scratch in v7.

Fabien Pinckaers (fp)
on 2/10/13, 5:38 AM

Ahmet Altinisik

--Ahmet Altinisik--
Altınkaya Elektronik Cihaz Kutuları imalat Ticaret ltd sti
| 8 7 10
ANKARA, Turkey
--Ahmet Altinisik--


Ahmet Altinisik
On 2/13/13, 5:20 AM

For csv import, you shoud add all of the required fields to the csv file even you do not use them. You can keep them empty. XML ID fields are also required. If you are creating new records you have two option.

  1. You can keep the xml id field empty as in the answer above and system will generate a new xml id with your next export (note that xml id is not generated untill export)
  2. You can define an XML id and fill the product_tmpl_id column with your values. System will create new products and add your defined xml id to the entries. (so you can use this defined XML ID value with your next csv update.) (I prefer this one)

Keep in mind that if you are defining your XML ids for products all IDs should be unique and product_id and product_tmpl_id cannot be the same even they are different models.

On 2/9/13, 7:09 AM

Make new column (without data) in your csv file: product_tmpl_id


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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

2 follower(s)


Asked: 2/9/13, 6:43 AM
Seen: 2797 times
Last updated: 8/5/16, 5:48 PM