close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Details not making it to Email

Thread began 11/12/2009 9:22 am by kelly291243 | Last modified 11/30/2009 6:49 pm by Eric Mittman | 2458 views | 12 replies |

kelly291243

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

Sign in to reply to this post

Eric Mittman

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?

Sign in to reply to this post

kelly291243

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

kelly291243

Hi

I am using eCart 4 ASP

I have attached the confirm .asp page

Many thanks

Kelly

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

kelly291243

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

Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

kelly291243

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 %>

Sign in to reply to this post

kelly291243

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

<%=Session("eCartCheckoutForm_exp_month")%>

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...