In Blackbaud Altru you can’t simply delete a constituent’s email address if it is still the delivery email on their sales orders. You have to open each order and remove it there first, which gets slow when someone has 10 or 20 orders. Social Good Software’s Deduper adds a Remove email button that does all of it in one pass: it clears the address from every sales order where it matches, makes another email primary if the record has one, then removes the address from the constituent.
If the record has no sales orders, you can delete the email in Altru directly. How to remove a shared email from one member of a membership shows that manual route.
Before you start: removal can’t be undone. Download a backup of your Deduper data first.
Steps
- Refresh your data (0:47). In Deduper, pull in new data from Altru so you’re working with current records.
- Find the record (0:58). Go to Constituents, click Find duplicates, and open the duplicate pair (1:18). In the video, two different people share one email address, so instead of merging, the email is removed from one of them.
- Click Remove email (2:44) on that record and select the email address field you want to remove, then click Next.
- Back up first (3:30). The warning says the action can’t be undone or restored. Go back to Deduper, click Download and save the data as an Excel file.
- Review the steps and agree (4:16). Read what the process will do (below), tick that you agree, and click Remove email address (7:15).
- Leave the window open (7:43). It can take a couple of minutes when there are many sales orders to check.
- Check the record in Altru (8:13). Refresh the constituent’s Contact tab; the old address is gone.
What Remove email does in Altru
- Queries Altru for every email address on the constituent record.
- Verifies that the address you chose is the record’s current primary email.
- Queries Altru for every sales order on the record.
- Checks each sales order. Where the delivery email matches the address, it is removed from that order. Orders with a different delivery email are left alone, so if 10 of 20 orders match, only those 10 change.
- If the record has more than one email address, one of the others becomes the primary.
- Removes the address from the constituent record.
If anything doesn’t match, for example a teammate already cleaned up the record and Altru returns no emails, the process stops with an error and makes no changes (6:45).
Common questions
Why won’t Altru let me delete the email address?
When the address is the delivery email on sales orders, it has to be removed from each order before it can come off the constituent record.
Can I undo a removal?
No. That’s why you download a backup from Deduper before you start.
Does it change sales orders that used a different email?
No. Only orders whose delivery email matches the address being removed are changed.
What if the record has a second email address?
One of the remaining addresses becomes the primary email.
How long does it take?
Seconds for a record with no sales orders, a few minutes for one with many. Keep the window open until it finishes.
Video transcript
Hey, this is Rick with Social Good Software. In this short demo I’ll walk you through how to use the Deduper application to go into a constituent’s record and detach an email address. This also detaches the email address from any sales orders attached to that constituent where the sales order email address is the same as the constituent’s email address.
I’ll head over to the Deduper application. I already have some data I’ve been playing around with, so I’ll pull in any new data that might have changed, and then we’ll see if we have any duplicates in our data set. We’ll give this a minute to run. That finished, so I’ll go to Constituents and click Find duplicates. It shouldn’t take long. So far I only have one duplicate, so let’s take a quick look at it.
Here we have two records, one from 2018 and one from 2020 that was added today. Ideally we’d merge these two, but for simplicity, what we want to do is go to Richard’s profile and detach this email address, and keep this record on file. Maybe this is a different Richard, not Rick’s actual account, and they’re just sharing an email address.
There are a couple of ways to do that. The new feature we added, Remove email, removes the email from the constituent whether or not it has sales orders. If it doesn’t have sales orders, you can go into Altru and remove it now without any issue. The problem comes when a constituent has 10 sales orders. Then you have to go to each and every sales order and remove the email delivery address from each order before you can remove the actual constituent email address. Let’s look at this record in Altru. If you go to Contact, there’s just the primary email address set there.
Back in Deduper, I click Remove email. It says you’re about to remove the email address from this constituent record and asks you to select the field for the email address you’d like to remove. I happen to know it’s the email address field, and it’s already selected, but if it isn’t selected for you, just select it. Then click Next.
Now we get a warning dialog: you’re about to remove the email address from this constituent’s record. This action cannot be undone or restored; please make your own local backups of any emails removed. So before you run this process, I recommend going back to Deduper, clicking Download and saving it as an Excel file, so you have a backup in case you need to restore it for whatever reason.
Back into Remove email, we select the email address again and review the warning. We already made our backup, so we’re good to go. Then it says that by starting this process you agree to the following steps. Deduper goes into Altru and queries it for all the email addresses attached to this record. Right now there’s only one, but if I add another, there are two, and it gets both. Then it verifies that the primary email address on this record is the one we’re removing. Next it queries Altru for all the sales orders attached to this record. This one doesn’t have any, but if it did, it would check each and every sales order to see whether this email address belongs to any of them. If the delivery email address is the same as the primary email address, it’s removed from that sales order. So if you had 20 sales orders and 10 of them had that primary email address, it would be removed from those 10, and the other 10 would keep whatever email address was used to create them.
If more than one email address is found, one of the other email addresses is set as the primary. Right now we have two, so once we run this, my Social Good Software address becomes the primary and the other one is removed and no longer exists. Finally, the address is removed from the constituent’s record. That’s the last step, actually deleting the email.
If the information above is incorrect, the process won’t complete and no action is taken. For example, if we query Altru and get no emails back, say because someone on your team already cleaned up this record, the process simply stops and gives you an error message saying that email is no longer valid. The same applies to every other step: if there’s any error, the process stops and won’t continue.
I agree to the steps above, and I’m ready to remove this email address. Once you click Remove email address there’s no going back, so make sure you have that backup first. We already made ours, so we’ll go ahead. This process can take a couple of minutes, so we recommend leaving the window open until the email address is removed. In this case it was quick, because there were no sales orders to look up. Sometimes it takes longer, sometimes less, so be patient and let it run.
Let’s check the constituent record. I refresh the page, and the contact information now shows just my Social Good Software address. The old email address was completely removed. At this point we’ve detached that primary email address and we’re done.
That’s how it works. If you have any questions, please reach out. We’re really excited to make this new feature available to you; it should save you a lot of time removing email addresses from sales orders. If you have suggestions on how we can make it better, we’d love to hear your feedback. I look forward to talking to you in the next one.



