57 replies to this topic

[npn2531]

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

[npn2531]

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, 06 August 2011, 18:07.

[npn2531]

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.

[gilo_m]

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.

[mightyx]

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); 
}

[npn2531]

gilo_m, on 08 August 2011, 09:44, said:

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

[npn2531]

mightyx, on 10 August 2011, 21:25, said:

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.

[mightyx]

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.

[npn2531]

mightyx, on 11 August 2011, 15:44, said:

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

[mightyx]

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.

[npn2531]

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.

[pctekcomponents]

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

[pctekcomponents]

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

[npn2531]

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.

[thom000]

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?

[npn2531]

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   

[thom000]

npn2531, on 21 August 2011, 16:53, said:

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.

[thom000]

thom000, on 21 August 2011, 17:33, said:

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.

[npn2531]

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, 21 August 2011, 18:01.

[thom000]

npn2531, on 21 August 2011, 18:01, said:

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.