I'm hoping someone here has already done this...
We're looking into what it would take to have an email generated upon purchase - not an order confirmation but more of a marketing email (like a triggered email?).
I have some idea how to do this with the web orders - but am not sure how to get it happening with purchases through the client. We are hoping to automate as much as possible and make it a sustainable/ongoing process (i.e. not requiring the setup of multiple appeals... if possible).
Does anyone else have something like this set up? Can you point me in the right direction to get started?
Many thanks,
Stacey Voigt
Database Manager Santa Barbara Center for the Performing Arts (805)899-3000 x128 svoigt@granadasb.org
Chris,
I really like this idea! Do you have something like this running? Or does anyone else? I would love to see an example of what this procedure might look like.
Stacey
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chris Jensen Sent: Thursday, February 19, 2015 2:31 PM To: Stacey Voigt Subject: Re: [Tessitura Technical Forum] Additional emails upon purchase
Another option, depending on how rapidly you want an e-mail generated, would be a simple SQL Agent job, running a stored procedure, which could do the same thing, but on a schedule rather than a trigger, i.e. run the job every hour, or every 15 minutes, or whatever, checking for qualifying orders, and then sending e-mail(s) when it finds some.
From: Stacey Voigt <bounce-staceyvoigt1752@tessituranetwork.com> Sent: 2/19/2015 3:07:50 PM
Thanks Jon, I suspected it might be something like that. I'll dig deeper... I'm brand new to the world of interceptors but I'm sure we can find someone to create one for us if we go this route.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi Stacey, we have a setup like this. A SQL stored procedure called by a SQL job every few minutes to send out confirmation emails for qualifying orders (determine by pre-set criteria). We use it for both single ticket and subscription orders. We use an embedded HTML template inside the SQL stored procedure to format our email. You can easily modify the code to use for other purposes. We don't use the Tessitura canned one. This one gives us much more flexibility.
Mo
National Ballet of Canada
We use the system stored procedure sp_send_dbmail to send HTML emails out within the organization. You could use it to send order confirmation emails. Possible executing from a scheduled job.