Jump to content
npn2531

Mail Manager

Recommended Posts

Mail Manager is a comprehensive mail program for OSCommerce. Designed for 2.2RC2a and OSC 2 CSS.


Purpose:

1. Send all emails both in html and in text.

2. Allow editing and templating of all emails from the admin.

3. Add a post sales order followup email to OSCommerce.

4. Modulate the rate that emails are sent.

Mail Manager:

1. Mail manager allows the shop owner to create and edit all emails from the admin with both an html and a text alternative, to allow professional and readable emails to be produced.

2. To create a consistent look, templates can be produced in the admin that can be applied to all emails.

3. A bulkmail module is included that allows the rate that OSCommerce sends email and newsletters to be modulated. The rate is in seconds per email. This allows shops on shared web-hosting accounts to send large mailings without exceeding band-width limitations.

4. The bulkmail module also contains a special feature that allows the sending of marketing emails to customers that have recently made a purchase. This email contains an order's product listing, to include images and links to make review, and also contains cross sold items. (if the xsell module is installed http://addons.oscommerce.com/info/1415).

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

6. 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 email.

 

Lots of Screenshots included.

 

For more info visit:

www dot css-oscommerce dot com/mail-manager-for-oscommerce/

and

www dot css-oscommerce dot com/mail-manager-for-oscommerce-operation/

 

Files can also be found on google code:

http://code dot google dot com/p/mobile-oscommerce-addon/downloads/list


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Mail Manager can be found here:

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

 

Mail Manager screenshots can be found here:

http://code dot google dot com/p/mobile-oscommerce-addon/downloads/list

Edited by npn2531

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Emails that can be edited and templated from the admin include the emails that are initiated when a customer create an account, completes an order, requests a password, sends a 'tell a friend' email, recieves when an order status is updated, the single emails sent directly from the admin to a customer, and the newsletters.


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Do you have the screenshots anywhere? Comment says lots of screenshot included (although I can not find them!)

 

Not on your webpage either.

 

Very interested in your project.

Share this post


Link to post
Share on other sites

Just one question...

When I have installed e.g. payment modules like paypal that use their own mail function in the payment module itself, can I then replace the original mail code with the mail manager email code from

the cahckout_process.php and it works???

 

if (file_exists(DIR_WS_MODULES.'mail_manager/order_confirm.php')){
include(DIR_WS_MODULES.'mail_manager/order_confirm.php'); 
}else{ 
tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); 
}

Share this post


Link to post
Share on other sites

Do you have the screenshots anywhere? Comment says lots of screenshot included (although I can not find them!)

 

Not on your webpage either.

 

Very interested in your project.

Sorry about that, the folder was too big to upload to the OSCommerce site. You can find them on google code.

http://code.google.com/p/mobile-oscommerce-addon/downloads/list


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Just one question...

When I have installed e.g. payment modules like paypal that use their own mail function in the payment module itself, can I then replace the original mail code with the mail manager email code from

the cahckout_process.php and it works???

 

if (file_exists(DIR_WS_MODULES.'mail_manager/order_confirm.php')){
include(DIR_WS_MODULES.'mail_manager/order_confirm.php'); 
}else{ 
tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); 
}

Mail Manager only interrupts that one line in checkout_process.php ie

tep_mail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], EMAIL_TEXT_SUBJECT, $email_order, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); 

All the programming previous to that line is intact and available to the paypal module. In other words, the paypal module should function exactly the same with or without the Mail Manager module installed.


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Thanks! I am currently testing the contrib, not so bad... :)

 

But it seems to me, that not all variables work, the $customername for exmaple in status mail

doesn't work for my shop. Also I wonder where I should edit the mail subject.

Share this post


Link to post
Share on other sites

Thanks! I am currently testing the contrib, not so bad... :)

 

But it seems to me, that not all variables work, the $customername for exmaple in status mail

doesn't work for my shop. Also I wonder where I should edit the mail subject.

Look at line 34 in catalog/includes/modules/mail_manager/status_update.php. The variable '$name' is probably not properly defined.

 

Try adding this:

$name=$check_status['customers_name'];

 

just above the comment

//define placeholders

 

which should add it to the list under

//define values for placeholder variables


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Yes, that helps!

 

btw: this contrib is currently not multilanguage?

I think that would also be a good thing to include in the next version.

Share this post


Link to post
Share on other sites

Glad that was the issue.

 

Language: If you make a translation into another language post the files here:

http://code.google.com/p/mobile-oscommerce-addon/downloads/list

 

and I will have them available to add them to the next Mail Manager update.


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

I get the following error when i try to send using the bulk mail manager....

 

1146 - Table '*******_******.TABLE_PRODUCTS_XSELL' doesn't exist

 

select distinct p.products_id, p.products_image, pd.products_name, p.products_tax_class_id, products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, specials_new_products_price from TABLE_PRODUCTS_XSELL xp left join products p on xp.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where xp.products_id = '98595' and p.products_status = '1' order by sort_order asc Limit 3

 

[TEP STOP]

 

BulkMail Manager

 

Does the XSELL contrib need to be installed for this to work?

 

Thanks

Share this post


Link to post
Share on other sites

OK. i went ahead and added the XSELL databse entries and everything works now.

 

I'll go ahead and install the full XSELL contrib. Its something i should be using anyway

Share this post


Link to post
Share on other sites

Glad it works. You only need the xsell module if you use the sale_followup.php module. This is a separate module that sends a post sale letter to customer and includes links and images to cross sold items.


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Thanks for the great contri

 

Everthing works great only,

i have track trace dutch but now i installed mail manager and now is track trace not in the email that sent to the costumer.

 

Please can somebody help me?

Share this post


Link to post
Share on other sites

Open includes/modules/mail_manager/status_update.php

 

change:

$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');

 

to:

// SADESA ORDER TRACKING
//$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');
$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "'>" .  tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" .
// /SADESA ORDER TRACKING   


Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Open includes/modules/mail_manager/status_update.php

 

change:

$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');

 

to:

// SADESA ORDER TRACKING
//$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');
$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "'>" .  tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" .
// /SADESA ORDER TRACKING   

 

Thank you for your help.

I have made the changes but now i have in the mail no url.

Share this post


Link to post
Share on other sites

Thank you for your help.

I have made the changes but now i have in the mail no url.

 

I m sorry i have now 2 the same links in the update mail to account history not to track trace.

Share this post


Link to post
Share on other sites

Add the original url to the string similar to I have done below. You can vary the definition of $invoice_url any way you need. Unless I have made a typo this should add both urls to your email:

 

$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "'>" .  tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" . ' <br/>View the invoice on your account below<br>'.
tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');

 

Play around with it. Be careful with the . and ' 's. Note that the html email will ignore the line break \n , and the text version will add the <br/> literally as <br/>. To solve that you can create another placeholder to use only on the text version.

Edited by npn2531

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

Add the original url to the string similar to I have done below. You can vary the definition of $invoice_url any way you need. Unless I have made a typo this should add both urls to your email:

 

$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "'>" .  tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" . ' <br/>View the invoice on your account below<br>'.
tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');

 

Play around with it. Be careful with the . and ' 's. Note that the html email will ignore the line break \n , and the text version will add the <br/> literally as <br/>. To solve that you can create another placeholder to use only on the text version.

 

I m sorry but i dont know what you mean.You have no code for track trace dutch.

Really thanks for your time.

Share this post


Link to post
Share on other sites

Try this:

open includes/modules/mail_manager/status_update.php

 

replace

$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');

 

with

// SADESA ORDER TRACKING
//$invoice_url = EMAIL_TEXT_INVOICE_URL . ' ' . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL');
$invoice_url = $email ;
// /SADESA ORDER TRACKING   

 

Note on admin/orders.php you will find a variable $email on about line 76. That variable contains all the info needed for the tracking module. This should put the tracking info in the email.

 

However it is going to duplicate info contained in the other mail_manager placeholders. This is not a problem, as you can simply not use those mail_manager placeholders.

 

Note also that the string defined by the variable $email in the tracking module uses \n\n\ for line breaks. The html version of the resulting mail_manager email is going to ignore those line breaks and run everything together on one line.

 

If the above works, experiment with isolating the tracker code you need

 

for example, on order.php that string that defines $email is this:

 

$email = STORE_NAME . "\n" . EMAIL_SEPARATOR . "\n" . EMAIL_TEXT_ORDER_NUMBER . ' ' . $oID . "\n" . EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" .tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "'>" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" .  


Nederland_URL . ' ' . "<a HREF='" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "'>" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "</a>\n\n\n".

Europa_URL . ' ' . "<a HREF='" .(URL_TO_TRACKNRBL.''. $track_num) . "'>" .(URL_TO_TRACKNRBL.''.$track_num) . "</a>\n\n\n".


URL . ' ' . "<a HREF='" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "'>" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "</a>\n".
$notify_tracking .$notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); 

 

changing it to:

$email =  EMAIL_TEXT_INVOICE_URL . ' ' . "<a HREF='" .tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "'>" . tep_catalog_href_link(FILENAME_CATALOG_ACCOUNT_HISTORY_INFO, 'order_id=' . $oID, 'SSL') . "</a>\n" . EMAIL_TEXT_DATE_ORDERED . ' ' . tep_date_long($check_status['date_purchased']) . "\n\n" .  
Nederland_URL . ' ' . "<a HREF='" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "'>" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "</a>\n\n\n".
Europa_URL . ' ' . "<a HREF='" .(URL_TO_TRACKNRBL.''. $track_num) . "'>" .(URL_TO_TRACKNRBL.''.$track_num) . "</a>\n\n\n".
URL . ' ' . "<a HREF='" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "'>" .(URL_TO_TRACKNR.''. $track_num.''.URL_TO_TRACKPC.''.$track_pcode) . "</a>\n".
$notify_tracking .$notify_comments . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); 

 

would remove the store name and order id. Again if you get a single . or ' ' or ; out of place it won't work.

Edited by npn2531

Oscommerce site:

 

 

OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120

Share this post


Link to post
Share on other sites

I use some payment modules which require a specific text to be included in the comfirmation email , for example i use the moneyorder module which includes the bank details.

 

These details are defined in language file of the module (in the footer text ->email_footer; ). Some how this text is not picked up by the order_confirm.php file of mail manager.

 

any ideas on what is missed ?

 

Thank you

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×