Odoo Help


How to import Products from CSV ?

Girish Joshi
on 2/9/13, 6:43 AM 3,737 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--
| 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


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: 3737 times
Last updated: 8/5/16, 5:48 PM