Checkout Wizard form variables not saved to database

8/19/2009 4:08 amkelly291243

Some of my variables set in the 'Store Cart Summary in Database' on the confirm.asp page are not being saved to the database. It appears that all the variables that are taken from the form on the checkout.asp page are being passed through to and displaying correctly on the confirm.asp page but not saving to the database when the customer confirms the order. I have checked the entries and they appear to be correct:

OrderID
OrderReferenceID <%=Session.SessionID%>
OrderVisitorID
OrderShipping <%=WA_eCart_GetShipping(ts08usa)%>
OrderTax <%=WA_eCart_GetTax(ts08usa)%>
OrderTotal <%=WA_eCart_GrandTotal(ts08usa)%>
OrderDate
OrderShipAddress1 <%=cStr(Request.Form("shipping_street1"))%>
OrderShipAddress2 <%=cStr(Request.Form("shipping_street2"))%>
OrderShipCity <%=cStr(Request.Form("shipping_city"))%>
OrderShipStateID <%=cStr(Request.Form("shipping_state_province"))%>
OrderShipZip <%=cStr(Request.Form("shipping_postcode"))%>
OrderShipCountryID <%=cStr(Request.Form("shipping_country"))%>
OrderStatus

Also, certain variables are not being sent on the email receipt which I have used Universal Email to do for me during the checkout wizard process. The variables not going to email are the Order Number and the credit card information. However, strangely, the shipping details not being saved to the database are making it to the email receipt.

Hope you can help

Kelly

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Checkout Wizard form variables not saved to database

8/19/2009 4:08 amkelly291243