Skip to main content

How to merge duplicate customer records

Learn how CaptainbBook flags likely duplicate customers, how to review and merge a pair (including which fields win, what happens to payment details, and what moves onto the survivor), and how to clear a backlog with bulk merge.

Written by Luca Lattanzio

Duplicate customer records happen when the same person books with different contact details, is entered manually by staff, or is accidentally created twice.

Merging combines those records into one customer profile and moves the related data onto the record you choose to keep.
​

⚠️ Merges move real customer data

Review both records carefully before confirming. Every merge can be undone for 30 days.
​

💡 Requires: the Merge Customers permission, available to Admin and Manager roles by default.


Why duplicate records happen

Common causes include:

  • A staff member creates a new customer instead of finding an existing one

  • The customer uses a different email address

  • An email address or phone number contains a typo

  • Someone books on behalf of another person

CaptainBook detects likely matches and shows them as possible duplicates for you to review.


Find possible duplicates

There are three ways to find them.
​

From a customer record

Open a customer record.

If CaptainBook has detected possible duplicates, you will see a duplicate count next to the customer’s name.

From the Possible duplicates tab

Open the Possible duplicates tab on the customer record.

CaptainBook shows possible matches for that customer, with the strongest match first.

Each candidate includes a Review or Merge action.

The list loads when you open the tab, so you may briefly see a loading state.

From the duplicate customers queue

Go to:

Customers → Actions → Duplicate customers

This shows duplicate clusters across the entire business unit and is the easiest way to work through a larger backlog.

The option is only visible to users with the Merge Customers permission.


How CaptainBook identifies possible duplicates

CaptainBook compares customer records using signals such as:

  • Matching email address

  • Matching phone number

  • Matching name and phone number

  • Whether one record was created online and the other by a staff member

Phone numbers are normalized before comparison, so formatting differences do not necessarily prevent a match.
​

💡 Possible duplicates are suggestions, not automatic decisions.

Two people may legitimately share contact details. Always review both records before merging them.


Merge two customer records

Click Review or Merge on a possible duplicate.

CaptainBook opens a full comparison page showing both customer records side by side.

Choose which record to keep

The record on the left is Keeping.

This is the customer record that will remain after the merge.

The record on the right is Merging in.

This record will be removed after its data is moved to the surviving customer.

If the direction is wrong, click Swap before continuing.

Choose the record that is more connected to the customer’s existing activity rather than simply choosing the one that looks cleaner.

For example, you may prefer the record that already has:

  • More booking history

  • A linked payment provider

  • Existing conversations

  • More established customer activity


Review conflicting customer details

CaptainBook compares the customer fields from both records.

These include:

  • Name

  • Email

  • Secondary email

  • Phone

  • Address

  • City

  • Region

  • ZIP/postal code

  • Country

  • Languages

The fields are grouped based on whether they need your attention.

Conflicts

Both records contain a value, but the values are different.

CaptainBook preselects the value from the record you are keeping, but you can choose the other value instead.

Gaps

One record has a value and the other is blank.

CaptainBook automatically keeps the available value.

You do not need to make a choice.

Identical values

Fields that are the same on both records are collapsed so you can focus on the differences.
​

💡 A blank field is not treated as a conflict.

If the customer you are keeping has no phone number but the duplicate does, CaptainBook keeps the phone number automatically.


Review saved payment details

If both customer records have saved payment information, you choose which complete payment identity to keep.

The card information is treated as one unit, including:

  • Card

  • Card type

  • Last four digits

  • Expiration date

  • Payment provider link

You cannot mix individual payment fields from both records.

By default, CaptainBook selects the card with the later expiration date.

If only one customer has a saved payment method, it is selected automatically.


Review what will move

Before confirming the merge, CaptainBook shows a summary of the data that will move.

This may include:

  • Bookings

  • Guests

  • Segment memberships

  • Saved cards

It also shows the date until which the merge can be undone.

Review this carefully before clicking Merge.


What moves during a merge

The following data is reassigned from the duplicate customer to the surviving customer:

  • Bookings

  • Guests

  • Booking payments and refunds

  • Gift card transactions

  • Gift certificates

  • Question answers

  • Cancellation policy acceptances

  • Custom attribute values

  • Abandoned bookings

  • Waitlist entries

  • Conversations

  • Assistant messages

  • Scheduled notifications

  • Segment memberships

  • Customer timeline activity

  • Anonymous visitor ID

  • Linked user account, when applicable

Where both customers have the same segment membership, the duplicate membership is removed.

Where custom attributes exist only on the duplicate, those values are preserved.


What does not move

Some records intentionally remain where they are.

Segment membership history

Historical membership records are not rewritten, so past audience-growth reporting remains consistent.

Ad audience sync records

These are intentionally left in place.

On the next sync, the duplicate customer’s identifiers are removed from Google or Meta and the surviving customer is added correctly.

Activity logs and system notifications

These are not reassigned during the merge.


What does not happen during a merge

Merging customers does not:

  • Send an email to the customer

  • Resend booking confirmations

  • Trigger customer notifications

  • Treat the surviving customer as newly added to segments

The merge happens silently in the background.


After the merge

After merging, you return to the surviving customer record.

A banner at the top of the record shows the merge status.

You may see:

Still moving history

The main customer data has already moved, while timeline activity is still being transferred in the background.

This normally only takes a short time.

Merged

The merge has completed successfully.

You can undo it for 30 days.

Needs attention

The merge itself completed, but part of the background process may have failed.

Contact support if you see this status.


Undo a merge

For 30 days after a successful merge, the Merged banner includes an Undo button.

Undo restores:

  • The customer record that was removed

  • Data ownership between the two customers

  • The customer field selections made during the merge

What undo cannot restore

Undo does not reverse everything that happened after the merge.

For example, it cannot undo:

  • A new booking created after the merge

  • An email already sent

  • Data already synchronized to an external platform

  • A record that was later reassigned to another customer

After 30 days, the stored merge snapshot is deleted and self-service undo is no longer available.
​

⚠️ While a merge is still undoable, neither customer record can be permanently deleted.


Undo multiple merges in the correct order

If several records have been merged into the same customer, you must undo the most recent merge first.

For example, merging three customer records creates two separate merges.

To reverse the entire process:

  1. Undo the newest merge

  2. Then undo the earlier merge

CaptainBook will prevent you from undoing them in the wrong order.


Merge duplicates in bulk

The duplicate customers queue also lets you process multiple duplicate clusters at once.

Bulk merge uses conservative rules.

CaptainBook:

  • Automatically keeps values when one side is blank

  • Skips pairs where two populated values conflict

  • Skips pairs where both customers have saved payment methods that require a decision

  • Processes larger duplicate clusters one record at a time

  • Limits each run to 50 merges

This means bulk merge intentionally leaves uncertain cases for manual review.


Review bulk merge results

After a bulk merge, CaptainBook reports:

  • Merged — completed successfully

  • Skipped — requires manual review

  • Failed — could not be processed

Skipped pairs show which fields caused the conflict.

A failed pair does not stop the rest of the bulk merge from completing.


A safe way to clear a duplicate backlog

Start with the highest-confidence matches first.

Exact email matches and cases where one record was created online and the other by staff are usually the easiest to review.

Work in smaller batches, then review skipped records manually.

If two records could genuinely belong to different people — for example, family members sharing a phone number — leave them separate unless you are confident they are the same person.


Permissions

Customer merging uses its own permission:

Merge Customers

This permission is granted to Admin and Manager roles by default.

It is separate from the standard customer editing permission because merging removes one customer record and moves associated bookings, payment details, and history.

To change access, go to Roles & Permissions and enable Merge Customers for the appropriate role.


Frequently asked questions

Does the customer receive an email?

No. Merging customer records sends no customer communication.

Can I merge customers from different business units?

No. Customers from different business units cannot be merged.

What happens to the duplicate customer?

It disappears from your customer lists but is retained behind the scenes during the 30-day undo period.

What happens if both customers have a saved card?

You choose which saved payment identity to keep.

CaptainBook defaults to the card with the later expiration date.

Does merging update my Google and Meta audiences?

Yes. During the next audience sync, the duplicate customer’s contact details are removed and the surviving customer is synchronized.

Can I merge three or more customer records?

Yes.

From the duplicate customers queue, larger clusters are processed one pair at a time.

From an individual customer record, you merge one pair at a time.

What if the 30-day undo period has already ended?

Self-service undo is no longer available.

Contact CaptainBook support with the relevant customer IDs to see what can still be recovered.


Which plans include duplicate merging?

Duplicate detection and customer merging are available on:

  • Starter

  • Extended

  • Ultra

  • Legacy

The feature itself is available on every plan.

What differs is the amount of CRM data available to move.
​

On Starter, Extended, and Ultra, additional CRM information such as timeline activity, message history, and attribution can also be associated with the surviving customer.

On Legacy, those CRM records do not exist, so the merge focuses on information such as bookings, guests, documents, payments, and conversations.

Did this answer your question?