Merge Duplicate Customer Records

Duplicate customer profiles can appear in any CRM—especially when customers contact you through multiple channels or when data is imported from external systems. OctopusPro lets you identify duplicate customer records and merge them into one primary (master) customer profile so your database stays clean and each customer’s history is kept in one place.

Table of contents

• Why duplicate customers happen
• Important: merging is irreversible
• How OctopusPro detects duplicates
• What happens when you merge customers
• How to merge duplicate customers
  • Option 1: Find Duplicate Customer
  • Option 2: Merge from All Customers
• Why merging duplicates matters
• How OctopusPro helps prevent duplicates
• Best practices
• Troubleshooting

---

Why duplicate customers happen

Duplicate customer records can be created in several ways, including:

• Customers submit multiple inquiries via your inquiry / lead capture form.
• Customers make multiple online bookings via the customer portal without logging into an existing account (or without creating an account).
• Admin users manually add a customer that already exists and ignore the “similar customer already exists” warning.
• Fieldworkers add a customer without checking if they already exist (or don’t have access to your full customer list).
• Customer contacts are pulled in from Xero or QuickBooks and duplicates exist in the synced records.

Important: merging is irreversible

How OctopusPro detects duplicates

OctopusPro identifies potential duplicates using exact matches on any of the following fields:

• Mobile number
• Phone number
• Email address

Tips to improve duplicate detection

• Exact match means formatting matters: differences in spacing, country codes, or punctuation can prevent a match.
• Ensure mobile/phone values are entered consistently across your team.
• Ensure email addresses are valid and free of typos.
• Avoid placeholder values (e.g., “N/A”, “-”, fake numbers) in email/phone fields as they can create false matches or clutter the results.

What happens when you merge customers

1) You choose what profile details to keep

When you open a duplicate match, OctopusPro displays the standard customer profile fields for each record (for example: name, business name, phone/mobile, email, and billing address). You can select which values to copy into the primary customer profile. Any profile data not selected from duplicate records is removed as part of the merge.

2) Customer history is consolidated into one profile

Linked records and history are transferred into the primary customer profile, including:

• Inquiries
• Quotes
• Bookings
• Invoices
• Complaints / issues
• Payments
• Discussions / messages

3) Single-source data is not deleted

Information that exists only on one profile should not be lost during the merge. If two profiles contain different values for the same field, you should explicitly select which value you want to keep during the merge. If you don’t select a value, the system may apply a default rule (for example, using the newest profile’s value based on created date).

4) Review any other customer attributes before saving

Depending on how your account is configured, customer profiles may include additional attributes (for example: tags/labels, custom fields, internal notes, files/attachments, portal-related details, or other linked information). Always review the final primary profile preview on the merge screen before saving to ensure the resulting record contains the correct information.

How to merge duplicate customers

You can merge duplicates in two ways:

• Option 1: Use Find Duplicate Customer (recommended for reviewing detected duplicates).
• Option 2: Start from Customers → All Customers (recommended if you already know which record to keep).

Option 1: Merge using “Find Duplicate Customer” (recommended)

1. Go to Customers.
2. Select Find Duplicate Customer from the Customers menu.
3. If the page indicates the list may be outdated, use the on-screen action to refresh/update the results.
4. Locate the customer record you want to keep as the primary (master) profile.
5. Click Similar (#) beside that customer to view possible duplicates.
6. On the cleanup/merge screen:
   • Tick Merge this duplicate for each record you want to merge into the primary profile.
   • Select the specific field values you want to keep in the final primary customer record (e.g., email, mobile, address).
     
7. Review the final primary customer details carefully.
8. Click Save to complete the merge.
9. If none of the suggested profiles are true duplicates, click Back and do not merge.

Option 2: Merge from Customers → All Customers

1. Go to Customers → All Customers.
2. Open the customer profile you want to keep as the primary record.
3. Click Actions.
4. Select Merge Duplicate profiles (or the equivalent merge option shown on your screen).
5. Review suggested matches, select which records to merge, choose the field values to keep, then click Save.

Why merging duplicates matters

• Cleaner CRM: One customer = one profile, making it easier to manage communications, billing, and support.
• Better reporting: Revenue, bookings, and activity are correctly attributed to a single customer record.
• Fewer communication mistakes: Reduces the risk of sending duplicate reminders, follow-ups, and marketing emails to the same person.
• Smoother accounting sync: Helps reduce duplicate contact conflicts when syncing with accounting systems such as Xero or QuickBooks.

How OctopusPro helps prevent duplicates

• When an admin adds a new customer, OctopusPro checks whether the email, mobile, or phone already exists and may suggest using an existing customer record instead of creating a duplicate.
• When customers book through the customer portal, they are encouraged to log in to link bookings to their existing customer account (though duplicates can still occur if they continue without logging in).

Best practices

• Standardize phone formats across your team (e.g., always include country code, or always store without it—just be consistent).
• Train staff to search first before creating a new customer record.
• Use the primary record concept: keep the profile that contains the most accurate contact/billing details and the details you want to use for future communications.
• Review duplicates regularly if you have high inquiry/booking volume or frequent imports/syncs.

Troubleshooting

“I can’t see duplicates, but I’m sure they exist”

• Remember: detection is based on exact-match values for email/mobile/phone.
• Check for formatting differences and typos (especially in phone numbers and email addresses).
• Refresh/update the duplicate results from the Find Duplicate Customer screen if available.

“These ‘Similar’ records are not actually duplicates”

• Shared business phone numbers, shared inboxes, or generic emails can trigger “similar” matches.
• If you’re not 100% sure, do not merge. Click Back and keep the records separate.

To stay updated please subscribe to our Youtube channel.