162 replies to this topic

[noval]

I need to add one field phone

Thanks

[kotaro]

Hello,

Yesterday night I (store owner) suddenly stopped receiving emails with order confirmations. I use Credit Cards to accept payments and it was working just fine. I do receive email with authorization from Authorize (those come from authorize itself) but neither I or customers receive confirmation emails or update emails from the store application. I tried to order something, tried to update, tried to send email from newsletter manager and still nothing.

Can anyone help me or point me in direction where to look for the problem. I haven't done any new updates from the time it was working so i have no idea why it would stop sending emails.

Thank you

[soodanim]

Wondering if anyone can help

I've set up a separate form and all is good except....

I don't want the "fields" for the customers name and email address to be changed.

How do it just get the name and email address to show on the form (after they've logged in) and then send it on in the email?

<?php echo tep_draw_input_field('name', ($error ? $HTTP_POST_VARS['name'] : $customers['customers_firstname'] . ' ' . $customers['customers_lastname'])); //rmh M-S_fixes ?>

I'm guessing it's the tep_draw_input_field part I need to change but I don't know what it should be.

[blr044]

The welcome email the customer receives has the store's owner email address located at the bottom as this:

For help with any of our online services, please email the store-owner: sales@greatdiscounts4u.com.

Looked in create_account, both catalog and the language file to find a way to make that a active link so that the customer can just click and outlook will open or whatever mail program they use. I do have E-Mail options in admin set to true. So am asking if this is a possibility.

Thanks.

[multimixer]

blr044, on 28 July 2010, 03:22, said:

The welcome email the customer receives has the store's owner email address located at the bottom as this:

Normally it should work the way you want it. On my side all email addresses are clickable in this way

[birdrockdesigns]

This is a brilliant and helpful thread.

Does anyone know how/if you can add multiple email addresses to the store owner field in the admin section?

Thanks!

[multimixer]

birdrockdesigns, on 08 August 2010, 04:17, said:

This is a brilliant and helpful thread.

Does anyone know how/if you can add multiple email addresses to the store owner field in the admin section?

Thanks!

You could use the"extra orders emails" field for this

[cemrotterdam]

multimixer, on 24 June 2009, 12:05, said:

D. How to add customers phone and email into the order confirmation email? This solution also puts text at the top and bottom of the mail, the customers comments go to the bottom of the mail and there is a customer greeting instead of the store name

1) in file catalog/checkout_process.php find the part that refers to the email. Changes to the original code are marked with BOf/EOF

// lets start with the email confirmation
//BOF Multimixer 21.6.09
//$email_order = STORE_NAME . "\n\n" .
  $email_order .= EMAIL_TEXT_CUSTOMER_GREETING . ' ' . $order->customer['firstname'] . ' ' . $order->customer['lastname'] . "\n\n".
				   EMAIL_TEXT_GREETING . "\n" .
//EOF Multimixer
				 EMAIL_SEPARATOR . "\n" . 
				 EMAIL_TEXT_ORDER_NUMBER . ' ' . $insert_id . "\n" .
				 EMAIL_TEXT_INVOICE_URL . ' ' . tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, 'order_id=' . $insert_id, 'SSL', false) . "\n" .
				 EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";
				 
  $email_order .= EMAIL_TEXT_PRODUCTS . "\n" . 
				  EMAIL_SEPARATOR . "\n" . 
				  $products_ordered . 
				  EMAIL_SEPARATOR . "\n";

  for ($i=0, $n=sizeof($order_totals); $i<$n; $i++) {
	$email_order .= strip_tags($order_totals[$i]['title']) . ' ' . strip_tags($order_totals[$i]['text']) . "\n";
  }

  if ($order->content_type != 'virtual') {
	$email_order .= "\n" . EMAIL_TEXT_DELIVERY_ADDRESS . "\n" . 
					EMAIL_SEPARATOR . "\n" .
					tep_address_label($customer_id, $sendto, 0, '', "\n") . "\n";
  }
  //BOF Multimixer 19.6.09
  $email_order .= EMAIL_TEXT_CUSTOMER_TELEPHONE . ' ' . $order->customer['telephone'] . "\n";
  $email_order .= EMAIL_TEXT_CUSTOMER_MAIL . ' ' . $order->customer['email_address']. "\n\n";
  // EOF Multimixer


  $email_order .= "\n" . EMAIL_TEXT_BILLING_ADDRESS . "\n" .
				  EMAIL_SEPARATOR . "\n" .
				  tep_address_label($customer_id, $billto, 0, '', "\n") . "\n";
  //BOF Multimixer 19.6.09
  $email_order .= EMAIL_TEXT_CUSTOMER_TELEPHONE . ' ' . $order->customer['telephone'] . "\n";
  $email_order .= EMAIL_TEXT_CUSTOMER_MAIL . ' ' . $order->customer['email_address']. "\n\n";
  // EOF Multimixer
  if (is_object($$payment)) {
	$email_order .= EMAIL_TEXT_PAYMENT_METHOD . "\n" . 
					EMAIL_SEPARATOR . "\n";
	$payment_class = $$payment;
	$email_order .= $order->info['payment_method'] . "\n\n";
	if ($payment_class->email_footer) { 
	  $email_order .= $payment_class->email_footer . "\n\n";
	}
  }
  //BOF Multimixer 19.6.09
  if ($order->info['comments']) {
	$email_order .= EMAIL_TEXT_CUSTOMER_COMMENT . "\n".
					EMAIL_SEPARATOR . "\n".
					tep_db_output($order->info['comments']) . "\n\n";
  }
	  $email_order .= EMAIL_TEXT_SIGNATURE . "\n";
//EOF Multimixer

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

2) Find the file catalog/includes/languages/yourlanguage/checkout_process.php

Add before the end

//BOF Multimixer 19.6.09
define('EMAIL_TEXT_CUSTOMER_TELEPHONE', 'Telephone:');
define('EMAIL_TEXT_CUSTOMER_MAIL', 'email:');
define('EMAIL_TEXT_GREETING', 'Thank you for choosing Aquamed. In this mail you will find all information about your order. For more information, please click on "Detailed Invoice". ');
define('EMAIL_TEXT_SIGNATURE', 'Please do not delete this email until you get your order delivered. For any question regarding your order please reply to this email and don\'t send a new one. It contains information that will enable us to hadle your request faster.');
define('EMAIL_TEXT_CUSTOMER_COMMENT', 'Your comments:');
define('EMAIL_TEXT_CUSTOMER_GREETING', 'Dear');
//EOF Multimixer

Thank you. It saved me a lot of time and stress

[hhitch]

Hi, I have come up against one really annoying email issue. I don't totally blame osCommerce, I believe the issue really has to do with some strict settings on Network Solutions mail servers. But strictly speaking, apparently osCommerce is sending emails which can be interpreted as breaking the rule of rfc822 section 2.3 which states that the body of an email may not contain a lone carriage return or line feed.


Reporting-MTA: dns;weasel
Received-From-MTA: dns;weasel
Arrival-Date: Sat, 9 Oct 2010 20:19:05 -0400

Final-Recipient: rfc822;buyer_1286563776_per@webdimensions.org
Action: failed
Status: 5.6.0
Diagnostic-Code: smtp;550 5.6.0 Lone CR or LF in body (see RFC2822 section 2.3)


I've done the research on this, and I've discovered that Network Solutions has become notoriously strict for enforcing this rule on their mail servers. I've found that in order to examine the email for such a lone character, one needs to go through the message with a HEX editor in order to identify it, and that Network Solutions email servers have been set up with such a filter to examine each and every email the comes in for same.

And, unfortunately, for some reason the osCommerce mailer seems to put at least one of these lone CRs or LFs into the message, somehow. What I've learned is that most mail servers around the world are not set with such strict filters, but because of some hacking exploits that have been used on Netsol recently, they have upped their security to the nth degree. The fact is that most servers still let the mail through if there is a lone CR or LF, but strict interpretation of rfc 822 section 2.3 makes Netsol within their rights to refuse to make changes to their mail servers. So...

yes I have some email accounts with them. It's not so much that I want to enable this to work for me specifically, because I can always use another provider like GMail -- I've tested with GMail and there's no problem whatsoever! Also, I've tried sending mail to my Netsol accounts with a variety of email clients AND applications, and they all get through. Plus I have "Send extra order emails" configured to send copies to my GMail address so I know what is going out, and I'm checking the server logs on my SMTP server as well as the "BadMail" file which is where these "Lone CR/LF" messages end up. I can say for sure at this point that the only thing that doesn't seem to work is the osCommerce mailer sending to Netsol mail servers. Which is frustrating because I love this osCommerce implementation! I'm just more concerned about my potential customers who may be using Network Solutions for their mail hosting.

Since I can't get Netsol to change, I'm wondering if there is anyway to modify the scripts for osCommerce to make ABSOLUTELY SURE that no lone CRs or LFs are getting into the mails. This is primarily with the Order Process emails that go out when a customer buys something. I've found that the majority of this particular message does not get through NetSol servers, whereas the other ones do, like the "Contact Us" messages and the new registration welcome messages. Those got through fine! It's just the email that a customer is supposed to receive right after they place an order which is not going through. I think that is about the most important one. So if they're on Netsol they are not going to receive those messages.

I was thinking maybe a simple Regular Expression could convert these pesky lone CRs and LFs, but I was also concerned that such might interfere with embedded image data or other MIME data. I do have "CRLF" selected in the Admin console for my email options. Apparently, that doesn't make any difference. I've also tried this with both SMTP and Sendmail option, both work for "Contact Us" messages but neither can get through for Order Process messages for the same reason. And, I've tried it with MIME Html settings both on and off, and the same problem occurs either way. So there just has to be something in the mail generation process on osCommerce that is inserting a pesky lone CR or LF, somewhere.

Any help that anyone could provide on this very annoying matter would be very, very much appreciated. I could continue trials and errors for the next two weeks or however long it takes to figure it out, but if someone on this board could provide a quicker solution, I would be extremely pleased and grateful.

My sincere thanks in advance,
Hugh

[w3coy]

This is a very beautiful effort.

MultiMixer --- you are a hero!

Edited by w3coy, 29 March 2011, 20:14.

[jhande]

multimixer, on 24 June 2009, 11:39, said:

I worked out some solutions for mails, they are already posted all around the forum, now I want to share them in a organized way. I hope somebody will find this useful.

A. How to get a notification when a person register.

1) Set up the "extra order emails" feature in Admin/my store

2) In file catalog/create_account.php

Find the lines

email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;
      tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

Place after

 // BOF multimixer 24.6.2009 send emails to other people
      $owners_text = EMAIL_TEXT_OWNER_INFO . "\r\n" .EMAIL_TEXT_CUSTOMER_NAME . ' ' . $name . "\r\n" . EMAIL_TEXT_CUSTOMER_EMAIL . ' ' .  $email_address . "\r\n" . EMAIL_TEXT_CUSTOMER_PHONE . ' ' . $telephone . "\r\n" . EMAIL_TEXT_CUSTOMER_ADDRESS . ' ' . $street_address . "\r\n" . EMAIL_TEXT_CUSTOMER_CITY . ' ' . $city . "\r\n" . EMAIL_TEXT_CUSTOMER_STATE . ' ' . $state . "\r\n" . EMAIL_TEXT_CUSTOMER_COUNTRY . ' ' . $country;
      
      if (SEND_EXTRA_ORDER_EMAILS_TO != '') {
    tep_mail('', SEND_EXTRA_ORDER_EMAILS_TO, EMAIL_OWNER_SUBJECT, $owners_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
     }
     
     // EOF multimixer

3) In file catalog/includes/laguages/yourlanguage/create_account.php

Put before the end

// mm 24.6.09
define('EMAIL_OWNER_SUBJECT', 'New registration' );
define('EMAIL_TEXT_OWNER_INFO', 'New customer registration, find details below:');
define('EMAIL_TEXT_CUSTOMER_NAME', 'Name:' );
define('EMAIL_TEXT_CUSTOMER_EMAIL', 'email:' );
define('EMAIL_TEXT_CUSTOMER_PHONE', 'Phone:' );
define('EMAIL_TEXT_CUSTOMER_ADDRESS', 'Address:');
define('EMAIL_TEXT_CUSTOMER_CITY', 'City:' );
define('EMAIL_TEXT_CUSTOMER_STATE', 'State:');
define('EMAIL_TEXT_CUSTOMER_COUNTRY', 'Country:');

This will send an email to the additional email as set in admin for every new customer registration.

Because you don't want to read each time the "hello bla bla" text that the customer receives, it contains just the useful information, name, email etc

This has been working for me for quite awhile (with UHTML email installed too) until just recently.

Now I receive this:

New customer registration, find details below:
Name:
email: zakkaryd@hotmail.com
Phone: 5415301462
Address: 1864 Thomas st #16
City: Coos Bay
State:
Country: 223

Notice there's no name or state.

At the same time I am now experiencing problems with the Order Process email (handled by UHTML email).
It is missing the customers name after the word Dear,
Also missing the order #, Delivery & Billing addresses.

I found a thread that discussed the UHTML problem, pointing it to a PayPal issue.
Unfortunately it referred to PayPal Standard and not my PayPal IPN (files don't match).

I would appreciate any help!

[veszka]

Hi,

I have a very strange mail issue. When I create a new customer account (for a test purpose) I don't get any email about it. (I checked the test user mailbox). But when I ordered any or I sent mail via admin part of store or I used the forgotten password function the test user get the emails.
I tested it with yahoo, gmail too.

here is the code (the original) from create_account.php:

// build the message content
      $name = $firstname . ' ' . $lastname;

      if (ACCOUNT_GENDER == 'true') {
         if ($gender == 'm') {
           $email_text = sprintf(EMAIL_GREET_MR, $lastname);
         } else {
           $email_text = sprintf(EMAIL_GREET_MS, $lastname);
         }
      } else {
        $email_text = sprintf(EMAIL_GREET_NONE, $firstname);
      }

      $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;

	  
      tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

     tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
    }
  }

For test I post the value of $name, $email_address and $email_text and all variables contain values.

Has anyone any idea what I did wrong?

Thank you!

[surrfman]

is there a way in 2.3.1 to insert a right column box or module that allows a site visitor to send a tell a friend email, not necessarily about a product (as it already happens on product pages,) but to send the site's url to someone the visitor thinks might be of use to a potential visitor?

Thanks,

Timmy C

[veszka]

veszka, on 21 April 2011, 09:18, said:

Hi,

I have a very strange mail issue. When I create a new customer account (for a test purpose) I don't get any email about it. (I checked the test user mailbox). But when I ordered any or I sent mail via admin part of store or I used the forgotten password function the test user get the emails.
I tested it with yahoo, gmail too.

here is the code (the original) from create_account.php:

// build the message content
      $name = $firstname . ' ' . $lastname;

      if (ACCOUNT_GENDER == 'true') {
         if ($gender == 'm') {
           $email_text = sprintf(EMAIL_GREET_MR, $lastname);
         } else {
           $email_text = sprintf(EMAIL_GREET_MS, $lastname);
         }
      } else {
        $email_text = sprintf(EMAIL_GREET_NONE, $firstname);
      }

      $email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;

	  
      tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

     tep_redirect(tep_href_link(FILENAME_CREATE_ACCOUNT_SUCCESS, '', 'SSL'));
    }
  }

For test I post the value of $name, $email_address and $email_text and all variables contain values.

Has anyone any idea what I did wrong?

Thank you!

Has anyone , any idea ? Thank you!

[Juto]

Hi George.
I am about to convert my shop to use UTF-8.

I have done a lot of reading especially wrt to email and tested some "solutions" which did not work.

So, I would like to have your suggestions on how to get it working.

Many thanks for this brilliant thread.

Sara

[multimixer]

Sara, what exactly is the problem?

[Juto]

Hi George, thank you for answering.
On the catalog side the e-mails received do not contain characters like å ä ö.
When I check the contact_us page by trying to e-mail again (within the time limit) the reposted e-mail contains diamonds instead of å ä ö.
So, the underlying functions for insert text_area etc., do not get the right encoding.

On the admin side (sending newsletter) the reply is "email sent to:" but no recipient shows on that line, further no e-mail is received.

What I would be happy with is the php standard mb_mail function, which at the most can have 5 parameters.

All code pages, language files and the db is in utf-8, and I do have the correct meta tag, plus this line at the bottom of application_top:

//REF: http://www.w3.org/International/questions/qa-html-encoding-declarations#httpheadwhat
header('Content-type: text/html; charset=utf-8');

So, the problem lies within the osCommerce code...

Hopefully Greece will find a way out of the crises...

Sara

[Juto]

multimixer, on 21 June 2011, 13:42, said:

Sara, what exactly is the problem?

Hello George, hopefully you know how to fix this:

Costumers order confirmation are all ok.

But, the extra order email is not. The to: field just look like this: =?utf-8?B??=

And that's very strange since both uses tep_mail

Hoping for help
Sara

[svr.chitra]

Please help : My password forgotten page is not working. After sending request email are not coming to customer and stil it is showing emails are sent. Please tell me how to solve this issue.

[dragrace]

Hi,

I do have a problem with outgoing emails from osCommerce, non of them works. Contact, order confirmation, password forgotten, emails through admin etc. So, i do not get info via email or my customers doesn't either... I had a version 2.2 and thought that updating it for 2.3.1 would fix the problem, but it didn't. So, I'm running version 2.3.1 currently.

Please help!