Credit Card Charge Reminder

[gtrusler]

I'm looking for a way to send out an automated message to my customers reminding them that they made a purchase from me with the date and amount. I would either like to send it out on a particular day of the month or with about a 2-3 week delay after the original order. I'm trying to reduce the number of "I don't recognize this charge" messages.

 

Thanks,

Graydon

[mattice]

You could do an sql query that will select all the orders that meet certain criteria:

 

- status = shipped

- payment = creditcard

- date = nn days ago

 

Use the outcome of those orders to fetch the clients e-mail addresses and feed them to your e-mail script...

 

HTH

Mattice

[gtrusler]

That's a good suggestion. However, I was hoping for something a little more automated that may have already been put toghether. I'd prefer just to "turn it on" and not have to touch it any more.

 

Thanks,

Graydon

[spin]

I'd prefer just to "turn it on" and not have to touch it any more.

 

If you are running the right type of server setup, this automated script could be tied to a crontab running on a daily basis. Don't underestimate the power of the cron!

 

Hope this helps!