npn2531

Your English is 95% excellent, and this is a great improvement to the contribution. It is indeed silly to recommend an item already purchased. I will test this out, but if you feel you have it working right, please post this as an update to the contribution. http://addons.oscommerce.com/info/8120 The sale_followup module on the mail manager is one of it's best and unique features.

You can simply not fill in the plain text in the admin in mail manager when you compose your email. However note that all emails can have a plain text alternative anyway embedded in the email. Go to your preferred mail program and find the option to read the email source. You will see that there is always a text alternative. If you don't fill in the plain text, and send the email, and the recipient has his email set to display plain text, then they will see a text rendering of your html email which can be difficult to read.

Thanks, is that the same program as either of these?: http://addons.oscommerce.com/info/8719 http://addons.oscommerce.com/info/6521

I'm not clear if you are saying that everyone on your email list gets two emails, or just you, the administrator? Mail Manager only sends one email. That single email contains both the html and the plain text alternative. You, or the email recipient, uses the mailing program used to read email to choose which alternative displays in your email box.

Is there a version of this contribution available for 2.2RC2a?

Opening templates in a blank unformatted window is a great idea, or perhaps have it open in a mailing program as if you were going to email it.

This will work fine for 2.3 as a horizontal menu with a bit of adjustment in the html to place it nicely in the header. http://addons.oscommerce.com/info/7541 The key feature of the above contribution is adapting btwd's conversion of the categories menu to an unordered list http://addons.oscommerce.com/info/4201 to jquery/superfish

The duplicate email issue is a problem, and could explain the endless loop. If you have two records with the same email address, then mail manager could be sending email to the first record, but updating the second record. Thus it would look like to mail manager that the first record has not been emailed, and it would get emailed again and again. OSCommerce as installed does not allow duplicate emails.

What are the values of customers_newsletter and mmstatus in the customers table of the email that is hanging up?

open catalog/includes/modules/mail_manager/order_confirm.php find: //send email tep_mm_sendmail($order->customer['firstname'] . ' ' . $order->customer['lastname'], $order->customer['email_address'], STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $output_subject, $output_content_html, $output_content_txt); add directly underneath: //send extra email to store owner tep_mm_sendmail($order->customer['firstname'] . ' ' . $order->customer['lastname'], STORE_OWNER_EMAIL_ADDRESS, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $output_subject, $output_content_html, $output_content_txt); Be sure you test this

No, not as written. But there is a 'test' button that will send the email to the admin.

If you find a fix for this I'd love to see it. The preview does the same thing to my admin. I suspect it is because the email templates use inline styling, and are basically made to be stand alone html documents that will display in the recipients email box, and have no connection to the admin's CSS styling or programing.

Works great! I had no issues with any variables, and I ran it just as you posted it. That is a nice touch adding the report notification email. By all means go ahead and post the update to the contribution. I did make one minor addition. It simply repeats one line of your code so that the report link is echoed when the mailing is finished. Add the following to the end of your step 2 above: echo 'You can view the log file containing information on who was emailed and more information <a href="' . HTTP_CATALOG_SERVER . DIR_WS_ADMIN . $log_file_location . '">here</a>.';

Go ahead and post an update. The contribution is open to anyone. I'm looking forward to seeing it. I am not keen on using cron. That involves going outside the OSCommerce program and some set up and configuration on your control panel with your webhost. I wrote the program to be simple and straightforward, to run entirely within the OSCommerce shop. In fact it was my frustration with cron and the issues of maintaining a separate list in phpList or a commercial account like Mail Chimp that motivated me to write mailmanager. What kind of issues do you have with refreshing? I kinda of see it as a plus.

The Mail Manager does give you a running count of what is going on while it is running, but a report file is a good idea. In my earlier manifestation of Mail Manager, the Bulk Mail Manager, http://addons.oscommerce.com/info/6553 , there is a report file. You could, with a basic knowledge of php paste the necessary snippets into Mail Manager to get a report file. In the Bulk Mail Manager, in epis_bulkmailer.php, you will find this snippet which creates a file, "epismaildata.php";, for the report: //create the report file and stamp it with heading, date/time, and newsletter title $stringData1 = "epismaildata.php"; $stringData2 = "<br/>"."$nInfo->title"."<br/><br/>"; $date = date("D, d M Y g:i a").'<br/>'; $myFile = "epismaildata.php"; $fh = fopen($myFile, 'w') or die("can't open file"); $stringData = "$stringData1 $date $stringData2 "; fwrite($fh, $stringData); fclose($fh); Lower down the same page you will find the code that sends the email, displays it, and then appends the name of email to this file // send mail to the next person with a 0 status within newsletter subscribers echo tep_mail($firstname,$email,$nInfo->title,$newsletter_content,$epis_newsletter, STORE_OWNER,STORE_OWNER_EMAIL_ADDRESS); // display email just emailed echo $email; // append this email to epismaildata.php $myFile = "epismaildata.php"; $fh = fopen($myFile, 'a') or die("can't open file"); $stringData = "$email"."<br/>"; fwrite($fh, $stringData); fclose($fh); To adapt to the Mail Manager place the first snippet near the top of admin/includes/mm_bulkmail.php. Place the second snippet (after //apend this emal to epismaildata.php) after this lower down the page: //start mailing loop if($mail['mmstatus']=='0'){ tep_mm_sendmail($mail['customers_firstname'].' '.$mail['customers_lastname'], $mail['customers_email_address'], STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $newsletter['subject'], $output_content_html, $output_content_txt); $email=$mail['customers_email_address']; This is not tested, and will need some correction and polishing, but if you can get a report file installed in Mail Manager, please add it to the contribution here: http://addons.oscommerce.com/info/8120 as an update.

Yes, it does, it will refresh 1700 times. What it is doing is running a simple database query, without a loop. Thus it will pull one record only when the script runs after the page refreshes. You could set up the database query to run as a loop with a limit on the number of records it pulls. Then it would indeed email them as chunks, and then refresh, and you could still moderate the emailing. But what difference does it make if the page refreshes 1700 times or 170 times? It's not like it's important to have pinpoint accuracy in setting the speed. If you set it to say 8 and it runs somewhere between 400-450 emails an hour, that's close enough, at least for me.

Actually the email is sent first, then it waits.

Yes, sending out 1700 emails will take a long time, but that is the point of the program. It works on a continual basis, kinda simple. You can run it in a second window. It simply sends an email, waits, then refreshes. The refreshing simply reopens the page, and the script automatically restarts, sending an email and then waiting again until it refreshes. So I guess in effect it is sending the emails in chunks, but a small chunk of 1 record.

Turn the fraction over, or reverse the order you are punching the numbers into the calculator. ie 500\3600 not 3600\500 BTW, yes you can put in a number less than 1. Note however, that this number is the wait time between refreshes, and does not count the time the computer takes to refresh. Your web host service is only seeing the total time between emails sent. For example if set the time to '0.1' you are not really going to send 10 emails a second. You are going to send one email 1/10 of a second after the page reloads. I used to teach math in High School and I wanted to ban calculators until students got to Geometry, because I think calculators ruin the ability to estimate a result. On the other hand the ancient Greek Philosophers were concerned writing would ruin the ability of people to memorize things.

Yes there is. Look for the 'placeholders' in the sample emails included in the contribution.

Or set up your merchant account for authorizenet directly with your large multinational bloodsucking bankster (the banks you see everywhere, the ones with logos in two letters in blue and red or with stage coaches). That way you get same day deposit into your bank account, have fees and percentages subtracted monthly (instead of per item before they are deposited) and have one less entity to deal with.

One deficit with MM is that there is no checking on the validity of an email or even the format of an email. You can use OSCommerce to check the format of an email by putting restrictions in the database for the field that hold customer emails. ( I think it does this already?) Commercial mail programs such as Mail Chimp may have a way of 'pinging' email addresses to see if they exist, and there are also stand alone programs that will check to see if an email exists. (google 'email checking' or some such). Validity and format checking at least lets you know if you are emailing valid email addresses. You can assume that in MM when you see the completed MM message that MM emailed all the records in the email field in customer table in the database. (noting of course that MM will attempt to email anything in that record regardless of whether it is an email or not) You can also put in tracking links in emails, and get feedback if someone clicks on a link, and also programs exist that allow you to see if an email was opened or read. (Google 'email tracking' or similar) If you get anything like the above incorporated into MM, I would love to see it. It would really enhance MM.

Your link shows that you have the table 'mmstatus' installed but not the table 'mm_responsemail'. Recheck the installation instructions to make sure you get that table installed. Yes, the admin is a bit off, but it will not affect how the program works. To fix it you will have to adjust the html a bit, or recheck that you have it installed correctly.

Check and make sure you have added the new tables to the database that this add-on requires. (You should see how to do this in the instructions.)

One simple hack would be to place the language definitions directly in checkout_process.php near or at the top. If you wanted to preserve the ability to switch between french and english you could use a simple if statement. For example: if ($languages_id == '3'){ define('HELLO_CUSTOMER', 'Bonjour'); }else{ define('HELLO_CUSTOMER', 'Hello'); } (note I'm guessing that '3' is the OSCommerce database number for French)