intermittent order confirmation emails

PS2: I've had a couple orders go through without the confirmation email being sent to the customer or merchant. The order makes it to Auth.net, and the Auth.net receipt is being sent to the customer and merchant, but no PS2 receipt is sent to either. These orders are also missing from the db. I think I may have "stepped on" a couple orders while updating WA_Store_Cart_PHP.php page, but not the most recent. Could it be a server issue?

Have you made any modifications to the confirm page? This is the page that should be storing the orders in your db and sending the emails. If this page were updated it could be processing the transaction and sending the user directly to the checkout success page without storing the order in the db or sending out the email message. Please post back with a copy of this page in a zip archive so that we can take a look.

I have updated the page, and believe that I "stepped on" a couple of orders, but not the most recent order. Everything regarding the ordering process has been and still is working great with the exception of this "skipped" order. That's why I was wondering if it could be a server issue? Could: The Auth.net part of the transaction go through successfully while at the same time the mail server has a hiccup preventing the UEmail message from being sent?

The code looks ok on the page to me. If you are getting a good result now it would seem that the page is ok. What you have described with the order going through but no email being sent is possible, however most of the time server issues like this are not sporadic. Have you tested this with different email addresses? There could be problems regarding certain email addresses that are causing this problem.

So long as you can see that the order has gone through and is recorded in the db there should not be any problem. If you are testing this out and go from the checkout success page directly to the site and test it again you might possibly update an existing order rather than create a new one. If you find this happening to you then you can stop it by adding this code to the bottom of the checkout success page:

<?php

if(!session_id()) session_start();

session_regenerate_id();

unset($_SESSION);

@session_start();

?>

That's the thing, not ALL orders are getting recorded in the db. Last weekend for example we had 5 new orders go through Auth.net, but only 4 orders (and users) were added to the db.

All UEmail messages sent from the store go to two different email addresses. Everything has been working like a champ except for this one missed order.

Thanks.
--
whit

it can be very difficult to determine the cause of a sporadic issue. If there was no db entry for the order and no user registered there might be something very specific to that order that is causing it to behave that way. Do you know if this was a new user or an existing user? The issue that I was referring to in my earlier post was that if you go through a second checkout you could have a situation where it is not recorded as a new transaction. This is what the code sample I provided should fix.

In the 1 in 5 ordes that did not go through did you get the email messages? If not what info are you using to determine that the order was not completed? Please post back with the details and any others that you can think of. If there is an issue with the code or how the pages are working it will be very important to be able to reproduce the issue so that we can determine what is going wrong.