Order Confirmation Not Being Delivered

Ok I know this is just something stupid that I missed when I set up my second store, but I can't figure out what.
I receive the PayPal receipt but not the order confirmation. The customers aren't receiving it either. Any ideas?
Thanks guys! :)

See https://www.zen-cart.com/tutorials/index.php?article=111

Have to determine if they are being generated but not delivered

Thanks! All the settings in the email section of the admin are set exactly like my other store and everything is working fine in that one. The site has never sent them, I thought it was just not coming to me until a customer told me today that she has never gotten one either.

If your order confirmations for PayPal transactions are not being sent and the orders aren't showing up in your admin area, then you need to troubleshoot the communications between PayPal's servers and your server, and/or fix settings in your PayPal account, etc.
Troubleshooting guide: http://www.zen-cart.com/wiki/index.php/PayPal

Check the tutorial and insure that they are being generated

The orders confirmations from paypal are being sent, and the orders are showing up in the store, me and the customers just aren't getting the order confirmations from the store.

kobra:

Check the tutorial and insure that they are being generated
"Try enabling the Email Archiving feature" how do I do that?

admin > config > email options > Email Archiving Active?

Ok I have turned it on.

Now you need to download the Email Archive Manager, which will allow you to view the archives:

http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_41&products_id=198

I am getting the same type of error - must be something to do with paypal addon.

I had a order from the USA from a guy using PayPal and I got no order confirmation email, just the email from Paypal stating I had received funds. The order was in Admin.

I logged in with a test account, created a order and got the email notification. I didnt use paypal as the payment option.

Could it be

(1) Related to Paypal or
(2) Related to Country of Customer?

Customer in USA, shop is in Australia

I am beginning to have this problem again, myself. Everything has been working fine up until this morning. I did receive a few order confirmations this morning as normal then all of a sudden it stopped. I have not made any changes to Zencart or Payal. I just reinstalled the PayPal module but with no effect. The orders are being generated since they are showing up in my Admin - all settings appear to be correct for email, etc.

I am having the exact same problem............customer orders are being generated by the admin, but I am all of a sudden not receiving them via e-mail like I have been for the past 18 months! I haven't changed anything in my admin set up. I wind up having to go to the admin to manually print out the orders. This began happening about 2 weeks ago. I checked with my hosting company, but they can find a problem on their side. HELP!

I am having the SAME problem. There has to be a better answer then, "Look at this forum page" Does anyone have the EXACT answer to this issue? It looks like LOTS of people are all of the sudden having this issue.

Please help.

I have this problem too, I dont even have the order in my admin, so I missed many orders even got payment from nochex, but I dont know what the order was.

Help please.

I too have this problem. I am using PayPal IPN and no order confirmation emails are being generated (either to me or to the customer) when the customer places an order.

I have both email archiving and IPN debugging enabled and these show that (a) all the IPN stuff is working as it should, and (b) Zen Cart is not sending order confirmations either to me or to the customer when the order is placed. The orders are showing up in admin OK, and if I subsequently change the order status manually (from processed to delivered, say) then emails are sent to both parties at that time.

There's clearly something wrong. It looks like a bug. Can anybody help? This is a serious problem for me. I am running Zen Cart 1.3.8a, on IIS if that makes a difference, and currently I am testing with the PayPal sandbox.

TIA - Paul Sanders.

OK, I think I have sussed it.

I am running PHP 5 and MySQL 5, which may be relevant.

There are some bugs in the PayPal IPN handling code which cause it to abort before it reaches the bit where it sends out the emails. To resolve this problem, I edited file ipn_main_handler.php, which us in the top level directory where installed Zen Cart.

The necessary changes are as follows. Make a backup copy of this file before you start!

After the line:

ipn_debug_email('Breakpoint: 2 - Validated transaction components');

Insert the following statements:

if ($_POST ['exchange_rate'] == '') $_POST [exchange_rate] = 1;
if ($_POST ['num_cart_items'] == '') $_POST [num_cart_items] = 1;
if ($_POST ['settle_amount'] == '') $_POST [settle_amount] = 0;

And change the line which reads:

'customer_notified' => false

To read:

'customer_notified' => 0

There may be other problems but this works for me. Over to you DrByte.

I assume that the changes you propose are related to the database failing to accept the submitted data due to datatype mismatches where the missing values are treated as blanks instead of strings?

Hi DrByte,

I think the database columns in question are integers (or other numeric types) rather than strings. MySQL appears not to accept an empty value for such columns in INSERT statements (you would think it would apply the default, would you not?). The error message when num_cart_items was missing from the POST was something like:

Invalid integer value: ''

I'm only guessing here, but PayPal may have changed the contents of their IPN POST's. That would explain why this problem has suddenly started occurring. And / or it may be that this problem is specific to MySQL 5. MySQL is not my field of expertise.

Anyway, I hope that is all clear. Suggestion:

$db->SetErrorHandler (MyDBErrorHandler);

function MyDBErrorHandler ($error_code, $error_msg)
...

And use this in ipn_main_handler.php to email (or log) any SQL error that occurs (and *then *die). Currently the script just outputs an error message that nobody ever sees. I would also email any other forms of failure to the administrator (e.g. INVALID), regardless of the debug setting. Such events signal a problem that the store owner should look into.

Good piece of software by the way, Zen Cart. You have left osCommerce far behind. Keep up the good work.

timzhou:

I have this problem too, I dont even have the order in my admin, so I missed many orders even got payment from nochex, but I dont know what the order was.

Help please.

Hi Snifferdog et al,

I also use Nochex instead of PayPal - is your database solution, re ipn_main_handler.php, the same for both payment systems?

Thanks