Merge duplicate customer Accounts together into one Account

Merge duplicate customer Accounts together into one Account

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.

image-20241121-102802.png

 

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

 

  1. Open the ‘Accounts’ DataGrid from your main navigation menu on the left

    Main navigation menu - Accounts selected

  2. This will take you to the Accounts DataGrid

    image-20241121-102940.png

  3. Find the Account that you wish to merge by applying filters and/or searching the Account’s DataGrid

    image-20241121-103048.png

  4. Select the duplicate records by clicking on them so that they highlight blue

    both accounts highlighted

     

  5. Click the mass action drop-down at the top left of your DataGrid and click the ‘Merge’ option

    mass action - merge option selected

     

  6. The ‘Merge Accounts’ pop-up window will appear, click the ‘Select’ button on the ‘Record to Keep’ option

    Merge accounts pop up

     

  7. 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 DataGrid

    both accounts showing within datagrid

     

  8. Select 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.

    record to keep highlighted

     

  9. Click the ‘OK’ button

    OK button

     

  10. This will add the Record to the ‘Record To Keep’ selector

    record selected now showing in field

     

  11. Click the ‘Merge’ button to merge the records

    Merge button

     

  12. A pop-up will appear asking you to confirm that you want to merge the Selected Accounts, click the ‘Yes’ button to confirm

    confirmation pop up

     

  13. Your Account records have now been merged

    single account now showing in datagrid

 


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

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.

peter@email.com

 

peter@email.com

peter@email.com

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


Contact Our Team

If you can't find what you're looking for, access our Support Portal, and our team of experts will be happy to help!

Follow Us

Facebook|height=20 LinkedIn|height=20 Instagram|height=20 Twitter|height=20

Copyright © 2025 accessplanit.

Social media icons by icons8.com