I have modified the script modules/followup/followup.php in this way:
/* For all validated orders, a discount if re-ordering before x days */ private function reOrder($count = false) { $email_logs = $this->getLogsEmail(2); $sql = ' SELECT o.id_order, c.id_cart, o.id_lang, o.id_shop, cu.id_customer, cu.firstname, cu.lastname, cu.email FROM '._DB_PREFIX_.'orders o LEFT JOIN '._DB_PREFIX_.'customer cu ON (cu.id_customer = o.id_customer) LEFT JOIN '._DB_PREFIX_.'cart c ON (c.id_cart = o.id_cart) WHERE o.valid = 1 AND c.date_add >= DATE_SUB(CURDATE(),INTERVAL 15 DAY) AND c.date_add <= DATE_SUB(CURDATE(),INTERVAL 10 DAY) AND cu.is_guest = 0'; //psubiaco: send followup_2 email between 10-15 days from order - modified the last 3 lines
I hope it works, cannot check now.
Then, I added in each file modules/followup/mails/*/followup_2.html a sentence asking the customer to leave a review on google and facebook.
Maybe this can help... sending review + discount after 10 days from order is nice and helpful.
Regards.
Paolo