Odoo Help


Update data by import via .csv files?

on 3/24/13, 10:45 PM 7,287 views

Is there a way to update customer data by import via .csv files? I have problems with it, as long as i know import .csv only create new data instance, not update.


Davide Corio

--Davide Corio--

| 5 4 7
Bricherasio, Italy
--Davide Corio--

Odoo Evangelist and Consultant

Davide Corio
On 3/25/13, 7:07 AM

You have to specify the "id" column (postgresql or xml internal id) for openerp to update existing data instead of creating new record.

Try to export the list of customers, including the ID column. Then you have a CSV you can use to update records by reimporting the same file (previously updated but keeping the ID column untouched)

thanks for your little clue, I'll do it

on 4/19/13, 9:58 AM

Tried. Difficult to use. Starting to feel annoy. Tried to import client's details, don't seems to have import function. Tried to import invoices, "No matching record found for name 'XXX' in field 'xxx' at row x. Get all possible values. Tried to import products, same thing. What's wrong????!!!

on 5/16/13, 6:42 AM

Thanks, solved

on 5/17/13, 9:22 AM

It works when I updated a char field, but when I try to update a many2one Field it does not change anything, I tried with the id, external id and name of that many2one field without success.

on 2/13/14, 6:44 PM

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: 3/24/13, 10:45 PM
Seen: 7287 times
Last updated: 3/16/15, 8:10 AM