New online order sends previous email receipt

My client has had a vexing problem we just diagnosed. After a customer completes an order and is directed to the checkout success page, Authorize.net automatically sends an order confirmation to the client and a receipt is sent to the customer. I have the system set up to send another email - more of a user friendly version of the Authorize.net email ("the Order") - to the client. Since we transitioned and I changed from a remote to local checkout, the Order has been coming after the initial Authorize.net notice, often significantly, like 24 hours or even several days. I finally figured out that the Order email is only sent when another new order is placed; it's one behind in the queue.

How do I correct this problem? I'm not sure which files to send you to take a look - please let me know.

Thanks - Joe

I'll take a look, but that makes no sense. I'm thinking it must be a strange issue with the SMTP server.

Create a blank page on your site with the code:

<?php

@session_start();

var_dump($_SESSION);

?>

Then complete a transaction and browse to that page.

It will show you the contents of the email you just tried to send (with a bunch of other junk you can ignore).

Is the email body listed on that page from the previous order or the current one? If it is from the previous order, then there is an issue with your code, if it is from the current then it is an odd issue with the SMTP server and you can ask your hosting company to debug the strange delay.

I posted the page with that code and then ran a transaction. Unfortunately, I only got this on my session page:
array(0) { }

What next?

Your payment success page must be clearing the session. Comment out that code for debugging purposes and run the test again.

That worked. So, weirdly, I'm getting both - the raw session information is from my checkout (like ["eCartCheckoutForm_shipping_lastname"]=> string(6) "Lowery" ["eCartCheckoutForm_shipping_firstname"]=> string(6) "Joseph" [) but the email form is from (evidently) the previous order. (See attached files and screen grab). You can see the most recent order is #8303 ("muirhead_OrderID"]=> int(8303)), but the Order # on the email is 8302.

I've also attached my checkout_success.php page in hopes you can spot what's going wrong.

The page that actually sends the email is probably confirm.php. I'd like to see a copy of that as well as the page that is used to define the email body.

Files attached.

Yes, it is just a code ordering issue.

You send the email before you store the order in the database, and generate the email contents from the most recently inserted order, which would be the one before the current.

The solution is to move the email code on the confirm page below the database inserts on the confirm.php page.

So move lines 476-562 below the last database insert that currently ends on line 737

That did it! Thanks so much for your help.