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!
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.