We've got a Foxycart project we're working on that requires send out email notifications for the following scenarios:
* Credit Card expiration notice: your card is about to expire
* Your Subscription End-Date is Approaching -- Please Re-Subscribe (non-recurring billing subscribers):
* Your Subscription Has Ended - Thank You for Being a Subscriber
** 1) If a credit card expires and the subscription end-date is reached
** 2) If subscribers do not re-subscribe and the subscription end-date is reached (non-recurring billing subscribers)
* Your Password Has Been Changed
The client mentioned they contacted support for support and got this response:
As for notices for subscriptions and credit cards that are about to expire, there is currently no native way to send these messages to customers. But you can receive notices (even for cancellations) by using the subscription XML datafeed. For this to be effective, you would need to add some custom server-side code on your end that would act as mailers, etc. You can automate it on your end to send out a notice to subscribers whenever you receive the subscription datafeed for their specific subscriptions.
Apart from the information provided above, do you have any further guidance? We assumed this functionality does not exist in the Foxyshop plugin we're using on the client's WP site so we tried to run a CRON job to pull this data using the Foxycart subscription xml datafeed.
What we did yesterday was to pull all the active subscriptions but the problem is that the results are paginated (meaning all the data is not dumped at one time but in segments), so we still need to figure out how to grab all other subscription's information.
We can check the end date and send out "Your Subscription End-Date is Approaching" as well as "Your Subscription Has Ended - Thank You for Being a Subscriber". The challenge though is that in order to do a credit card check, the credit card nor customer info is included therefore we need to reconnect to fc to get the info. On 1k results, for example, we will have to connect to foxycart for every single record to grab customer details and then check the cc expiration which will probably result in a time out or error.
We just need to figure out if there any other effective ways to grab all subscriptions with custom details.