Jump to content

npn2531

Members
  • Content count

    1,159
  • Joined

  • Last visited

  • Days Won

    11

Everything posted by npn2531

  1. npn2531

    Mail Manager

    In mail manager there is a working sample newsletter called the 'sale followup' email that is date sensitive, but not a weekly newsletter. This sale followup has two variables $wait_until = date('Y-m-d g:i:s', strtotime("-10 days")); $ignore_before = date('Y-m-d g:i:s', strtotime("-30 days")); That allow it to select recent orders and prepare a mailing with info from those orders, and the customers who placed those orders. Also note that mail manager selects customers to mail to based on the value in a new field in the customers table called mmstatus. In each mailing, after it mails a customer it updates the value in this field from '0' to '9'. Once it completes a mailing, all the customers that were selected for mailing have a mmstatus of '9'. It then resets or changes this value in mmstatus back to '0' for all the customers it has mailed to. If the value in mmstatus does not get reset back to '0', then the next time you run that mailing, it will mail 0 customers and say 0 sent. My guess is that somebody has changed something in the original programming and this value is not being reset. Check your customer list after a mailing and see if you have any customer records with a mmstatus value of '9'. If you do then something is amiss. Also note that mail manager does not use the values 'true' or 'false' in any of it's programming. It does use php terminology == and != however.
  2. npn2531

    Mail Manager

    EMAIL_PASSWORD_REMINDER_SUBJECT and EMAIL_PASSWORD_REMINDER_BODY are defined in catalog/includes/languages/english (or your language)/password_forgotten.php. Make sure you have the code below working in catalog/password_forgotten.php. require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PASSWORD_FORGOTTEN);
  3. npn2531

    Mail Manager

    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.
  4. npn2531

    Mail Manager

    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.
  5. Thanks, is that the same program as either of these?: http://addons.oscommerce.com/info/8719 http://addons.oscommerce.com/info/6521
  6. npn2531

    Mail Manager

    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.
  7. Is there a version of this contribution available for 2.2RC2a?
  8. npn2531

    Mail Manager

    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.
  9. npn2531

    [Addon} Superfish Categories Box

    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
  10. npn2531

    Mail Manager

    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.
  11. npn2531

    Mail Manager

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

    Mail Manager

    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
  13. npn2531

    Mail Manager

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

    Mail Manager

    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.
  15. npn2531

    Mail Manager

    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>.';
  16. npn2531

    Mail Manager

    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.
  17. npn2531

    Mail Manager

    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.
  18. npn2531

    Mail Manager

    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.
  19. npn2531

    Mail Manager

    Actually the email is sent first, then it waits.
  20. npn2531

    Mail Manager

    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.
  21. npn2531

    Mail Manager

    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.
  22. npn2531

    Mail Manager

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

    i thought you had to pay for authorize.net

    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.
  24. npn2531

    Mail Manager

    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.
  25. npn2531

    Mail Manager

    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.
×