Revert Merge Operation on HubSpot Records

When you ran the merge operation, you should have received an email containing the CSV report.

If you can't find the email, you can download the file from the Activity Tracker. Click on the relevant Run ID to download the CSV of records affected by the merge operation.

When contact records are merged, the email address from the master becomes the primary email, and the duplicate record email addresses are added as Additional Email Addresses. These additional emails need to be cleared from the master because when you add the duplicate records back in, the emails need to exist only on the duplicate record so they can be used as the unique identifier. If these aren't removed from the master, Insycle will identify them as existing records instead of new records needing to be imported.

Open the CSV report, and extract the Master record rows into a new CSV file. Include only the Record ID in the new file.

In the Data Management > Magical Import module, upload the new CSV of master records. 

In Step 1, resolve any warnings that appear.

Under Step 2, set the Identity field to the Record ID.

In Step 4, under the Bulk Update tab, select the Additional Email Addresses field, and in the New Value dropdown, select Delete.

Under Step 5, click Import.

Learn more about importing from a CSV using Magical Import.

Open the original "insycle-bulk-merge" CSV report with all of the column and row data.

1. Remove columns for read-only fields:
   • Record ID
   • Deeplink
   • Create Date
   • Any other read-only fields from the merge
2. Remove any redundant columns, such as Email
3. Remove the merge operation columns:
   • Result
   • Message
   • Duplicate Group ID
   • Status

Save the CSV file.

In the Data Management > Magical Import module, upload the updated CSV. 

Under Step 2, set the Identity field (Email is a good one for contacts), and set the Records Mode to "Only create net new." 

Under Step 5, click Import.

All the duplicate records should import, and the masters won't since they already exist.

Remove Extra Associations from Master Records

When the duplicates were merged, all existing associations from the duplicates were automatically assigned to the master record—these associations need to be removed.

In the RevOps Acceleration > Associate app, you can use the Replace feature to remove any non-primary associations.

The Remove non-primary associations between Contacts and Companies template is a good place to start.

Under Step 1, filter for records where the "Primary Associated Company ID" exists, and also include criteria to target the records that have the associations you want to remove. Click Search and check to make sure the records you want to update are what appear in the Record Viewer at the bottom of the page.

Under Step 2, select the Replace action and configure the association. Set up the fields for the association your records should have. Don't worry about what currently exists, Insycle will take care of all the cleanup automatically.

Preview the changes and when this looks good, Update the records in HubSpot.

Learn more about using Insycle to add or remove HubSpot associations.

Add Associations to Duplicate Records

By default, HubSpot will automatically associate contact records to companies based on the email domain, but if you need more control over what associations are added or want to make additional associations, you can use the Associate app. 

Explore the templates for an existing solution that may be close to what you need.

In Step 1, filter the contact records down to those you want to associate with companies.

Under Step 2, define the rules that will create the relationship between the contacts and companies. 

Preview the changes and when this looks good, Update the records in HubSpot.

Learn more about using Insycle to associate HubSpot contacts to companies.

The HubSpot merge API that Insycle uses when merging companies, courses, deals, leads, listings, tickets, and custom objects deletes the duplicate records after the merge. These records can easily be recovered by accessing HubSpot's recycle bin.

In HubSpot, navigate to the object type. Click the Actions menu and select Restore records. 

All deleted duplicate records from the merge will be available for restoration on the Restore page, complete with all associations, activities, history, and field values.

Learn more about HubSpot's Restore Records feature.

When company records are merged, the domains of the duplicates are reassigned into the master record's Additional Domains field. Before restoring the merged companies, these additional domains need to be cleared from the master.  When you add the duplicate records back in, the domains need to exist only on the duplicate record to be used as the unique identifier. If these aren't removed from the master, Insycle will identify them as existing records instead of new records needing to be imported.

Open the CSV report from your email or the Activity Tracker, and extract the Master record rows into a new CSV file. Include only the Record IDs for the rows where the Status is "Master."

In the Data Management > Magical Import module, upload the new CSV of company master record IDs. 

In Step 1, resolve any warnings that appear.

Under Step 2, set the Identity field to the Record ID.

In Step 4, under the Bulk Update tab, select the Additional Domains field. Leave the New Value field blank to clear any existing values.

Under Step 5, click Import.

Learn more about importing from a CSV using Magical Import.

When the duplicates were merged, all existing associations were automatically assigned to the master record—these associations need to be removed. Activities such as notes, emails, or tasks from the duplicates that were assigned to the master record cannot be removed.

In the RevOps Acceleration > Associate app, you can use the Replace feature to remove associations.

Under Step 1, filter for records where the number of associated records > 0, and also include criteria to target the records that you are unmerging. Click Search and check to make sure the records you want to update are what appear in the Record Viewer at the bottom of the page.

Under Step 2, select the Replace action and configure the association. Set up the fields for the association your records should have. Don't worry about what currently exists, Insycle will take care of all the cleanup automatically.

Preview the changes and when this looks good, Update the records in HubSpot.

Learn more about using Insycle to add or remove HubSpot associations.

Note that there is no cleanup action needed for the duplicate records since HubSpot's restore function includes all associations and activities.

When setting up your merge operation in the Merge Duplicates module, add extra fields to be included in the CSV report, in case you need them later for undo and/or just for general review.

Under Step 4, on the Record tab, add any key fields to the bottom of the list. You may need to experiment with the Conditions, depending on the field type.

Before running a large merge operation, export all records directly from HubSpot to a CSV file.

In HubSpot, navigate to the object type and click Export. Select the file format, "CSV," and include "All properties on records."

Yes, HubSpot's Restore records feature can work with Salesforce sync active. When you restore a record in HubSpot, the changes are reflected in your HubSpot database. If the Salesforce sync is active, these changes will eventually be reflected in Salesforce, depending on the sync settings and frequency.