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

patski:

problem gone away..... :D

Excellent. Thanks for the update! :clap:

Should help anyone on 1.3.7.

You replied while I was editing my post so you might not have seen my other question...

ps does your structure to add new queries extend to customer location......?

Could you give a practical example of what you want to do?

What I might do in the next version is add a setting where users can type in a custom sql query for the autoresponder to work with. That way, you can really tailor it to suit your own requirements without hacking any code.

I have someone who would like to be able to email people in a certain location (county) when they are doing a show in their area. I know it's stretching the functionality of your excellent mod but it would seem to be not a million miles from what you have already written. Your comment about the query structure being in place made me think it was worth asking....

This really is a fantastic addition to zencart by the way - up there with image handler IMHO...

Thanks for the compliment. I always knew there would be demand for a mod like this; I just hope it meets everyones expectations.

I'm still not totally sure what you want to do exactly. If you wanted to add a condition so that emails are only sent to customers living in a particular county (after their order or account registration), this would be fairly simple. You would just add onto the relevant sql statement, something like:

AND address_book.entry_zone_id=276 AND customers.customers_default_address_id = address_book.address_book_id;

But I suspect your requirement is different to that? In which case, it could be beyond the scope of this mod.

That's exactly what is needed. Nothing more - a simple query to extract people in a certain county and mail them. If it could be inserted as an input field or maybe as a dropdown into the input page so that the county could be added rather than having to deal with the sql code then the user would simply be able to enter the county name.

I'm just a bit reluctant to add this in as a standard feature. I'm not sure there would be much demand for it, and I feel the admin settings are already a little bloated. Also, if I were to add a county condition, people might then ask for a country and continent condition etc as well. I'll have to think about it some more and see if people would want it but at the moment, I'm thinking a custom sql field would be better where users can adapt queries themselves (with guidance from here).

All my other emails work correctly with these constants, so it isn't that the constants are undefined - it is that the defined values aren't flowing into the AutoResponder email correctly.

A couple more things that might help:

• I created a new email using the order_Status email and renamed it as the Autoresponder email. When that email was sent out to me the same thing occurred where constants were not defined
• It is correctly identifying Order Status and how many emails to send
• Zen Cart version 1.3.7.1
• latest version of MOD
• I have other mods installed but they aren't messing up other emails so not sure why they would affect this one - it almost seems to me that the AutoResponder.php file is just not loading correctly

-lindasdd

Steven300:

I can't replicate this error. What email program are you using? What Zen Cart version? What version of the mod? Do you have any other mods installed which you think might cause a problem?

For some reason you have undefined constants which email/email_template_autoresponder.html is trying to use.

Most of these constants should be defined in either:
includes/languages/english/email_extras.php
or
includes/languages/english/your_template/email_extras.php

Can you check to see the constants are there?

What's strange is that $EMAIL_MESSAGE_HTML should be defined by the mod itself. This makes me think there's a wider problem, one which at the moment I'm not sure what the cause would be.

Perhaps you could try using another admin email address to test with? In autoresponder.php, find this code:

$admin_email=STORE_OWNER_EMAIL_ADDRESS;

Change to something like..
$admin_email="[email protected]";

Related Tutorial/FAQ:
https://www.zen-cart.com/tutorials/index.php?article=95

Thanks for this information. Could you try overwriting the following file with one from Zen Cart 1.3.8a:

includes/functions/functions_email.php

That worked.

I still can't get the template to look like the Order Status update email(emails are pulling in variable names instead of values again) - would that be something you would consider creating?

I think an email such as that which provides full info on an order works much better(at least for Preset #1) for both the customer and the admin. Otherwise it becomes a little disjointed.

Either way thank you for your help and this great Mod.

-lindasdd

Just to say I tested this over the past couple of days with a nightly cron job and worked perfectly :clap:

The client thinks I'm marvellous......:hug:

So thanks again!!

I understand your point about the county - it's just SOOOO annoying when people want more isn't it! Any help though would be great...

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? :blink:

Thank's

Sorry guys I've been in hosp. the last ten days. I'm back home now and able to continue work on this contribution and provide any support.

patski:

I understand your point about the county - it's just SOOOO annoying when people want more isn't it! Any help though would be great...

I'm starting to think this could be a useful feature. I'll see if I can implement it over the next few days.

Franck69:

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

Not sure, could be a bad server setting. Have you tried without the 'require' statement? I don't think it's necessary.

Hi Steven

Sorry to hear you've been unwell. Hope you have a speedy recovery.

I have a suggestion for a small tweak - could 'Dear' be one of the salutation options.

Also what's the difference between options 1 John, 7 John and 2 John Smith, 8 John Smith etc - they seem to be duplicated.

Thanks

patski:

I have a suggestion for a small tweak - could 'Dear' be one of the salutation options.

Sure, I'll get working on this soon. Probably not today though cos it's my birthday :smile:

patski:

Also what's the difference between options 1 John, 7 John and 2 John Smith, 8 John Smith etc - they seem to be duplicated.

The latter ones have a comma at the end.

HAPPY BIRTHDAY!!

And I'm obviously blind :blush:

It's an easy mistake :D

Please pardon me if this is a silly question, but I'm looking for a way to email customers a few weeks after their purchase to ask them if they would consider writing a review of the product they purchased.

Does this mod present the best platform for doing so? Does anyone have any experience with creating direct links to the review functionality?

Hi Mark. With this mod, you can send an email to your customers a few weeks after their purchase asking them to write a review. However, the functionality doesn't exist yet to include in the email the specific products that were ordered. I'm planning on adding such a function in the future but I can't give any date for when that will be. If this is an important feature to you, there is a company called Magnetic One who have a similar mod which has this feature, but it will cost you to get it. I'm not aware of any other mods. Hope this answers your question.

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/showpost.php?p=599892&postcount=32