The usual way staff find out an event has sold out is not great: a guest emails asking why they can’t buy tickets, or someone at the front desk tries to sell a seat that isn’t there. By then the marketing team may still be running ads for it, and nobody has opened a waitlist.
Short version: Altru knows when a program or event has hit capacity, because it stops selling. What it doesn’t clearly do is tell a person when that happens. As far as we know, there’s no built-in “email me when this sells out” setting. If you think your version has one, ask Blackbaud support or test it in your sandbox before you build a process around it. Until then, you can get close with queries and a simple routine.
What Altru already does at capacity
Once a scheduled program or event reaches its capacity, Altru stops further sales through daily sales, advance sales, and your web forms. So the system itself won’t oversell. What’s missing is the human side:
- Nobody is notified, so the event page on your website may still say “Get tickets.”
- Paid ads, social posts, and email campaigns keep sending people to something they can’t buy.
- Staff can’t decide in time whether to add capacity, open another time slot, or start a waitlist.
A notification only helps if someone does something with it, so set up the response before you set up the alert.
Build a “close to capacity” query
The most useful report doesn’t say “sold out.” It says “almost sold out,” which gives you time to act. Build a query on your scheduled programs or events that returns:
- The event or program name and date/time.
- Capacity.
- Tickets sold or registrations so far.
- Remaining spots, or percent sold if you can calculate it.
Filter to future dates only and sort by remaining spots, lowest first. Anything with fewer than, say, 10 spots left (or more than 85–90% sold, whichever fits your venue) shows up at the top. The exact fields you’ll use depend on whether you sell these as program tickets or manage them as events with registrants, so try both query sources and see which one returns accurate counts. Before anyone relies on it, check the numbers against a couple of events you know well.
If you sell more than one price type or package against the same capacity, look at whether the “sold” figure counts every admission or only some of them. Mismatched counts are the most common reason one of these reports gets ignored.
Get the query in front of someone
A query nobody opens is not an alert. Some options, from simplest to most involved:
- Make it a daily habit. Give one person the job of running the query at the start of each day, and a backup for days off. It’s low-tech, but it works if it’s on someone’s list.
- Put it where staff already look. If your team uses Altru’s home page, dashboards, or a shared query folder, put the capacity query there so it’s seen without anyone hunting for it.
- Check whether it can be scheduled. Some Altru setups can run queries or exports on a schedule. Whether yours can email results to staff depends on your configuration and permissions. Ask Blackbaud support what’s available to you.
- Move the data out. If you already export Altru query results to a spreadsheet or another tool, a sheet with conditional formatting or a simple threshold rule can flag low inventory. This works as long as the export runs often enough for your sales pace.
How often should you check? It depends on the event. A members’ preview that sells out in an hour needs someone watching on launch day. A summer camp that fills over three weeks is fine with a morning check.
Decide what happens when it fills
Write a short sold-out checklist and store it with the query. A typical one:
- Change the website event listing and any calendar embed to show “Sold out,” or link to a waitlist.
- Pause paid ads and remove the event from upcoming email sends.
- Tell the front desk and phone staff, including what to say and whether they can override capacity.
- Decide whether to add capacity or another session, and who has the authority to approve it.
- Start the waitlist, even if it’s just a simple form, and record who will follow up if spots open.
Spots also open up through refunds and exchanges, so take the event off the alert list but keep it on the query. If remaining capacity goes back above zero, someone should know before the waitlist goes stale.
Quick answers
Will Altru oversell an event if we don’t watch it?
Not through normal sales channels once capacity is set correctly. The risk is staff overrides and capacity that was entered incorrectly to begin with, so check capacity when you build each event.
Can we get alerted at 75% instead of 100%?
Yes, if you build the query on remaining spots or percent sold. That threshold is usually more useful than a sold-out alert, because you still have time to act.
Is there a native sold-out notification we’re missing?
We’re not aware of one, but Altru changes over time. Ask Blackbaud support directly, and test anything they suggest in a sandbox with a small, low-capacity test event.
