Finding and Merging Duplicate Partners in Odoo CRM

Merging Duplicate Partners in Odoo#

Over time, customer and vendor records accumulate duplicates - the same company entered twice by different users, or the same contact created via email capture and manual entry. Duplicates fragment transaction history and confuse sales teams. Odoo provides tools to find and merge them.

Finding Duplicates#

Method 1 - Duplicate Detection:

Contacts → Action → Deduplicate Contacts:

• Odoo compares contact names, email addresses, and phone numbers
• Groups likely duplicates: "5 groups of duplicate contacts found"
• Review each group before merging

Method 2 - Manual Search:

Contacts → [Search for company name]:

• If "Acme Corp" and "ACME Corporation" both appear → likely duplicates
• Open both, compare: same address? same tax ID? → confirm duplicate

Merging Partners#

Contacts → [Select both duplicates] → Action → Merge:

Odoo shows a comparison:

Choose which value to keep for each field:

• Name: Acme Corporation
• Email: keep both (primary: info@acme.com)
• Phone: keep both

Click Merge → Odoo:

• Moves all transactions (invoices, orders, tickets, activities) to the surviving record
• Archives the duplicate
• Updates all references throughout the system

What Gets Consolidated#

After merge, the surviving record contains:

• All open and historical invoices from both contacts
• All sale orders and purchase orders
• All CRM opportunities and activities
• All support tickets and chatter messages
• Both email addresses and phone numbers

Preventing Future Duplicates#

Contacts → Configuration → Settings → Duplicate Warning:

• Enable: when creating a new contact, Odoo warns if a similar name or email already exists
• Users see: "Similar contact found: Acme Corporation - merge or create new?"

Also enforce: standardize company name format (e.g., always use full legal name) and require email address on all contact records.

Deduplication Reports#

Contacts → Reporting → Duplicate Analysis (with reporting module):

• Total duplicate groups found
• % of contacts that are duplicates
• Most common duplicate patterns (name variations, email domains)

Run monthly deduplication as a data hygiene task - especially important before major CRM migrations.