Merge duplicate customer Accounts together into one Account
Steps to merge multiple Accounts into one:
Related Help Guide Pages
Learn how to merge duplicate Accounts
When you have duplicate records in your platform, such as the Account being listed two or more times, it can quickly become tricky to search through, sort, use, and report on your information. The merge functionality in your accessplanit platform resolves these problems! Merging consolidates two or more separate records into a single one, to eliminate duplicate data and ensure your data is easier to keep up to date within your platform.
Follow this page to learn the steps for merging multiple Accounts together into one Account.
Merge multiple Accounts into one
Merging duplicate Accounts is a great way of ensuring your records are up to date, follow the steps below to learn how to merge duplicate Account records together
Open the ‘Accounts’ DataGrid from your main navigation menu on the left
This will take you to the Accounts DataGrid
Find the Account that you wish to merge by applying filters and/or searching the Account’s DataGrid
Select the duplicate records by clicking on them so that they highlight blue
Click the mass action drop-down at the top left of your DataGrid and click the ‘Merge’ option
The ‘Merge Accounts’ pop-up window will appear, click the ‘Select’ button on the ‘Record to Keep’ option
Your selected Account records will appear, we advise adding the ‘Account ID' column so you can ensure you are keeping the correct record
Visit our dedicated page to add a new column to your DataGridSelect the Account record you wish to keep by ticking the Checkbox and highlighting that Account
The Account you select here determines what information will be kept where there is a clash, for example, if the Accounts being merged all have a different Name, following the merge the Name that will be maintained, is the one assigned to your ‘Record to keep’ Account.Click the ‘OK’ button
This will add the Record to the ‘Record To Keep’ selector
Click the ‘Merge’ button to merge the records
A pop-up will appear asking you to confirm that you want to merge the Selected Accounts, click the ‘Yes’ button to confirm
Your Account records have now been merged
Choosing a primary Account during a merge
When two Accounts are merged, as much info as possible is kept, e.g. If only one of the Accounts has an email address, this email address will be assigned to the Accounts after the merge.
The reason for the primary selection is that when both Accounts in the merge have an email address, if this email address is different, the Account can’t have both after the merge, so the email address from the primary Account will be remembered.
This table shows an example of which information will be kept about an Account when a merge is completed
Account 1’s details | Account 2’s details | If Account 1 is the selected primary | If Account 2 is the selected primary |
|---|---|---|---|
Peter Jones & Son | Peter Jones Inc. | Peter Jones & Son | Peter Jones Inc. |
| |||
012345 6789 | 012345 6789 (ext. 1) | 012345 6789 | 012345 6789 (ext. 1) |
| 1 New Street, New Town | 1 New Street, New Town | 1 New Street, New Town |
Group: Planning | Group: Construction | Group: Planning , Construction | Group: Planning , Construction |