Order Confirmation Not Being Delivered

[djjase]

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

[velvetgirl]

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.

[yoz8225]

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!

[captonzoom]

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.

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

[snifferdog]

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.

[snifferdog]

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.

[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?

[snifferdog]

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:

[FONT="Courier New"]Invalid integer value: ''[/FONT]

(That's two adjacent single quotes there). Of course another solution would be to omit the column from the INSERT statement entirely if it is not preset in the POST. It's the empty value that trips up MySQL.

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.

[scatterjim]

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