Remove an Email from an Altru Record with Sales Orders
← Back to Blog

How to Remove an Email Address from an Altru Constituent That Has Sales Orders

June 15, 2020

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

  1. Refresh your data (0:47). In Deduper, pull in new data from Altru so you’re working with current records.
  2. 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.
  3. Click Remove email (2:44) on that record and select the email address field you want to remove, then click Next.
  4. 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.
  5. 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).
  6. Leave the window open (7:43). It can take a couple of minutes when there are many sales orders to check.
  7. Check the record in Altru (8:13). Refresh the constituent’s Contact tab; the old address is gone.

What Remove email does in Altru

  1. Queries Altru for every email address on the constituent record.
  2. Verifies that the address you chose is the record’s current primary email.
  3. Queries Altru for every sales order on the record.
  4. 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.
  5. If the record has more than one email address, one of the others becomes the primary.
  6. 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.

Continue reading

How to Track Instructor Activity for Scheduled Programs in Altru

How to Track Instructor Activity for Scheduled Programs in Altru

“How many classes did Maria teach last spring, and which ones?” It sounds like a question Altru should answer in ten seconds. In practice, many education departments end up digging through calendars, email threads, and a payroll spreadsheet to piece it together, because the instructor was never recorded anywhere a query could find. Altru is

How to Turn a Group Sales Overpayment Into a Donation in Altru

How to Turn a Group Sales Overpayment Into a Donation in Altru

A school books a field trip for 60 students, sends a check for the full quote, and then 48 kids show up. The teacher says, “Keep the difference, it’s a gift.” Now you have a group sales order that is overpaid, money that is really a donation, and a deposit that has to balance. The

Can a Spouse Be a Fundraiser in Altru? Solicitor Credit for Couples

Can a Spouse Be a Fundraiser in Altru? Solicitor Credit for Couples

It happens more often than you’d expect. A board member and her husband both care about your capital campaign. She asks a friend for a gift, but it was really his introduction and his follow-up phone call that closed it. Development wants him credited as the fundraiser on that gift. Then someone at the desk

Social Good platform

See it in action

Get started with Social Good

Book a demo to see Social Good Software in action for Altru.

Book a Demo
Social Good platform

See Social Good in action

Tell us a bit about your organization and we’ll take you straight to short demo walkthroughs of the software.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.