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

[fusionsp]

So, any input? delete it? start over yet again? Im lost, i figured installing this may be a little difficult so i wanted it to be one of the last mods i did....and yea, still not working.

Oh well, guess its manual emails for me.

[CoolCarPartsOnline]

What exactly are you testing? They are different options. I have tested it for product review and it worked fine. It sends the customer an email and the admin at the same time. You must set the days after which you want the mod to work correctly and then run the autoresponder. I had problems with it in the early stages because I had set the day incorrectly but after that it is working.

Now time to start on customizing the message.

[fusionsp]

What exactly are you testing? They are different options. I have tested it for product review and it worked fine. It sends the customer an email and the admin at the same time. You must set the days after which you want the mod to work correctly and then run the autoresponder. I had problems with it in the early stages because I had set the day incorrectly but after that it is working.

Now time to start on customizing the message.

weird, I never got a notification email that someone replied to this thread? Oh well...

I was doing the sample test. I checked the date my last order was set to delivered status and set the internal date accordingly. I tried every date around that date before and after and still nothing came to the admin email. I didnt want to set it as live until I knew that it was working and not sending like tons of spam.

Now from the instructions, you are supposed to set it to the date your last order is "delivered" status correct??

If someone could suggest anything it would be much appreciated.

[Steven300]

Sorry for the late reply, I have been in hospital for the last 5 weeks!

Now from the instructions, you are supposed to set it to the date your last order is "delivered" status correct??

That's right.

As Glamorousshoe suggests, I think this could be an issue with setting the Days After correctly. To eliminate this possibility, one thing you could try is to create a test order, change the order's status to delivered(3), and then set the Days After to 0.

With regard to some of the other settings, make sure:

• Autoresponder+ is enabled.
• The correct preset is enabled.
• Query is set to Order.
• Order Status ID is set to 3.
• Subscribed is set to False.
• There are no location restrictions.
• There are no product restrictions.
• There is no time validation.
• A valid admin email address is entered (or left blank).

Check all other store emails are working.

Try turning on the logging feature to see what output Autoresponder+ provides (if any).

Hope that helps.

[WhiskyFive]

Hello,

Have done a first time install of the Auto Responder using the latest version (2.3) on zencart 1.38a with all patches applied.

On running, I get this error:

1146 Table 'database1.AUTO_TABLE_ORDERS_STATUS_HISTORY' doesn't exist
in:
[SELECT DISTINCT OSH.orders_id, O.customers_email_address, O.customers_name FROM AUTO_TABLE_ORDERS_STATUS_HISTORY OSH, AUTO_TABLE_ORDERS O WHERE OSH.date_added like '2010-03-04%' AND OSH.orders_status_id IN (3) AND OSH.orders_id=O.orders_id AND OSH.orders_status_id=O.orders_status]


I'm using a test account (in my name) in test mode, with the order updated to "dispatched" (order status 3) today and the AutoResponder set to 0 days.

I realise this error is similar to the one reported at the start of the thread, but the problem and fix are for version 1 and not 2.3.

Any help much appreciated as it looks a fab contribution if I can get it to work!

[Steven300]

Hi,

Did you upload the following file?

includes/extra_datafiles/autoresponder.php

[WhiskyFive]

Hi,

Did you upload the following file?

includes/extra_datafiles/autoresponder.php

I have now! Thanks....I missed it in the install and it works perfectly now.

Very grateful for the quick response and a really useful contribution.

[Steven300]

Glad it's working for you

[WhiskyFive]

Glad it's working for you

Actually, do seem to have found a bug.

On the function to process orders of one order status (e.g. Dispatched) and change them to another order status (e.g. Followed Up), I'm getting the following error when running:

1136 Column count doesn't match value count at row 1
in:
[insert into orders_status_history values ( '', '212649', '3', now(), 0, '' )]

212649 is the order number
3 is the status of the order it should be changed to (the original order status was 10)

If I don't try and automatically change the order status, then it works fine.

Any ideas on how to fix?

[Steven300]

My first thought is that your database table, orders_status_history, might have additional columns added to it (perhaps by another mod).

Can you check the table using phpMyAdmin. There should be 6 fields:

orders_status_history_id
orders_id
orders_status_id
date_added
customer_notified
comments