Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Credit Card Charge Reminder


gtrusler

Recommended Posts

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

Link to comment
Share on other sites

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

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

DTOM - mmm' k

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...