To merge duplicate customer records, confirm the profiles match, then combine them under your software's pair, volume, and sync rules.
Key takeaways
- Run the duplicate check, then review each grouped pair before you merge.
- In Microsoft Power Apps, merge only two records at a time.
- In Housecall Pro, select at least two duplicate customers, then click Merge.
- Check HubSpot's 250 merge total, 14-day rollback, and subscription before you combine a pair.
- After a HubSpot merge, allow up to 30 minutes for activities to sync and export up to 90 days of detail.
Identifying potential duplicates using system rules
Microsoft Dataverse helps you address potential duplicates by providing duplicate detection for active rows, such as accounts and contacts, according to Microsoft. Model-driven apps and customer engagement apps (such as Dynamics 365 Sales and Dynamics 365 Customer Service) include default, duplicate detection rules for accounts and contacts, but not for other types of records, according to Microsoft. Housecall Pro automatically groups possible duplicate Customer profiles for you based on matching details such as Name, Mobile Number, Home Number, Work Number, or Email, according to Housecall Pro. Run the duplicate detection tool in your software to identify these grouped profiles for review.
Reviewing and confirming duplicate pairs before action
Before you commit to merging, you must confirm that the flagged profiles are actually the same entity. Each platform handles this confirmation step differently, so your review process depends on which tool you use for your subcontractor and client tracking.
In Microsoft Power Apps, the review happens directly on the view page. You select the duplicate rows from the view page in your model-driven app, and then select Merge in the command bar at the top of the page, according to Microsoft. This places the specific records you intend to combine right in front of you for final verification before the command bar action is triggered.
Housecall Pro groups the potential matches for you to inspect. You can review each group in the Manage Duplicates section to confirm and merge profiles, according to Housecall Pro. The interface keeps you in a consistent location during this process. You will stay on the page to easily review and merge all possible duplicate customers, according to Housecall Pro. This allows you to work through the list of flagged pairs without navigating away to other parts of the application.
You can roll back rejected duplicate pairs up to 14 days after the pair was rejected, according to HubSpot. This window gives you time to double-check your decision if you initially dismissed a match that was actually a valid duplicate.
Recommendation: When reviewing pairs, check the billing history and site access logs for each profile before confirming. If the data looks identical, proceed with the merge. If you are unsure, reject the pair in HubSpot to preserve the 14-day rollback option, or keep the records separate in Microsoft and Housecall Pro until you have verified the details.
Understanding merge limits and subscription requirements
Before you merge, check the quantity limits and subscription tiers required by your specific software. These rules determine how many records you can combine and what features are available for managing duplicates.
In Microsoft Power Apps, you can only merge two records at a time according to Microsoft. This restriction applies to every merge action you perform in that environment. You cannot select three or more records simultaneously to combine them into a single profile. Plan your cleanup sessions in pairs to work within this constraint.
HubSpot has a specific merge limit that prevents combining records if they have been included in a combined total of 250 or more merges according to HubSpot. For example, if Contact A and Contact B have been involved in 130 merges each, their combined total reaches the threshold, and you cannot merge them. Check the merge history of your pairs before attempting to combine them.
Subscription requirements also affect your ability to manage duplicates. A Professional or Enterprise subscription is required to manage individual duplicates and display up to 10,000 duplicate pairs using the duplicates manager tool according to HubSpot. If you are on a lower-tier plan, you may not have access to the full duplicates manager interface or the ability to view that volume of potential pairs. Verify your current subscription level to ensure you have the necessary tools for large-scale cleanup.
These limits and requirements vary by platform. Do not assume that the rules for one system apply to another. Review the specific documentation for your software to understand its constraints.
Executing the merge and handling data transfer
When you are ready to combine duplicate profiles, the specific actions depend on which field service platform you use. Each system handles the data transfer and associated documents differently, so it is critical to understand what happens to your records before you click the final button.
Selecting records in Housecall Pro
In Housecall Pro, you begin the execution phase from the customer list view. From the customer list, select at least two duplicate customers, then click Merge in the upper right, according to Housecall Pro. This interface allows you to handle multiple duplicates in a single action rather than pairing them one by one.
Data transfer in ServiceTitan
ServiceTitan handles the consolidation of data fields automatically during the merge process. According to ServiceTitan, when you merge duplicate customer records in ServiceTitan, any information in the record being removed that is not on the record you are keeping will be added to the record you are keeping. The platform instructs you to merge the duplicate customer record with the one you’re keeping according to ServiceTitan. This rule ensures that unique data points from the removed record are not lost but are instead appended to the surviving profile.
Service agreements and proposals
For office managers tracking billing and site access, the handling of contractual documents is a primary concern. According to ServiceTitan, when merging customer and Location Records, any service agreements and proposals associated with the record are carried over to the merged profile.
SharePoint document libraries
Microsoft’s approach to merging records involves specific handling of associated document storage. According to Microsoft, merging records with a SharePoint documents library merges only the records, not the documents libraries. This distinction is important for construction office managers who store site plans or subcontractor contracts in linked libraries. Construction office managers who also file site paperwork can keep New worker safety instruction record: 4 checks, Weekly safety inspection log: 8 checks to record, and Hot-work handoff: 6 checks before the crew welds with the job file. The system does not consolidate the files within the libraries themselves during the record merge. You must manage the document files separately if you need to consolidate them into a single library folder.
Merge limits by publisher
The following table lists the six distinct merge capabilities and limits documented by the three publishers. Each row represents one specific capability or limit, with the publisher named in the row and the details traceable to that publisher's documentation.
| Publisher | Capability or Limit | Specific Rule | Source |
|---|---|---|---|
| Microsoft | Merge quantity limit | You can only merge two records at a time. | Microsoft |
| Microsoft | Document library handling | Merging records with a SharePoint documents library merges only the records, not the documents libraries. | Microsoft |
| HubSpot | Merge volume limit | You cannot merge records if they've been included in a combined total of 250+ merges. | HubSpot |
| HubSpot | Activity sync timing | It can take up to 30 minutes for all the records’ activities to sync. | HubSpot |
| HubSpot | Subscription requirement | A Professional or Enterprise subscription is required to manage individual duplicates and display up to 10,000 duplicate pairs. | HubSpot |
| ServiceTitan | Data transfer rule | Any information in the record being removed that is not on the record you are keeping will be added to the record you are keeping. | ServiceTitan |
Review this table to confirm which specific constraints apply to your current software environment before proceeding with record consolidation.
Illustrative example: two profiles near a merge cap
Suppose two profiles for one builder have already been part of 130 merges each. Together they pass 250, so the office leaves them separate. A second pair has 10 merges on each profile, and the office merges those two into one. The office waits 30 minutes before it reads the activity list. It can roll back a mistaken rejection within 14 days, and it keeps an export that covers 90 days.
Verifying the merge and checking activity sync
According to HubSpot, it can take up to 30 minutes for all the records’ activities to sync. Do not assume the merge is finished until the activity feed on the surviving record reflects the combined history.
To verify that the merge completed correctly, you can review the details of the merged record in bulk. According to HubSpot, you can review merged record details in bulk by export, with data up to 90 days ago. This export function allows you to pull the recent merge history and check that the correct fields were retained. For a construction office manager, this is a critical check: if you merged two client profiles, you need to confirm that the correct address, contact person, and billing details are now on the single record.
Verification steps for the office manager:
- Wait the full 30-minute sync window before checking the activity feed.
- Export the merged record details to check the data from the last 90 days.
- Compare the exported data against your original duplicate profiles to ensure no critical site information was lost.
Next step: Open your field service software's customer list and run the duplicate detection tool to identify potential duplicate profiles for review.
FAQ: how to merge duplicate customer records in field service software
How does the system automatically identify possible duplicate customers?
Microsoft Dataverse provides duplicate detection for active rows, such as accounts and contacts, to help address potential duplicates according to Microsoft. Housecall Pro automatically groups records based on matching details like Name, Mobile Number, or Email.
What happens to service agreements when you merge two customer records?
When merging customer and Location Records, any service agreements and proposals associated with the record are carried over to the merged profile according to ServiceTitan.
Can you merge more than two records at once in Microsoft?
No, you can only merge two records at a time according to Microsoft.
How long does it take for activities to sync after a merge in HubSpot?
It can take up to 30 minutes for all the records’ activities to sync according to HubSpot.
What is the merge limit for records in HubSpot?
You cannot merge records if they've been included in a combined total of 250+ merges, for example if Contact A and Contact B have been involved in 130 merges each according to HubSpot.