Autoresponder+ for ZC v1.3.x [support thread]
This is the support thread for the Autoresponder+ contribution.
This mod allows you to send a preset email to your customers after their order has finished.
You choose:
How many days after
Email subject and message
Features:
Supports text and html emails
Test mode
Enable/disable setting
Receive admin copy
Include customer name (various options)
Log sent emails
You choose the order status orders must have for the email to send. So if the order has been refunded or has not yet completed, customers are not bothered by an irrelevant email.
Requires a daily cron job to be scheduled.
Future plans:
Multiple preset emails
Include product details
This mod can be found in the Downloads section:
http://www.zen-cart.com/index.php?ma...oducts_id=1068
Re: Autoresponder+ [support thread]
A small bug has been found.
Some users may notice a Table Doesn't Exist error when loading autoresponder.php
In autoresponder.php, find this code:
PHP Code:
$sql2="SELECT DISTINCT OSH.orders_id
FROM " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " OSH, orders O
WHERE OSH.date_added like '".$order_day."%'
AND OSH.orders_status_id='". AUTO_ORDER_STATUS_ID ."'
AND OSH.orders_id=O.orders_id
AND OSH.orders_status_id=O.orders_status";
Replace with this:
PHP Code:
$sql2="SELECT DISTINCT OSH.orders_id
FROM " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " OSH, " . AUTO_TABLE_ORDERS . " O
WHERE OSH.date_added like '".$order_day."%'
AND OSH.orders_status_id='". AUTO_ORDER_STATUS_ID ."'
AND OSH.orders_id=O.orders_id
AND OSH.orders_status_id=O.orders_status";
This fix will be included in v1.1
Also in v1.1 will be the following features:
Support for 3 preset emails
Option to send emails to newsletter subscribers only
Validation preventing repeat loading
Re: Autoresponder+ [support thread]
Quote:
Originally Posted by
Steven300
A small bug has been found.
Some users may notice a Table Doesn't Exist error when loading autoresponder.php
In autoresponder.php, find this code:
PHP Code:
$sql2="SELECT DISTINCT OSH.orders_id
FROM " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " OSH, orders O
WHERE OSH.date_added like '".$order_day."%'
AND OSH.orders_status_id='". AUTO_ORDER_STATUS_ID ."'
AND OSH.orders_id=O.orders_id
AND OSH.orders_status_id=O.orders_status";
Replace with this:
PHP Code:
$sql2="SELECT DISTINCT OSH.orders_id
FROM " . AUTO_TABLE_ORDERS_STATUS_HISTORY . " OSH, " . AUTO_TABLE_ORDERS . " O
WHERE OSH.date_added like '".$order_day."%'
AND OSH.orders_status_id='". AUTO_ORDER_STATUS_ID ."'
AND OSH.orders_id=O.orders_id
AND OSH.orders_status_id=O.orders_status";
This fix will be included in v1.1
Also in v1.1 will be the following features:
Support for 3 preset emails
Option to send emails to newsletter subscribers only
Validation preventing repeat loading
Thanks Steven,
I've been looking for this Mod.
1. I'd like to ask if you will have more preset conditions like those by Magnetic One Similar mod?
2. Will you haave Subscribe/Unsubscribe option for these emails?
3. Request Customers to Post Products Reviews for products they have purchased?
Re: Autoresponder+ [support thread]
Quote:
Originally Posted by
nguyenkhv
I'd like to ask if you will have more preset conditions like those by Magnetic One Similar mod?
What preset conditions would you like to see implemented? I may be able to code them.
Quote:
Originally Posted by
nguyenkhv
Will you haave Subscribe/Unsubscribe option for these emails?
v1.1 has an option where emails will only send to newsletter subscribers. Currently I don't plan on having an independent subscribe option for the autoresponder.
Quote:
Originally Posted by
nguyenkhv
Request Customers to Post Products Reviews for products they have purchased?
This is likely to be in a future version, but not in v1.1. You can of course send out generic emails using the autoresponder that ask for product reviews (see mod's read_me for how I did this), but presently no product details can be included.
For those interested, v1.1 should be available sometime next week.
Re: Autoresponder+ [support thread]
Hi Steven,
preset conditions such as:
Send automatic emails to customers who have placed an order within a time frame . i.e. 2 weeks.
about:
New Products (select only those which are related-same subcategories to products purchased by the customer)
Special Products(select only those which are related-same subcategories to products purchased by the customer)
Best Seller Products(select only those which are related-same subcategories to products purchased by the customer)
Featured Products(select only those which are related-same subcategories to products purchased by the customer)
Most Viewed Products(select only those which are related-same subcategories to products purchased by the customer)
Also Bought Products(select only those which are related-same subcategories to products purchased by the customer)
Thanks for putting your time and making your code available for all of us here.
Re: Autoresponder+ [support thread]
HI Steven,
I would like to have these capabilities when sending out emails either manually or set automatically.
Send promotional emalls to:
1. who have registered but have not placed an order for a particular time: i.e. 1, 2or 3 months.
2. who have placed an order in the past, but has been inactive for a period like 2 , 3 months.
3. who are very active: placed at least 1 order in a time frame. i.e. 1 week.
4. who placed orders with an average amount range from $x to $y.
5. who barely login or login frequently.
Re: Autoresponder+ [support thread]
I like the idea of a feature for sending emails to customers who have registered but not purchased. I'll see if I can implement this, and maybe some of your other requests, in a future version.
Re: Autoresponder+ [support thread]
Hello Steven,
I downloaded the latest version, installed on ZC1.38a. Set it in live mode. set admin email to true. However, I still cannot get any email to the admin even thought the Cron Job is ran successfully.
Do you think someting wrong with my built in default Product Nofification of Zen Cart?
Because I nver get my product email notificaiton to work on my admin/tools?
Does your mod use the same code as does the ZC product notification?
Regards,
Re: Autoresponder+ [support thread]
Hi, if you're not receiving a copy of an email, it's very likely the original wasn't sent either. Do you know whether the live email was received by its recipient?
It could be you don't have the conditions set correctly. It could be an issue with your host's mail server. Maybe your email programme has started blocking things. Did you ever receive admin emails when in test mode? Maybe the cron job isn't set up right. What does the log show?
I'm not familiar with the Product Notifications code so I don't know how similar they are, but Autoresponder+ is in no way dependent on it.
Also which preset are you using? Preset #2 has a known problem caused by a typo. I only realised this last night and it will be fixed in v1.2 which I'm going to upload later today. In autoresponder.php, search for AUTO_MOD_2 and change to AUTO_MODE_2.
You could always try changing the admin email address to something else. In autoresponder.php, find this code:
$admin_email=STORE_OWNER_EMAIL_ADDRESS;
Change to something like..
$admin_email="[email protected]";
Re: Autoresponder+ [support thread]
v1.2 is currently pending approval.
This version adds the above feature whereby users can setup automatic emails for customers who have created an account but never ordered. It's quite robust in that the programme checks they haven't ever ordered just before sending out the email. It's also possible to email all account creating customers, regardless of order history.
I now have the structure to easily add additional queries, so this should be expected before long.
A typo in preset #2 is also corrected.
To upgrade to this version, a full uninstall of the previous version (if used) is required.
With v1.2, if you are having trouble triggering a test email, here are things to check:
Mod is enabled
Preset is enabled
Query set correctly
Test Mode is set
'Days After' set correctly
Subscribe Status is false
Time Validation is false
