npn2531 Posted August 6, 2011 Share Posted August 6, 2011 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 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
npn2531 Posted August 6, 2011 Author Share Posted August 6, 2011 (edited) 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 August 6, 2011 by npn2531 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
npn2531 Posted August 7, 2011 Author Share Posted August 7, 2011 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. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
gilo_m Posted August 8, 2011 Share Posted August 8, 2011 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. Quote Link to comment Share on other sites More sharing options...
mightyx Posted August 10, 2011 Share Posted August 10, 2011 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); } Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 11, 2011 Author Share Posted August 11, 2011 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 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
npn2531 Posted August 11, 2011 Author Share Posted August 11, 2011 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. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
mightyx Posted August 11, 2011 Share Posted August 11, 2011 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. Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 11, 2011 Author Share Posted August 11, 2011 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 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
mightyx Posted August 12, 2011 Share Posted August 12, 2011 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. Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 12, 2011 Author Share Posted August 12, 2011 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. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
pctekcomponents Posted August 17, 2011 Share Posted August 17, 2011 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 Quote Link to comment Share on other sites More sharing options...
pctekcomponents Posted August 18, 2011 Share Posted August 18, 2011 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 Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 18, 2011 Author Share Posted August 18, 2011 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. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
thom000 Posted August 21, 2011 Share Posted August 21, 2011 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? Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 21, 2011 Author Share Posted August 21, 2011 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 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
thom000 Posted August 21, 2011 Share Posted August 21, 2011 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. Quote Link to comment Share on other sites More sharing options...
thom000 Posted August 21, 2011 Share Posted August 21, 2011 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. Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 21, 2011 Author Share Posted August 21, 2011 (edited) 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 August 21, 2011 by npn2531 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
thom000 Posted August 21, 2011 Share Posted August 21, 2011 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. Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 21, 2011 Author Share Posted August 21, 2011 (edited) 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 August 21, 2011 by npn2531 Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
thom000 Posted August 21, 2011 Share Posted August 21, 2011 Thank you 100 times it works great!! Quote Link to comment Share on other sites More sharing options...
Sjef keuken Posted August 22, 2011 Share Posted August 22, 2011 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 Quote Link to comment Share on other sites More sharing options...
npn2531 Posted August 22, 2011 Author Share Posted August 22, 2011 Post a link to the contribution and I will take a look. Quote Oscommerce site: OSC to CSS, http://addons.oscommerce.com/info/7263 -Mail Manager, http://addons.oscommerce.com/info/8120 Link to comment Share on other sites More sharing options...
Sjef keuken Posted August 22, 2011 Share Posted August 22, 2011 http://www.oscommerce.com/community/contributions,3573/category,1/search,moneyorder_with_more_data Here is the link Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.