Mass Merge Accounts, Contacts, and Leads

Mass merging Accounts, Contacts, and Leads in XL-Connector 365 works the same way as if you were to merge two or three records in Salesforce, except that XL-Connector 365 lets you merge four or more records in one shot.

The merge operation will do the following with the records:

  1. Delete all records identified as ‘victim’.
  2. Move all child records from the deleted ‘victim’ records to the winning ‘master’ records.
  3. If there are field mappings present during the operation – values from the mapped columns will overwrite values in the corresponding fields of the ‘master’ records. If more than one ‘victim’ records are being merged to one ‘master’ record – the last row with a value in the corresponding mapped column will win.

Below are step-by-step instructions with screenshots describing merging of nine contacts into one. Here’s a sample dataset we have prepared where the first contact will be the ‘master’ or winning contact, and the rest will be merged into it:

We’ll need to manually add a Master Id column to the data to be able to specify master Ids for the merging Contacts. We did it by copying the Id of the first Contact and pasting it to the Master Id column in all the contacts that are being merged:

To start the merge operation, select the rows that you want to process and click on Admin tools -> Merge records in the XL-Connector 365 Home page:

The subsequent dialog box, select the object type that we are merging (Contact in this case), the Master ids column, and the Victim ids column:

If you don’t have any field values that you’d like to override on the Master record, don’t click the Mappings button. At this point you can click on the Run and Save button to execute the merge. In our example though, we want to overwrite the Phone field on the master record with a phone number of one of the ‘victim’ Contacts. Therefore, we’ll need to click on the Mappings button and map that column to the Phone field on the Contact object:

With the above mappings, the last row that has a value in the Phone column will win and override the Phone value in the Master record:

After the mappings have been confirmed, click on Run and Save to run the operation for the selected rows:

The merge operation will be performed for each row and the results will get populated at the right from your data, one column over:

All the merge settings and mappings are also saved as a reusable Flow Step in the same sheet. This way you can run the same operation from the same sheet repeatedly from the Flows tab of XL-Connector 365.