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
Hello Stacey,
You could create (or have someone create) a service interceptor plugin that is triggered for every order. In there you can have your business logic for generating and sending the email.
Regards,
Jon
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.
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.