While importing update existing lines instead of creating duplicates?

Question

I have 5000 locations on Odoo.
I would like to update an individual field from all these locations (from a CSV file)
All other fields/data from the locations will remain the exact same, but there is one specific field within each location that must be changed.
Whenever I try to import the CSV File, even though all the names, parent fields match, odoo just creates duplicate locations from the import,
Instead of updating the existing locations with the updated fields :(
I have already ticked the o

m-azzain · Accepted Answer

Have you including the external id, with your fields in the CSV file?

CandidRoot Solutions Private Limited · Answer

Hello Jaime Matos, [1]
You only need the field you want to update and external id for update the record. Without having external id, Odoo will create new record.
Please check below screen-shot and steps,

You may follow below steps in order to update field for locations.
Select locations for which you want to update the field, select field you want to update Export it using Actions menu, make sure you enabled the option "I want to update data (import-compatible export)" Make changes in the fiel

Adithya · Answer

You have to use external id of the location rather than location name while importing.
Ideally, you only need 2 columns in the excel which you are importing. One is the external id and other is the field which you want to update.

This question has been flagged

CandidRoot Solutions Pvt. Ltd.

Enjoying the discussion? Don't just read, join in!