Community Add-Ons
| Maintainers: | wwsmith64 |
 Add file to this package |
|
order_status_email
for osCommerce Online Merchant v2.2
The Order Status Emails modification allows the admin to define a set of emails for the purpose of post sale follow up. These emails are valuable for service and marketing.
The store admin can define any number of emails for any of the order statuses used by that store. When a customer order has been in that status for the specified number of days, the email is sent.
Only exact matches on the days_out field work. Therefore if you define a follow up email for Pending 6 Days, no one who has been pending for more than 6 days will get the mail.
An agent process, cron.php, queries the database and sends the emails. It is essential that this process be run every day, or some emails may be missed. It is recommended that cron.php be called as a cron job. Instructions below.
A limited number of dynamic fields are included in the modification However, the possibilities are endless. For example, emails could be constructed to ask customers to post reviews for each product in their cart. Check CompleteWebStores.com for more information on support or expanding this modification.
Download 
Report
I got this error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from,subject,message,mail_type from orders_status_emails' at line 1
select id,orders_status_id,days_after,from,subject,message,mail_type from orders_status_emails
[TEP STOP]
It turned out that a database field was called "from"which is also a command. It does in fact work, but when you use oscommerce backup feautere, you get mentioned error and it messed up the backup.
Hope it helps you