Autoresponder+ for ZC v1.3.x [support thread]

[Steven300]

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

[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:

$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:

$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

[nguyenkhv]

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:

$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:

$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?

[Steven300]

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.

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.

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.

[nguyenkhv]

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.

[nguyenkhv]

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.

[Franck69]

I can run the script via browser and it works well. However, when my cronjob run it, I get nothing. I see nothing in error_log so I put some echo in the script and redirected the cron output to a txt file, in order to trace where it fails. I seems that it can't pass the require at top of the script... because it prints 111- but not 222- in my txt file.

echo "111-";
require('includes/application_top.php');
echo "222-"; 

Any idea why it works via IE browser but not via cron job?

Thank's

[Franck69]

I've finally fixed the problem by creating a absolute symbolic link one directory below public_html where I've placed the autoresponder script. This was made in order to allow autoresponder script finding the includes...

includes -> /home/invoca/public_html/includes

NOTE: this is related to this problem:

http://www.zen-cart.com/forum/showpo...2&postcount=32

[CoolCarPartsOnline]

Hey Steven
I read in the beginning of this thread request for sending emails after the customer place the order, I wondering if you ever were able to code this mod to send email to customer after they place the order.
I think this would be a great additional if the store owner was able to follow up with the customer a few weeks after the order.
In my case I want to be able to send the customer an email a week or two after I ship the item to follow up on the order and maybe request a Testimonial or a Review for the product they bought.

A lot of people forget to come back to the store and leave testimonial or reviews for the product so this would be a quick reminder.

Do you have any plans for adding such function?

[Steven300]

Hi at the moment I don't have any plans to include product details in the emails. I think it would require a lot of work to do this feature properly, and unfortunately I have other projects to focus on. If anyone wants to add this feature, they're more than welcome to do so.