Mail Manager for OSC v2.3

[npn2531]

Mail Manager for OSCommerce v2.3 is now available in the add-ons.

Mail Manager is designed to:

 

1) Send all emails in html with a text alternative. With Mail Manager all emails can be created in html complete with images, links, logos, etc. This includes order confirmation, create account, password forgotten, status update, newsletters and tell-a-friend emails

2) Allow editing all of emails from the Admin, and for creating html templates that can be applied to all emails for a consistent and professional look.

3) Adds a special post sales follow-up email to send to customers who have recently made a purchase complete with images, descriptions, links of purchased products, links to leave product reviews, and if the Xsell module  is installed, images, descriptions and links to recommended products. 

4) Mail Manager adds product images to the customer initiated tell_a_friend email.

5) A search feature is added to the admin email that makes it simple to locate a customer and send them note, etc on a templated html email.

6) Control the rate, or speed, that emails are sent. This allows shops on shared web-hosting account to send large mailings without exceeding band-width limitations.

7) Target for newsletters and mailings any group of customers or mailing list entries that can be identified by php queries. For example you could create a mailing to customers who have purchased a certain product and who live in a single postal code. 

 

Download includes fully functional and editable example newsletters and templates.

[tronixcomputers]

Error

SQL query:

--

-- Add a new field to existing table 'customers'

--

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter` -- --------------------------------------------------------

--

-- Table structure for table `mm_bulkmail`

--

CREATE TABLE IF NOT EXISTS `mm_bulkmail` (

`bulkmail_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`title` varchar( 255 ) NOT NULL ,

`htmlcontent` text NOT NULL ,

`txtcontent` text NOT NULL ,

`date_added` datetime NOT NULL ,

`date_sent` datetime DEFAULT NULL ,

PRIMARY KEY ( `bulkmail_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

 

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `mm_bulkmail` (

  `bulkmail_id` int(11) NOT NULL AUTO' at line 12

 

something needs fixing cant execute sql

[breakbred101]

Error

SQL query:

--

-- Add a new field to existing table 'customers'

--

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter` -- --------------------------------------------------------

--

-- Table structure for table `mm_bulkmail`

--

CREATE TABLE IF NOT EXISTS `mm_bulkmail` (

`bulkmail_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`title` varchar( 255 ) NOT NULL ,

`htmlcontent` text NOT NULL ,

`txtcontent` text NOT NULL ,

`date_added` datetime NOT NULL ,

`date_sent` datetime DEFAULT NULL ,

PRIMARY KEY ( `bulkmail_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

 

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `mm_bulkmail` (

  `bulkmail_id` int(11) NOT NULL AUTO' at line 12

 

something needs fixing cant execute sql

 

 

I opted not to waist my time with troubleshooting this and deleted it from the sql update. Then inserted it manually, should go smoothly after that.

 

Great contribution too, loveing the templates. Only problem im having is it wont send these templates out in html format. I've tried enabling MIME HTML sending of emails to no avail. If anyone has the solution to this that would be nice. Judging by the code it doesnt take into account any configuration settings which is A Ok with me.

[breakbred101]

Error

SQL query:

--

-- Add a new field to existing table 'customers'

--

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter` -- --------------------------------------------------------

--

-- Table structure for table `mm_bulkmail`

--

CREATE TABLE IF NOT EXISTS `mm_bulkmail` (

`bulkmail_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`title` varchar( 255 ) NOT NULL ,

`htmlcontent` text NOT NULL ,

`txtcontent` text NOT NULL ,

`date_added` datetime NOT NULL ,

`date_sent` datetime DEFAULT NULL ,

PRIMARY KEY ( `bulkmail_id` )

) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

 

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `mm_bulkmail` (

  `bulkmail_id` int(11) NOT NULL AUTO' at line 12

 

something needs fixing cant execute sql

 

 

More specifically, the error is being thrown because of the table editing of the customers table, so remove the code below from the sql query and then manually create the field with PHPMyadmin

 

<code>

--

-- Add a new field to existing table 'customers'

--

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter` -- --------------------------------------------------------

--

</code>

[mirageco]

just got a quick question for you?

 

i have installed this and now im at the stage of testing...

 

i don't know how to explain it but i will give it ago

 

i getting the contents of the email twice in the one email?

 

dose that make scene ?

 

i have saved my email as a pdf and i will upload it for you too see  http://autestserver.info/help.pdf

 

any help please

Edited November 1, 2014 by mirageco

[newburns]

@@breakbred101

 

SQL Statement from the downloads is missing the delimiter on line 4

 

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter`

should be

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter`;

Edited November 17, 2014 by newburns

[newburns]

Step three of the instructions needs alteration:

3. Open catalog/includes/languages/english/checkout_process.php, add:
//Mail Manager define('EMAIL_TEXT_CONFIRM', 'has recommended');
define('TEXT_FROM', 'from');

Should be

3. Open catalog/includes/languages/english/checkout_process.php, add:
//Mail Manager definitions 
  define('EMAIL_TEXT_CONFIRM', 'has recommended');
  define('TEXT_FROM', 'from');

[npn2531]

Thank you for spotting this. The mail manager contribution status is open, and it would be appreciated if you posted these changes. 

[newburns]

Wow...

I really like this addon.

Any way to have a different editor to choose from. That way you can toggle source, or WYSIWYG?

 

There is a missing language definition:

/* Mail Manager -- http://www.oscommerce.com/forums/topic/397966-mail-manager-for-osc-v23/ */
  define('BOX_HEADING_MAIL_MANAGER', 'Mail Manager');
  define('BOX_MM_BULKMAIL', 'BulkMail Manager');
  define('BOX_MM_TEMPLATES', 'Template Manager');
  define('BOX_MM_EMAIL', 'Send Email');
  define('BOX_MM_RESPONSEMAIL', 'Response Mail');

should be

/* Mail Manager -- http://www.oscommerce.com/forums/topic/397966-mail-manager-for-osc-v23/ */
  define('BOX_HEADING_MAIL_MANAGER', 'Mail Manager');
  define('BOX_MM_BULKMAIL', 'BulkMail Manager');
  define('BOX_MM_TEMPLATES', 'Template Manager');
  define('BOX_MM_EMAIL', 'Send Email');
  define('BOX_MM_RESPONSEMAIL', 'Response Mail');
  define('BOX_TOOLS_MAIL_MANAGER', 'Mail Manager');

This is step number 4. Or, change the array "title" definition in step 9 from

'title' => BOX_TOOLS_MAIL_MANAGER,

to

'title' => BOX_HEADING_MAIL_MANAGER,

 

 

Lastly, when you go into the "Response Mail" option, and hit back, it returns you to the Bulk Newsletter option instead of the root Mail Manager. Not sure what that could be, but you have to select back twice from the "Response Menu" in order to get back to the root "Mail Manager"

[newburns]

Change to 

../catalog/admin/mm_responsemail.php

 

Find around line 363:

</td></tr></table><table><tr><td class="main"><a href="' . tep_href_link(FILENAME_MM_RESPONSEMAIL, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->mail_id . '&action=test') . '">' . tep_image_button('button_test.gif', 'test') . '</a>

change to

</td></tr></table><table><tr><td class="main"><a href="' . tep_href_link(FILENAME_MM_RESPONSEMAIL, 'page=' . $HTTP_GET_VARS['page'] . '&nID=' . $nInfo->mail_id . '&action=test') . '">' . tep_image_button('button_send.gif', 'test') . '</a>

The newer 2.3.3.4BS and 2.3.4 doesn't have the button_test.gif. 

[newburns]

Within the status update email template,

http://www.css-oscommerce.com/images/mail_manager/divider-invoice.jpg

is not a valid image.

[newburns]

When using the "tell a friend", it does not properly parse the product image url.

it only shows "http://store.root/images/" but there is no remaining URL for the images.

[newburns]

Missing the ../catalog/includes/languages/english/tell_a_friend.php language definitions:

// Mail Manager
  define('TEXT_RECOMMEND', 'has recommended');
  define('TEXT_FROM', 'from the');
// EOF Mail Manager

And the ../catalog/includes/languages/english/checkout_process.php has the wrong definition in step 3

// Mail Manager 
  define('EMAIL_TEXT_CONFIRM', 'New Order from ');
//  define('TEXT_FROM', 'from');
// EOF Mail Manager

[AdiJan]

Can someone please tell me how to make the changes to the database files? I found my database (myphp), but don't know where to put the information. Or can I use cpanel for this?

Thank you very much!

[cujimmy]

@@AdiJan  Log into cPanel and under databases, go to phpMyAdmin.  Once you're in there and you can see your database tables listed on the left, click on the SQL tab and paste the contents of the SQL file in there and click Go.

 

If you have a problem with phpMyAdmin complaining about a 1064 syntax error or something like that, try sticking a semi-colon at the end of the first query so that it reads:

ALTER TABLE `customers` ADD `mmstatus` VARCHAR( 2 ) NOT NULL DEFAULT '0' AFTER `customers_newsletter`;

Try copying and pasting just that one line in on its own and clicking Go.

 

If that works, you can then copy in the rest of the SQL file (without that line) and click Go.

[AdiJan]

Thank you very much!

[AdiJan]

I really had to past the first line with the semicolomn to start with and then the other lines. You helped me a lot, it works!

Thanks for this great add-on and thanks for helping me to get started!

[newburns]

The Forgotten Password template does not work.

It sends the proper email template, but the "pwandmessage" is not properly parsed.

Can someone please confirm?

[AllThingsTrendy]

This sounds like a fantastic add-on that has been something I have wanted to customize for a very long time.  I just upgraded my site and I need to replace my old Newsletter program.  I am considering utilizing this Mail Manager.  However, can someone please tell me if the newsletter feature of this add-on includes code that allows the recipients to unsubscribe so that we stay compliant with anti-spam requirements?

[newburns]

Mail Manager seems to be just an alternate Administrative tool.

Unsubscribing appears to use the standard OSC workflow.

No changes there. Mail Manager does not have it's own subscription listing.

[newburns]

Seems the mail manager is using outdated variables. I'm assuming this is a 2.3.4 thing, so if you experience issues with the variables not parsing in the Forgotten Password email, you mush change:

 

./catalog/password_forgotten.php

/* **Altered for Mail Manager**
        tep_mail($check_customer['customers_firstname'] . ' ' . $check_customer['customers_lastname'], $email_address, EMAIL_PASSWORD_RESET_SUBJECT, sprintf(EMAIL_PASSWORD_RESET_BODY, $reset_key_url), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
*/
	if (file_exists(DIR_WS_MODULES.'mail_manager/password_forgotten.php')){
	  include(DIR_WS_MODULES.'mail_manager/password_forgotten.php'); 
	}else{
	  tep_mail($check_customer['customers_firstname'] . ' ' . $check_customer['customers_lastname'], $email_address, EMAIL_PASSWORD_RESET_SUBJECT, sprintf(EMAIL_PASSWORD_RESET_BODY, $reset_key_url), STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
	}
/* **End of alterations for Mail Manager** */

EMAIL_PASSWORD_REMINDER_SUBJECT has been changed to EMAIL_PASSWORD_RESET_SUBJECT

EMAIL_PASSWORD_REMINDER_BODY has been changed to EMAIL_PASSWORD_RESET_BODY

$new_password has been changed to $reset_key_url

 

These same variables MUST be changed in ./catalog/includes/modules/mail_manager/password_forgotten.php

 

Once I finish testing everything with Mail manager, I'll have it installed in my GitHUB master

https://github.com/newburns/osCommerce-234-bootstrap-wADDONS

[npn2531]

In the example templates that are included in the mail manager, you will find that an unsubscribe link is included that when the recipient of that email clicks on it, it will send an email to you with the word 'unsubscribe' in subject line. You will then have to manually remove that subscriber from your mailing list. 

 

The code for this is basic html, just be sure in the email you send out you have something like this:

<p style="font-family: Arial, Helvetica, sans-serif; font-size: 11px; line-height: 16px; color: #999999; margin: 10px;"> To be removed from this mailing list click <a href="mailto:unsubscribe@[member=yourwebsite].com?subject=Unsubscribe&body=Please%20remove%20my%20email%20from%20your%20list" ><u>here</u></a></p>

In this example, you would need to make sure that 'unsubscribe@@yourwebsite.com' is a valid email account you receive. It could be anything such as

'[email protected]' as long as it is a valid email you have set up.

[npn2531]

Ray, 

 

Good catch on the variables in password_forgotten.php.   You can add this correction to the mail manager contribution, or if you find anymore corrections post them back here and I will add them to the contribution. 

 

http://addons.oscommerce.com/info/9133

[newburns]

Still having problems with the image for tell_a_friend.php

 

I don't think this is the right way to pull the image URL

$product_image = tep_image($image_urlfix.DIR_WS_IMAGES . $product_info['products_image_med'], $product_info['products_name'], '', '', '');

Still looking for a different way to get the image URL

[vmf08034]

Can anybody tell me where are the templates stored?