Order info not sent to merchant after PayPal payment

My client is getting a partial email after PayPal processes the order. She's getting the subtotal, shipping and total figures as well as the billing info, but the order details are not included. I've tried to locate the email doc that's sent to bind in additional details, but can't figure out which it is. What file should I look for and how do I proceed?

Okay, I think I found it in the webassist/email folder. I have muirhead_receipt.php but also muirhead_receipt 2.php and muirhead_receipt2.php, all with the same date. How do I tell which one is being used?

I've attached muirhead_receipt2.php which I think is the most likely.

And another issue... I just noticed that while it is including my "West of Mississippi" added charge in the total, it's not breaking it out on the cart. I can see where I would add that PHP statement on the checkout page, below Shipping and before Tax, but not sure of the syntax. Here's the rule from the eCart page (muirhead_PHP.php):

//eCart Rule
function WAEC_muirhead_WestoftheMississippi()  {
  $totalShipping = 0;
  if (true && (((isset($_SESSION['toTheWest'])?$_SESSION['toTheWest']:"") == "1"))) {
    $totalShipping += floatVal("3.50");//Result
  }
  return WA_eCart_FormatNumber($totalShipping, $this->ForceDecimalsC, $this->DecimalPlacesC);
}
//eCart Rule

Thanks - Joe

It looks like it would work to me. You are getting the information from the database and not from the cart directly. So it would only work if the information was saved correctly in the database before the email was generated... maybe it is in the wrong order on the confirm page and the order details haven't been stored when the email is sent?

Also since it is in the database, it probably doesn't know which shipping rule was used and it only stores the shipping total in the database. If you want to include all of that then it might make sense to get the information from the cart instead of the database when you send the email. The advantage of the email you have from the database is that it could also be used to re-send the receipt at any time from the admin back end. That of course wouldn't work if the email was built directly from the cart.

I'm not clear on the sequence I think - when is the email sent? I don't even see a reference to it on my checkout, checkout_success, confirm or pp_confirm pages (I've attached them for you to take a look at). Or is it somewhere else?

It is on the pp_confirm.php page below the store cart details in database, which is the correct location, so that wasn't the issue.

It looks like the email body is coming from: webassist/email/muirhead_receipt.php

Are you sure the database is being updated properly? Does the order_details table have the correct value in the product_id column and order_id column?

Think I figured out the problem - the details were being stored in the wrong table (orderdetails and not order_details). I'm recreating the Store Details in Database and after assigning values to all the db fields, get an error: You must set the value of the column specified as the Order ID. But I have. I have it as:<?php echo $_SESSION['muirhead_OrderID']; ?>.

I can't update the server behavior until I get past this error. What do I do?

You probably have the wrong column specified for the Order ID in the Order ID dropdown above the column bindings.

Doh! You're right.

Going back to the "West of the Mississippi" charge again. I need that to appear in the cart display in a couple places (the confirm page and the reciept). It's one of the shipping formulas - how do I break it out to show it if applied? Right now, it is included in the charge with no indication of what it is.

You will probably have to add a field for it into the orders table and then store it separately so you can display it properly from the database.