Mailbeez After Sales Modules

[mailbeez]

Cord - Please add or update the module in the free AddOns section. thanks.

Hi kim,

just updated the MailBeez Package in the free AddOns Section.

cord

[kawaii]

woohooo.... it solved the issue. Had to make the same changes on a couple of the other files but the module is finally up and running. thank you so much

[Jeff_Mash]

the module does find the highest order number in the configured timeframe and than checks if there is an order with a higher order number - assuming that newer orders have higher order numbers.

Are your order numbers chronological?

Yes, our numbers are chronological. Here is an example of what happened with a customer.

Customer A had two prior orders with us:

- Order #32807 on 05/17/11
- Order #35665 on 01/18/12

As you can see, their first order was well before the 180 threshold for the WinBack module to mail something out. However, they had a recent order that was only a couple of weeks old which was placed afterwards. So therefore, I wouldn't have expected them to get anything.

However, they just placed a third order with us using the coupon that we emailed out with the WinBack module. Both of those previous orders were in a Shipped status. It's the strangest thing! Not a horrible deal or anything, just more of a curiosity on my part.

[Jeff_Mash]

Actually, I got a PERFECT EXAMPLE for you to check out.

I am attaching two screenshots which will illustrate the problem, and perhaps it will help you see any issues that I can fix.

On the WinBack module, when I click the SHOW button to show me a list of recipients, the very first person on the list looks like this:

http://www.zen-cart.com/forum/attach...1&d=1328289551

As you can see, the order that this customer is looking at is #33690 on 8/6/11.

Now take a look at the list of orders this customer has placed:

http://www.zen-cart.com/forum/attach...1&d=1328289579

You can see that order #33690 was the FIRST order he placed, but he's placed many orders since that time, and his most recent one was on 12/14/11, which is much less than the 180 Day threshold we have configured in the WinBack module.

So the million dollar question is, "Why would the module not see that the customer has more recent orders?"

[mailbeez]

h jeff,

am sure that is one of the tricks you sell ;-)

please run this SQL

select max(orders_id) as orders_id_last from orders where customers_id='16753'"

(eventually your table "orders" has a prefix like "zc_orders" - please adjust in this case)

what does it say?

Do you have the latest version of MailBeez (2.5) and the Winback module? Please run the update check.

cord

[Jeff_Mash]

Hi Cord - Ok, I think we are getting somewhere. I ran the SQL query and it returned order #35284. See attached screenshot.

http://www.zen-cart.com/forum/attach...1&d=1328312714

As for updates, I just ran the Update Check, and it turns out that there is a newer version for the WinBack module (v2.1). I had been running the version 1.1 which was taken from the ZenCart download area.

I downloaded the new version, and I will play around with it. On initial inspection, when I ran the Show Recipients with this new version, that previous customer I used in my example no longer popped up. So perhaps it's fixed! I will go through the list, randomly sampling names from the Show Recipient query, and if anything looks out of the ordinary, I will let you know.

Thanks again for the help.

[ak6000]

Hi,

I have installed the latest version (v. 2.5) and everything working perfectly.

I like the simple review module the way it is but I like to rearrange the way the product pictures and their names are displayed.

I checked the template folder as well as body_html.tpl but I can't find where I can rearrange the list.

Appreciate your help.

[mailbeez]

hi the simple review module comes with a subtemplate defining the product list located in the modules "email" folder - there you can adopt the output.

However the premium version comes with a much more powerful approach so you can e.g. build product grids (this is not possible with the simple module) and also does a automatic login for the customer (valid only for the write review page)

[ak6000]

Thanks for your prompt reply

[ak6000]

Hi Cord,

I have successfully installed and configured three modules. Simple Winback, Simple Review and Simple No Purchase.

I was also able to run all three modules in Simulation mode, however, once I changed to Production and ran these three modules only a portion of No purchase and Review module were ran successfully.

I started with Winback that Initiated and Completed without any problem.

Then, I ran Review. It started and I saw about 4 of the 18 emails were sent and after the Review I started the No purchase. It also started and send about 5 emails out of 8.

I assumed the module needs time to complete the emails, so I left them alone all night and when I checked back in the morning still shows both Review and No purchase have Initiated but none is Complete?

What's the problem? I appreciate your help.