Merging Organizations in NPSP

I have recently been volunteering for a Non-Profit organization to gain experience, specifically with the Non-Profit Success Pack/Cloud (NPSP) from Salesforce. Recently, one of the requests was to merge an Organization. Our initial thinking was to use the Manage Households button; however, I quickly learned that this only works for the Household Account Record Type and is specifically designed to move people around from one Household to another.

After some further digging, I realized that the merging of Organizations works the same way as it does for Lightning Sales cloud. To successfully merge Organizations, two things are required: at least one Matching Rule and one Duplicate Rule. Luckily, Salesforce provides some Matching Rules out of the box. Their information can be found here

Once you have a Matching Rule with the criteria you want to catch those pesky duplicates, you can create a Duplicate Rule using that Matching Rule. 

Lastly, there is one more step you will need to do, specifically in Lightning. You will need to add the Duplicate component to the Lightning Record Page – this is what will indicate on the record that you have a duplicate Organization and allow you to merge them. Below I will walk through the steps of putting all of this together.

Creating a Matching Rule (only if the standard does not work):

  1. Pick the Object you want to match against, in this case Account (Organization is a relabel specifically for the NPSP)
  1. Set up the criteria that you want to match against
  1. Activate the Matching Rule

Creating a Duplicate Rule

  1. Pick the Object you want the Matching Rule to run on
  1. Indicate if you want to just Alert, Report, or Block if a Duplicate is found
  1. Pick the relevant Matching Rule
  2. Activate the Duplicate Rule

Updating the Lightning Record Page

  1. Go to the Lightning Record Page for the relevant Object
  2. Add the Potential Duplicates Component to the page
  1. See it in action

Once you have it on the page and the system detects a duplicate you can use the link within the Component to do a merge of the found duplicates.

For another example of this, please check out my article on Lead deduplication.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s