New feature: Bulk Merge for Duplicates

Yas, we've got the feature of manage duplicates that's great. One thought is there's no way to bulk merge of contact and company duplicates, and you'll need to go through one by one manually. 

 

I'm wondering if there's a better way for us instead of deduplicating one by one, which is literally unrealistic for enterprise users with mass contacts. In our case, we have 1890 duplicates for contacts, which requires going through 1890 times of deduplicates.

 

New feature request: Bulk Merge 

HubSpot updates
changed to: In Planning
2 weeks ago

Hi Community! 

 

I'm going to move this to "In Planning" our team is looking into the best way to deliver on quicker merging. I will update the issue when we know more. 


Best,

Ian

54 Replies
New Contributor

Just to expand on my earlier 'contribution'. This is wasting a lot of time for me and my team. Aka costing us money. 

 

Another issue is that if I deduplicate companies (accounts) on salesforce, nothing happens in hubspot. So, I need to go into Hubspot too and do the same deduplication. 

 

It's not really an integration if this happens.. well, maybe a half baked 'sync' at best. 

Regular Contributor

@Michael_1 and @Msyvrais Can we talk? I'd like to get you in touch with my support team to get the nitty gritty details. We're working on a perfect Salesforce <> HubSpot deduplication sync and need feedback from people like you who are really feeling the pain of this problem.

New Member

Yes- I cast my vote for a bulk merge for duplicate contacts

New Contributor

100% agree, this would be really helpful to a lot of people. Upvoted the main post but commenting as a vote itself too, thanks HubSpot team!

New Member

Agreed. We need this. We have over 2000 contacts and I'm not wasting my time to do this one by one.

Occasional Contributor | Diamond Partner
Occasional Contributor | Diamond Partner

Yes we def need this 

Occasional Contributor

That would be an amazing fix. 

This would help data analysts a lot. 

Visitor

100% agree! upvote upvote!

 

 

New Contributor | Platinum Partner
New Contributor | Platinum Partner

Yea this would be an incredible feature. The biggest challenge is finding the duplicates! If there's some sort of special merge section where we can identify companies or contacts that share certain properties, i.e. phone number, location, and part of name. And then we get a list of all "suggested" duplicates and then approve those and merge in bulk. That would be amazing. Sometimes the company names are similar but they are different and other properties give clues. But merging 100s of duplicates out of 1000s of companies is a really time-consuming task!

Occasional Contributor | Gold Partner
Occasional Contributor | Gold Partner

Hey @Michael_1, I believe I can help you out with this. 

 

So, when you deduplicate accounts in Salesforce, the master is kept in sync with HubSpot, but the duplicate company in HubSpot remains. This is because the duplicate HubSpot company is trying to sync with the corresponding Salesforce account but cannot find the Salesforce Account ID anymore because it was merged with another record in Salesforce. So this is the reason why you have to handle the deduplication twice on both platforms, because the sync is effectively broken for those records when you conduct the merge in Salesforce. 

 

Additionally,  you cannot merge duplicate HubSpot companies when the Salesforce integration is active. To merge duplicate companies in HubSpot, you need to uninstall the integration, deduplicate your company records, then reinstall the integration. This is a huge pain — probably not worth it 95% of the time and there is no easy workaround.

 

However, using Insycle, you can deduplicate companies/accounts across both platforms, in bulk, using any data field to identify the duplicates, while keeping your sync in place. I won't go into the specifics of how it works too much, but essentially this is done by creating a custom field, "Deduplication Master Record," on both platforms. Insycle automatically populates the correct master record with "Yes," and then allows you to merge duplicate HubSpot companies into that record, while keeping the Salesforce sync active. 

 

dedup-master-record.png

 

Full disclosure — I work for Insycle. But it sounds like this is costing you guys time and money so it might be something you are interested in. 

 

If you'd like to learn more about how it works, we recently put together a big guide on the subject of merging HubSpot/Salesforce duplicates and keeping the sync in tact (works for contacts/leads/accounts/companies), here: How to Merge Duplicates in HubSpot and Salesforce and Keep them Syncing

 

 

 

Occasional Contributor | Gold Partner
Occasional Contributor | Gold Partner

Edit: Accidentally posted this twice.

HubSpot Product Team
HubSpot Product Team
updated to: In Planning

Hi Community! 

 

I'm going to move this to "In Planning" our team is looking into the best way to deliver on quicker merging. I will update the issue when we know more. 


Best,

Ian

Occasional Contributor

I'm in agreement. We need a way to bulk manage duplicates.

Occasional Contributor

@ianleaman No that it is in planning, something else to consider is merging contacts with a common property that is not the domain. 

We have "Company ID's" for users. But what happens is that when the user does not have the same domain they just stand-alone and you never know they are part of a company that already exists. 

 

It will be merged to either bulk merge companies with similar name or contacts/companies with the same ID (Not HubSpot ID) or another criteria.