Skip to Content
Q&A

Duplicate contacts in Odoo: how to prevent them and merge them safely

Where duplicates come from, what Odoo refuses to merge, and the agreements that keep your contact list clean

Back to all Q&A
November 4, 2026 by
Duplicate contacts in Odoo: how to prevent them and merge them safely

In short: duplicate contacts spread your sales history, invoices and email conversations over several records. Odoo can merge them, but a merge cannot be undone. This article explains where duplicates come from, how to merge step by step, what Odoo refuses to merge, how to handle larger numbers, and which agreements keep your contact list clean.

Two overlapping contact cards being combined into a single clean contact record

Two records for the same customer look harmless. Then a colleague adds a delivery address to one record, accounting sends a reminder from the other, and the salesperson does not see that the customer already has an open quotation. Questions about this reach our helpdesk regularly, often after an import or a new connection with another system.

This article is about contacts and applies to Odoo 19. Is your problem with products? Then read Avoiding duplicate products in Odoo.

Where duplicate contacts come from

Odoo does not require a contact to have a unique name or email address. The email field has no uniqueness rule, and that makes sense: colleagues at one company may share an address. So duplicates usually arise in daily work:

  • Imports without a stable key. Without an External ID, an import creates new records instead of updating existing ones. The same principle applies to products and contacts.
  • Converting leads. When you convert a lead, Odoo asks whether to create a new customer or link to an existing one. Choosing a new customer out of habit creates a second record.
  • Connections with other systems. A webshop or another external system can create a contact when it does not recognise the customer. Check how your own connections do this.
  • Several people entering data. One colleague types the trading name, another the legal name, and a third adds the contact person as a separate company.
  • Several companies in one database. Sometimes each company creates its own record for the same customer. In a multi-company database new contacts are shared by default, so a second record is often unnecessary.

Decide first: is this really the same contact?

A similar name does not prove anything. Two branches or two legal entities with almost the same name may need separate records, for example because they have different VAT numbers or invoice addresses. Use this simple rule: if the VAT number differs, do not merge until you know why. In case of doubt, ask whoever handles your accounting.

Also check whether one of the records is a contact person under a company. Then the fix may be to place that person under the right company, not to merge.

Merging contacts step by step

For a small number of duplicates, the standard merge is enough:

  1. Open the Contacts app and switch to the list view.
  2. Tick the contacts that belong together.
  3. Click the Actions icon and choose Merge.
  4. Check the list in the pop-up. Remove a contact from the merge with the delete icon if it does not belong there.
  5. Choose the Destination Contact. This is the record that remains. By default, Odoo selects the contact that was created first.
  6. Click Merge Contacts and check the result.

What Odoo does, and what it refuses

It helps to know what happens during a merge. References to the old records, such as documents, attachments, followers, activities and messages, move to the destination contact. The old records are then deleted, not archived. That is why Odoo warns that a merge cannot be reversed.

In Odoo 19 the merge has a few built-in limits:

  • A maximum of three contacts at once. Have more? Repeat the merge.
  • The same email address. Contacts with different addresses can only be merged by an administrator.
  • No parent and child. You cannot merge a contact with its own parent.
  • No more than one user. Contacts linked to more than one user cannot be merged, even if only one of those users is active.

One more detail: if moving a linked record would break a uniqueness rule, Odoo removes that conflicting line instead of moving it. So on important records, check afterwards whether everything you expected is still there.

Larger numbers: deduplicating with criteria

After a merge, Odoo shows a button called Deduplicate the other Contacts. You then choose the criteria for finding duplicates: email, name, whether the contact is a company, VAT number and parent company. If you select several criteria, Odoo only suggests records that match on all of them.

You can also exclude contacts that have a linked user or journal items. We recommend doing so in your first round, because those are the records where a mistake has the most impact.

Odoo then offers manual checking or two automatic options. Start with Merge with Manual Check. The documentation does not explain the difference between the two automatic options, so only use them after you have tested them on a copy of your database.

Structural cleanup with Data Cleaning

Do duplicates keep coming back? The Data Cleaning app, available in Odoo Enterprise, lets you set up deduplication rules. A rule sets the model, the fields to compare and whether a match must be exact or may ignore case and accents. A scheduled action runs the rules daily, and you review groups of similar records with a similarity score.

Two settings deserve attention. With Duplicate Removal you choose whether merged records are archived or deleted, where the model supports it. With Merge Mode you choose manual or automatic merging. Start with manual merging and archiving, so that you can see what a rule catches before you trust it.

Preventing new duplicates

Cleaning up without changing the cause means doing the same job again next year. These measures help:

  • Take the warning seriously. The contact form shows a warning about potential duplicates when another contact has the same VAT number or company registration number. It does not block saving, so agree that colleagues always check it.
  • Fill in VAT numbers. That warning only works when the numbers are in Odoo.
  • Search first, then create. Make this the rule for everyone who enters contacts.
  • Link leads to existing customers. Check the customer choice during every conversion.
  • Import with an External ID. Keep that key in your source file, as described in From Excel to Odoo.
  • Check your connections. A connection should first search for an existing customer. We build integrations like this with Connecta.
  • Limit who may create contacts. Review this as part of your user rights.

Common pitfalls

  • Merging in bulk without a test. Test on a copy first, as explained in the Odoo test environment.
  • Choosing the wrong destination. The oldest record is not always the most complete one. Compare address, VAT number and payment terms first.
  • Forgetting external systems. If an external system recognises a contact by its own reference, test that connection after a merge.
  • Matching on name only. Name alone gives false matches. Combine it with email or VAT number.

What this means for you

You do not need a big project. Start by exporting your contacts and sorting them by email and VAT number, so that you know the size of the problem. Then clean up the customers and suppliers you use most, agree who owns contact data, and fix the source of new duplicates. Once that is done, a periodic check is enough.

Frequently asked questions

Can I undo a contact merge?

No. According to the Odoo documentation a merge cannot be reversed. Only merge when you are certain the contacts belong together, and test on a copy of your database when in doubt.

Why does Odoo refuse to merge my contacts?

The most common reasons: you selected more than three contacts, the email addresses differ and you are not an administrator, one contact is the parent of another, or the contacts are linked to more than one user.

Do I need the Data Cleaning app to find duplicate contacts?

Not necessarily. After a manual merge, Odoo offers a button to deduplicate the other contacts on criteria such as email, name and VAT number. Data Cleaning is an Enterprise feature that adds rules which run daily and show similar records with a score.

Finally

A clean contact list makes sales, invoicing and support more reliable. Would you like us to look at your duplicates, or help find the cause? Contact DAADit Group, Odoo Silver Partner in Eindhoven, or start with the free Business Scan.

in Odoo

Question not answered?

Our Odoo consultants are happy to think along with you. Book a no-obligation intro call.

Book an appointment
From process intake to functional design, quotation and project
How we use one process model for the conversation, the design, the quotation and the implementation