Details not making it to Email

Hi,

I have created a site using eCart and have Universal Email to creat to receipt. The UE receipt is sent when the confirm.asp page is submitted which then goes to the Checkout_success.asp page. All the relevant information carries accross to the success page but the emailed receipt does not contain the ORDER_ID or the Credit Card info.

I gave the following on the email receipt:

ORDER ID

<%=Session("ts08usa_OrderID")%>

CREDIT CARD No.

<% If Len(Session("eCartCheckoutForm_cc_number")) < 4 Then Response.Write(Session
("eCartCheckoutForm_cc_number")) Else Response.Write(Right(Session("eCartCheckoutForm_cc_number"),4)) End If %>



From what I can see the Order ID is created at the checkout success page and if so teh confirm page that sends the Universal Email will not have that orderID to give. The credit card number, however, is on the confirm page so I have no idea why that is not making it to the emailed receipt.

Hope you can help

Kelly

The order id should also be inserted into your db on the confirm page, you should take a look at the value on this page and try updating your email value to match.

Also for the credit cart the code is designed to only show the last 4 digits if a credit cart was entered. If you did not enter a credit cart it will not show the digits at all. What is the checkout you are using?

On the confirm.asp page under the server behavior 'eCart Store Summary in Database' the Order ID is being stored as ts08USA_OrderID, isn't that the same as <%=Session("ts08usa_OrderID")%> as used in Universal Email?

Also, the last 4 digits of the credit card are not appearing, it just shows up as xxxx xxxx xxxx

I will need to do some testing of this to determine what may be going on here. What is the checkout that you are working with? Also, if you can please post back and include a copy of your confirm page minus any of the sensitive details so that I can take a look at what you have.

Hi

I am using eCart 4 ASP

I have attached the confirm .asp page

Many thanks

Kelly

I did not see any attachment on your post, perhaps it was missed. Please try it again so I can take a look at what you have on this page.

Sorry, I tried to attahc the actual ASP file so was invalid. I have zipped the file and it is showing as attached this time

Thanks

Kelly

Kelly

Thanks for the file, I think I can spot the source of the issues you are experiencing.

First for the id that you are using in the order I think you are referencing the id that is inserted into the details table. Instead of using ts08usa_OrderID in the email you should try to use Session.SessionID like this:

Change line 79 from this:

79: MailBody = MailBody & Session("ts08usa_OrderID")

To this

79: MailBody = MailBody & cStr(Session.SessionID)

Then for the credit card number not showing I think this is because of the value that is being referenced. You are using the session value for this, but all of the other server behaviors on the page are using the posted values. To update this change line 265 like this:

265: If Len(Session("eCartCheckoutForm_cc_number")) < 4 Then Response.Write(Session("eCartCheckoutForm_cc_number")) Else Response.Write(Right(Session("eCartCheckoutForm_cc_number"),4)) End If

To this:

265: If Len(Request.Form("cc_number")) < 4 Then Response.Write(Request.Form("cc_number")) Else Response.Write(Right(Request.Form("cc_number"),4)) End If

Please give these updates a try and let us know how it works for you.

Thanks for the reply. I have made the changes but it is still not right. Teh credit card information is still not making it to the email and the OrderID number on email is now a nine digit number where it should be a four digit number:

Correct order ID as shown on confirm.asp and checkout_success.asp - 1440

Order ID shown on email - 960844696

Just to clarify, when I say Order Id I mean the Order number for each customer to refer to their particular order not the session ID.

The checkout success page correctly shows the Order ID and the Credit card details. The code I have for both of these on the checkout_success page is:

Order ID:
<%=Session("ts08usa_OrderID")%>


Credit Card Number:
<% If Len(Session("eCartCheckoutForm_cc_number")) < 4 Then Response.Write(Session("eCartCheckoutForm_cc_number")) Else Response.Write(Right(Session("eCartCheckoutForm_cc_number"),4)) End If %>

Further, the expiry date is making it perfectly correctly to the email, the code for the exiry date is:

<%=Session("eCartCheckoutForm_exp_month")%>