I want a script/program that will send emails to our customers automatically 2 weeks after they have ordered from us to prompt them to:
a)leave a review on our website - if order status is paid
b)pay for the order - if order status is pending
c) leave feedback - if order status is cancelled
It needs to sit on our server and access the customer/product/order records within our MySQL database on a daily basis.
The emails will need to be fully customisable for each person, to include their name, the date they ordered, the first item they ordered, and the status of the enquiry etc.
Plain text emails is okay
We will need to be able to alter all variables ourselves when needed once established but this can either be done at script level or through a made up interface - the time from order placement to email being sent, the email subjects and body contents, what fields to include in each email etc.