Mailbeez After Sales Modules

[WebKat]

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?

[mailbeez]

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

[mailbeez]

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

[balihr]

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.

[mailbeez]

hi balihr,

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

cheers
cord

[balihr]

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.

[balihr]

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.

[mailbeez]

Hi balihr,

sorry for my late reply, was busy with the Version 2.6 release.
Good you figured out what the issue was.

cheers
cord

[Limitless]

I just upgraded from MailBeez 2.5 to 2.6.2. Great update, but have an issue with the 'Review -o- Meter'. I now get the following on my dashboard.

Parse error: syntax error, unexpected $end in /XXXXXXXXXXXXXX/mailhive/dashboardbeez/dashboard_review_o_meter.php on line 281


I have looked through the page to find if/where some of the code is not closed, but I can't seem to find the issue.

[ScriptJunkie]

Hi Cord,

Can you tell me where I can download v2.2? I need to do a file comparison between a fresh fileset and my own fileset to identify the customizations I've made before I install v2.6 in a new store.

Thanks!