HawklifyConnect your Odoo

Duplicate contacts in Odoo: merge them, keep the history

Find duplicate customers in Odoo, merge them into one contact with every quotation, invoice and message, and let Odoo hunt for the rest. Community and Enterprise.

Two contact cards merging into one customer in Odoo, with a green check mark.

Every Odoo database that has been used for a while has them: Azure Interior and Azure Interiors Srl, one with the quotations, the other with the invoices. Reports split the customer in two, salespeople call twice, and nobody knows which address is right. Odoo can merge two contacts into one and move every document to the one you keep. This guide finds a duplicate, merges it, and then lets Odoo look for the others.

It works the same in Community and Enterprise. The versions we tested are listed at the end.

This guide is also an AI tutorial. At the end, an AI assistant connected to Odoo finds the duplicates Odoo's own tool misses and merges them after one question, and stops a salesperson from creating a new one.See it in action ↓

Before you start

  • The Contacts app installed (Sales, Invoicing or CRM install it too).
  • An Odoo user with the Administration / Settings access right: only an administrator can merge contacts with different emails, or more than three at once.
  • Two contacts for the same customer, here Azure Interior and Azure Interiors Srl, each with its own quotation.

1. Find the duplicate

Open Contacts and switch to the list view. Search for Azure: the same customer shows up twice, plus the people who work there.

The contact list filtered on Azure, with Azure Interior and Azure Interiors Srl Two companies for one customer.

2. Merge the two contacts

  1. Tick Azure Interior and Azure Interiors Srl. Tick the companies only, not the people under them.
  2. Open Actions and choose Merge.
  3. Odoo lists the two contacts. In Destination Contact, pick the one to keep: the one with the right VAT number and address.
  4. Press Merge Contacts.

The Merge window with the two contacts and Azure Interior as the destination Pick the contact to keep. The other one goes away.

The quotation, the invoices, the messages and the people of Azure Interiors Srl now belong to Azure Interior.

After the merge, Odoo offers to deduplicate the other contacts Done. Odoo offers to look for more.

3. Let Odoo find the rest

Press Deduplicate the other Contacts.

  1. Tell Odoo what to compare. Here, untick the other fields and tick Email: two contacts with the same email are almost always the same customer.
  2. Press Merge with Manual Check.

The Deduplicate Contacts window with Email ticked Compare on the email only.

Odoo shows each group it finds, one at a time. Here, two Bar Centrale with the same email: press Merge Contacts, or Skip these contacts for a group that is not a real duplicate.

A group of two Bar Centrale contacts with the same email, ready to merge One group at a time: you decide each merge.

Merge Automatically merges every group without asking. Use it only with a strict rule, such as the same VAT number.

Common mistakes

  • Keeping the wrong record. The destination contact keeps its own name, address and VAT number. Pick the clean one.
  • Ticking the people too. Odoo refuses to merge a company with one of its own contacts. Tick the companies only.
  • Comparing on the name. Two shops called Casa Verdi in two cities are two customers. Compare on the email or the VAT number, and check each group.
  • Merging in bulk without looking. A merge can’t be undone. Use Merge with Manual Check until you trust the rule.

Duplicate contacts with AI: ask your AI assistant through MCP

With the Hawklify MCP server, Claude, ChatGPT and other assistants work in your Odoo as you, with your permissions. Odoo’s Deduplicate only groups identical values. Real duplicates look different: Hotel Bianchi and Hotel Bianchi S.p.A., Marco Neri and Neri, Marco, a VAT number typed with a space. The assistant compares names, VAT numbers, email domains and phones, and because a merge can’t be undone, it asks once before merging. Smart mode is on here.

Duplicate customers ⌄Smart mode
Our customer list has duplicates that Odoo's Deduplicate doesn't catch. Find them, and anything else that looks wrong.
✓Searched 12 customers in Odoo›

4 pairs are the same customer, written differently:

  1. Hotel Bianchi and Hotel Bianchi S.p.A.: the same VAT, typed with a space.
  2. Lago Design and Lago Design srl: same email domain, same city.
  3. Marco Neri and Neri, Marco: the same mobile number.
  4. Studio Rossi Architetti and Rossi Architetti Studio: same email domain and phone.

The two Casa Verdi are two different shops, in Milano and Roma, each with its own VAT. I'll leave them apart.

Maison Dubois is in Lyon with a French VAT, but filed under Italy.

In each pair I'll keep the record with the VAT and the full address, and move the other one's quotations to it. A merge can't be undone. Shall I go ahead?

Yes, go ahead.
✓Merged 4 pairs of customers in Odoo›
✓Set Maison Dubois to France in Odoo›

Done:

  1. 4 duplicates merged: each kept customer now has both quotations.
  2. Maison Dubois: country Italy → France.

8 customers left, all different.

AI app on the computer · Smart modeNames written differently, a VAT number with a space, the same mobile: four duplicates found and merged after one question.

Before a duplicate is born. A salesperson adds a customer from their phone: the assistant checks the VAT number and the email domain first, finds the customer already in Odoo, and adds the new person to it instead of a second company.

Hawklify

Your Odoo, from the chat you already use

Send a message, a photo or a voice note: the assistant reads and works in Odoo through Hawklify, with your permissions.

Ferretti Assistantonline
Today

Met a new customer at the fair: Hotel Bianchi, Via Roma 12, Milano, VAT IT09876540155. Contact: Giulia Conti, [email protected]. Add them please.16:40✓✓

✓Searched customers by VAT, name and email domain in Odoo

Hotel Bianchi is already a customer: Hotel Bianchi S.p.A., same VAT, same address. Last order in September, $4,750.

I won't create a second company. Shall I add Giulia Conti as a contact person under it?

16:40
Yes, add herNo, leave it

Yes, add her16:40✓✓

✓Created Giulia Conti under Hotel Bianchi S.p.A. in Odoo

Done. Giulia Conti is now a contact of Hotel Bianchi S.p.A., with her email. Her quotes will land on the same customer, with its whole history.

16:40
Chat on the phone · Smart modeA salesperson adds a customer met at a fair: the assistant spots that it already exists, and adds the new person to it instead.Want your assistant in a WhatsApp or Telegram chat? That channel needs a setup on our side: contact us.

Versions we tested

Version Result
Odoo 16 Same steps. Merge is in the Action menu, and the list shows the name in a column of its own.
Odoo 17 Like 16, with the Actions menu.
Odoo 18 Same steps.
Odoo 19 As in this guide. The screenshots come from Odoo 19.
Odoo 20 Like 19.

Frequently asked questions

What happens to the quotations and invoices of the contact that disappears?

They move to the contact you keep: quotations, orders, invoices, payments, messages and child contacts. The other contact is deleted, so its name only stays in the history of the documents.

Can I undo a merge?

No. Odoo deletes the merged contact. Check the destination contact before you press Merge Contacts, and keep the record with the right VAT number and address.

Why does Deduplicate not find all my duplicates?

It groups contacts whose fields are exactly the same: the same name, email, VAT number or parent company. "Hotel Bianchi" and "Hotel Bianchi S.p.A.", or a VAT typed with a space, are different values for Odoo.

Why does Odoo refuse to merge two contacts?

Only an administrator can merge contacts with different emails, or more than three contacts at once. And a company can't be merged with one of its own people: tick the companies only.

Questa guida è disponibile anche in italiano: Contatti duplicati Odoo: uniscili senza perdere lo storico