5568 Sell-out Alerts

We have been requested to give sell out alerts to our clients. This should be able to send them an email stating what was sold out. They should be able to decide if some or all categories are to notify them and they should be able to select which user emails should get this alert. The same all or selected event times should be available for alerts. I am thinking this could be a new column on the "Email Notifications Settings" table that is found on the users page of an event. This button and window could be renamed to, "Notification Settings". Then we could add a column to the existing table called, "Sell Out" that each user could select if they want to be notified.

Then below the user table of settings we could have a header that says, "Sell Out Notification Settings". Below the header you could have a checkbox that says, "Send notice for all categories". This should be checked by default, but if it is unchecked they see a list of categories that they could select specific categories to be notified for. They should also see a checkbox that says, "Send notice for all event times". If this is unchecked the list of event times would appear that they could select specific event times to generate sell out notification emails for selected users. Ticketing/Registration checkbox settings should only appear if it is relevant to the event, and both should default to on for all.

We should send the emails by a scheduled cron that runs every half hour.

The alert subject line for the email would say: "Event Sell Out Notification"
The body of the email should be:
(User First Name),

We want to congratulate you for selling out the following:
(List of categories and event times that have sold out during this latest cron)

You may want to publish this great news by email or social media. Thanks for your business!