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

[Steven300]

Hi guys. It's been a while since I last did any work with this mod. In fact, I feel as if I've improved a lot with PHP since the last version, as I've been working on other projects. As such, I'm going to be rewriting some of the code and adding new features over the coming days. I have already made some improvements today:

• Account emails can be restricted by location
• Order status can be automatically updated

Next, I plan to:

• Restrict emails by product
• Add full source code comments
• .. and possibly more

If you have a feature not already requested, now is a good time.

Expect a beta version (of v2.3) by next weekend

[Steven300]

My Store name is misspelled on my email header?

I checked it in ADMIN>CONFIGURATION>MY STORE>STORE NAME

and it's spelled correctly

It's auto pulling correctly on my sites footer- Copyright © 2009 Fintess Depot Super Store.

Is there some where else that I need to look to change the name for the e mail?

It Currently reads "Message from Fintess Depot Super Store"

Thanks-

Hi, I'm not sure how autoresponder+ would cause this as it doesn't actually do anything with the store name. It just displays whatever is configured in the setting you mentioned.

Can you attach a screenshot of this? Is the problem with html emails, text or both?

Also, the text you provided for your footer (which you said is correct) seems misspelled to me.

[Steven300]

I have a feature request, which I would find very helpful, and I suspect others might as well....

Some excellent suggestions! I had planned to add a feature for product restriction for a while, but never thought of changing the order status after the emails. This allows users to run the mod as often as they want (providing it's an order related email).

[aaelghat]

Hi - thanks for continually improving AutoResponder+!!

I love the addition of modifying the order status, since that will allow me to send out very timely instructions instead of just once a day.

I also like the fact you'll provide more source code comments for autoresponder.php. I'll need to hardcode some things that I mentioned in post 128, and that will make it easier.

In terms of feature requests, there was one thing I was going to hard-code manually (that others may benefit from). You can decide if you want to this in the base code....

Basically, I wanted to be able to put the order attributes in the text of the email. Maybe the user can specify an attribute keyword with the attribute number in brackets (e.g. [ATTRIB-13]) and that would retrieve attribute ID #13 from the zen_orders_products_attributes table. On the other hand, I could see where that might be complex to code.

I need to manipulate some of the attributes anyway (apply LCASE for example), so I need to bring them into variables so it's not a big deal for me to just bring all the attributes into variables if you decide it's not worth doing in the mod.

Thanks again for all your work on this. I'll hold off on making any changes to the code on my end until the beta appears.

[Steven300]

Hi, yes I would definitely hold off from making any changes at the moment. I think (hope) you'll find the source code a lot easier to work with once I'm done. A lot of comments are being added, and I have managed to remove some redundant code. I have also fixed an unreported bug whereby auto-generated coupons could be created even though the final email doesn't send because of newsletter subscription checks. I'm not sure any attribute related code will make it into the next version, but the mod will be easier to add such things.

[Steven300]

Just a quick update: Autoresponder+ can now restrict emails by product.

Tons of testing to do now

[Steven300]

Autoresponder+ v2.3 Beta is now available:

http://wikisend.com/download/447690/

Any feedback is appreciated.

[aaelghat]

I downloaded and tested the beta (only in test mode) and it seems to work great!! It only selects the specified product IDs and the status update works great!

I especially like the fact that it updates the status on the admin orders detail screen with a date/time stamp, and it doesn't notify the customer. That's perfect! You may want to warn people that the status does get updated even in test mode, but that works for me since it allows me to test better, and it's easy enough to change the statuses back.

I have some tailoring to do for my specific purposes, but these are great functionality improvements. Nice job!!

[Steven300]

Thanks for the positive feedback.

That's a good point about how it changes the order status while in test mode. I will add a note in the testing section to explain this.

[aaelghat]

Hi, I'm wondering if you can provide some guidance. I'm trying to modify the code so that I can retrieve various order attributes, and reference them in the HTML and text files. I've been using the [coupon] as a reference, but I'm a low-level hack at PHP.

I'd like to get one attribute working, and then duplicate it. I'm starting with an attribute called RecipientName, and I wrote some SQL to retrieve it. I know the SQL code works, and tried to follow your example for the PHP syntax. I put the code right after the retrieval of the customer name.

        /* First, let's get the customer's name */
    
        //If in order mode
        if ($this_auto_state == 'order') {
        
        $sql3="select customers_name from " . AUTO_TABLE_ORDERS . " where orders_id='".$result->fields['orders_id']."'";
        $result3=$db->Execute($sql3);
        
        $name=$result3->fields['customers_name'];

              //AAE - Retrieve RecipientName
              $SQL-AAE-Recipient = "select products_options_values from " . AUTO_TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id='".$result->fields['orders_id']."'" AND products_options_id = 45";
              $ResultRecipientName=$db->Execute($SQL-AAE-Recipient);        
        $RecipientName=$ResultRecipientName->fields['RecipientName'];

However, I'm unclear what I'd need to do to reference it by typing [RecipientName]. I duplicated what you had for the coupon by typing

//This can be changed here if desired.
$coupon_key = "[coupon]";

// AAE - Set Recipient Name keyword.
$RecipientNameKey = "[RecipientName]";

Can you help me connect the dots? What am I missing? What else do I need to do? Do you see any syntax errors? Thanks.