Mailbeez After Sales Modules

Thanks Cord. I made the change and it works perfectly.

ScriptJunkie:

The issue you post is a relatively easy fix (which is posted elsewhere in this thread), but you shouldn't bother with it because you are using a version of this mod that was built for ZC150. It will likely have many other problems once you solve this issue because you're using the wrong version of the mod with the wrong version of ZC.

However, your much bigger problem is that you're using a version of ZC that is not only outdated, but terribly unsecure and totally vulnerable to hacks. Reputable store owners no longer use ZC138 because the security issues with it also put their customers at risk.

Recommend you update to ZC150 immediately.

Best way to do this is to

1. back up your site files and database
2. make a list of all the mods you use
3. make a list of any files you have customized (use Beyond Compare or WinMerge to do file comparisons between your files and the 138a fileset to identify these files)
4. make a list of the settings for your shipping, payment, and order totals modules (from the admin)
5. uninstall all of your addons - including their database changes
6. make another backup of the store and database after addons are removed so if you make a mistake during upgrade, you have a cleaner version to start over with
7. download ZC150
8. Upgrade it per the instructions in the docs folder that's included in the zc150 zip file
9. Search the forum to find out which of your mods have been updated for zc150
10. Reinstall those mods that have been updated, say goodbye to the rest until they are updated

Good luck and happy Zenning :smile:

Thanks for the advice. This is a client's site which she has no intention of upgrading.

Yikes! Naturally, you only have so much control over your client, but I hope that you'll encourage the client to upgrade and provide the reasons why upgrade is necessary. I sure as heck wouldn't buy anything from your client's site as long as they insist upon using software that is not secure.

I am sure this question has been answered but need some clarification on how to fix it. I have a version 2.5 Mailbeez, When I send the review request emails the image of the product and the image of the 'Write Review' don't show up in the html emails. For some reason when I review the email within the module I could see the image but only after an email is sent the 2 images don't show up, rest of the images like the header image and Facebook etc show fine so I know that email is being sent in a html format.

Reading the forums I guess it has to the with directory of the images but which file do I have to change and what do I have to change it to.

Thank you

hi coins,

are you having any modifications in your zencart, e.g. an addon for more images?
please try to check the image path and compare how it should be like. The review advanced module is much more flexible to adopt image path to customizations.

cheers
cord

Yes, I believe my website developer made lot of modifications and addons for images, I am thinking about buying the advance module but like to try this for a while, is there a way I could change the code to put in the correct directory info?

the Write Review image is in the following dir: /includes/templates/ayd/buttons/english/button_write_review.gif
and the product images are in the following dire: /images/1888_Morgan.jpg

Any help?

mailbeez:

hi coins,

are you having any modifications in your zencart, e.g. an addon for more images?
please try to check the image path and compare how it should be like. The review advanced module is much more flexible to adopt image path to customizations.

cheers
cord

hi coins,

try to modify the function mh_product_image() located in
/mailhive/common/functions/compatibility.php

however you need to keep track of this change as it will be lost with an update of MailBeez

regards
cord

If I buy the complete package does this problem get solved? Thank you for the input.

mailbeez:

hi coins,

try to modify the function mh_product_image() located in
/mailhive/common/functions/compatibility.php

however you need to keep track of this change as it will be lost with an update of MailBeez

regards
cord

hi coins,

the premium module allows to adopt the image path in the email templates w/o changing any program code. With using the template manager the email templates are managed in the DB. That way everything stays clean and updateable (think we all have seen enough extremely customized shop-systems, which are very hard to update once a new release comes out... so Mailbeez is not going that route)

I give you full support by email how to adopt the template to show the product images in your store.

regards
cord

How can I tell if Mailbeez is working properly? I set up a cron job, and I looked at the activity log and it says this:

91 2012-05-02 13:22:57 MAILBEEZ_MODULE_INIT winback class constructed PROD
91 2012-05-02 13:22:57 MAILBEEZ_MODULE_INIT review_facebook class constructed PROD
91 2012-05-02 13:22:57 MAILBEEZ_MODULE_INIT review class constructed PROD
91 2012-05-02 13:22:57 MAILBEEZ_MODULE_INIT nopurchase class constructed PROD

I don't know what that means, though... I don't know what "class constructed" means... I don't know if any emails were sent... I don't know how to tell if my cron job is working properly or not... can someone help?

hi webkat,

make sure you have MailBeez V2.5 installed.

the lines you pasted are more technical information (I assume you checked the addtional information in mailbeez > configuration > event log?)

the default log entries will tell you when the sending process is started and when it ended successfully (if you see only MAILHIVE_RUN_INIT entries, something goes wrong - you should get a MAILHIVE_RUN_COMPLETE entry for every run).

The easier way to see if MailBeez works is to send yourself copies of the generated emails (mailbeez > configuration > MailHive - Basic configuration) and to check the Beez-O-Graph for activities.

hope that helps?

regards
cord

mailbeez:

make sure you have MailBeez V2.5 installed.

the lines you pasted are more technical information (I assume you checked the addtional information in mailbeez > configuration > event log?)

the default log entries will tell you when the sending process is started and when it ended successfully (if you see only MAILHIVE_RUN_INIT entries, something goes wrong - you should get a MAILHIVE_RUN_COMPLETE entry for every run).

The easier way to see if MailBeez works is to send yourself copies of the generated emails (mailbeez > configuration > MailHive - Basic configuration) and to check the Beez-O-Graph for activities.

Yes, 2.5

Not sure what you mean by mailbeez > configuration > event log... that looks like a thing I change settings on... two checkboxes... I don't see where to actually view the event log itself...?

I am already set to receive copies of all emails; I have received none. The graph is a flatline at zero.

My cron job is:

30 15 * * * wget home5/jugglerd/public_html/mailhive.php?123456789123456789123456789=run (obviously a fake number there)

Should that be something else?

Not sure what you mean by mailbeez > configuration > event log... that looks like a thing I change settings on... two checkboxes... I don't see where to actually view the event log itself...?just uncheck them, you can view the event log under the tab "reports"

the cron-url MUST be called using http:// - so a full URL rather the php-path you are using.

so once you changed that it should work.

also you can call the cron-url directly in a browser to test things out (if there is nothing to send, the cron won't change that)

cheers
cord

I changed the cron to a url and ran it in the browser and got this:

MailBeez - Mode: production
1146 - Table 'myuser_ozenc.TABLE_CHRISTMAS' doesn't exist

select c.customers_firstname, c.customers_lastname, c.customers_id, c.customers_email_address, x.christs_dob, date_format(x.christs_dob, '%d.%m.%y.') as christs_dob from customers c, TABLE_CHRISTMAS x where date_format(x.christs_dob,'%y%m%d') < ( date_format(now(),'%m%d')+ 25) and date_format(x.christs_dob,'%y%m%d') > ( date_format(now(),'%m%d')- 35)

[TEP STOP]

...what did I miss?

no idea, this error does not come from any official MailBeez module - the official MailBeez module are most easy and hasslefree to install.

MailBeez Version 2.6 released
Finally after weeks of work, hundred of changes and intense testing on selected live site MailBeez Version 2.6 is ready for download!

MailBeez Version 2.6 is a major release with many improvements like

• MailBeez Analytics for tracking of open / click / purchases
• Enhanced Beez-O-Graph with pop-ups
• Google Analytics Dashboard Integration: see how GA tracks MailBeez Campaigns
• Google Analytics URL rewrites in txt format (configurable)
• Optional Bounce Handling (hard/soft bounces)
  Find the full list on http://www.mailbeez.com/documentation/changelog/

To upgrade just download the Quickstart Package - you will find and Upgrade Pack for MailBeez V2.5, which only contains core files. So the update is done by uploading these files and folder (replace / merge).

The fresh installation on Zencart 1.3.x to Zencart 1.5 is very easy by just uploading the new files & folders.

Some visual highlights are the reworked / new dashboard widgets which give you information about the effect of MailBeez Campaigns:
The Beez-O-Graph shows now open, clicks, orders and bounces - with a drill-down pop-up:

The new Google Analytics Pie gives you the most important figures from Google Analytics directly in your dashboard:

The Customer-Loyalty-O-Graph gives an indication, how many of your orders are coming from returning customers:

As before you can use MailBeez Version 2.6 for free. If you like what you see you can enhance (= more revenue) the System step-by-step for your needs.

enjoy MailBeez
cord

Hi Cord.

Any chance of helping me out on this: I'm using MailBeez 2.5 and have slightly adapted the Simple Review module and made it a Satisfaction Survey module. However, the problem I'm having is that it sends emails without date restrictions - today it sent out emails to customers who purchased several years ago... My settings are as follows:
Set days passed: 10
Set days to skip after: 20

This is the query used for audience:

function getAudience() {
			global $languages_id, $language;
			
			$status = MAILBEEZ_SATISFACTION_ORDER_STATUS_ID;
			
      $date_skip = $this->dbdate(MAILBEEZ_SATISFACTION_PASSED_DAYS_SKIP);
      $date_passed = $this->dbdate(MAILBEEZ_SATISFACTION_PASSED_DAYS);
														
      $query_raw = "select c.customers_firstname, c.customers_lastname, o.orders_id, o.customers_id, c.customers_email_address, o.date_purchased, s.date_added as status_date
											      from " . TABLE_ORDERS . " o, " . TABLE_CUSTOMERS . " c,  " . TABLE_ORDERS_STATUS_HISTORY . " s
											      where o.customers_id = c.customers_id
															and o.orders_id = s.orders_id
															and o.orders_status = s.orders_status_id 
											        and s.orders_status_id = '" . (int)$status . "' 
											        and s.date_added <= '" . $date_passed . "' 
											        and s.date_added > '" . $date_skip . "' 
											      order by o.orders_id ASC";
			
			//echo $query_raw ;
			
			$query = mh_db_query($query_raw);
			$customer_array = array();
			$customer_products_array = array();
			$customer_orders_array = array();

I haven't changed any MailBeez core files. Of course, database entries are valid (checked the database: MAILBEEZ_SATISFACTION_PASSED_DAYS_SKIP=20, MAILBEEZ_SATISFACTION_PASSED_DAYS=10)

If you want, I can send you the entire module for you to check.

Thanks.

hi balihr,

am happy to give you professional development support, just send me an email

cheers
cord

Hm... OK, I wasn't looking for a quote since I was planning on releasing this in the Add Ons section... Anyway, I just sent you a PM.

LOL, I just figured it out. The problem was caused by something I did in the order management and has absolutely nothing to do with the MailBeez module or my Satisfaction Survey module...

I'll prepare the files during the day and submit to the plugins section. If anyone wants a copy of the Satisfaction Survey module before it gets approved, just PM me.