SELECT * FROM CartItems WHERE CartIDReference = #USR_cartID# ORDER BY CartItemID

Sorry. Your credit card was declined.
insert into customers (FirstName,LastName,BillAddress,BillCity,BillState,BillCountry,BillZip,Phone,Email, shipfirstName,shipLastName,shipAddress,shipCity,shipState,shipCountry,shipZip) values('#firstName#','#lastName#','#address#','#city#','#state#','#country#','#zipCode#','#Phone#','#Email#','#USR_shipfirstName#','#USR_shipLastName#','#USR_shipAddress#','#USR_shipCity#','#USR_shipState#','#USR_shipCountry#','#USR_shipZip#') select max(customerID) as curr_customerID from customers insert into orders (CustomerID,thisfirstName,thislastName,thisAddress,thisCity,thisState,thisCountry,thisZip,ccname,ccnumber,ccexpmo,ccexpyr,TotalPrice,SH,SalesTax,GrandTotal,transaction_date) values(#form.customerID##get_key.customerID#,'#USR_shipfirstName#','#USR_shiplastName#','#USR_shipAddress#','#USR_shipCity#','#USR_shipState#','#USR_shipCountry#','#USR_shipZip#','','','','',#USR_orderTotal#,#USR_SH#,#USR_CPTAX#,#USR_CPAMT#,now()GetDate()) select max(orderID) as curr_orderID from orders SELECT * FROM CartItems WHERE CartIDReference = #USR_cartID# ORDER BY CartItemID delete FROM CartItems WHERE CartIDReference = #USR_cartID# insert into orderDetails values(#orderID#,#currentrow#,'#itemcode#',#quantity#,#lockPrice#,#totalPrice#)
Thank you!

Your order has been completed. An order confirmation email has been sent to your email address.

   
Billing Infomation
#FirstName# #LastName#
#address#
#city# #state#, #zipCode#
#country#
Shipping Infomation
#USR_shipFirstname# #USR_shipLastname#
#USR_shipAddress#
#USR_shipCity# #USR_shipState#, #USR_shipZip#
#USR_shipcountry#
#USR_ShipPhone#

Order Information

Order Number: #OrderID#

select * from items where itemcode='#itemcode#'
Item
Unit Price
Qty
Total Price
#get_desc.itemname#
Size: #itemsize#    #itemColor#
#dollarFormat(lockPrice)#
#quantity#
#dollarFOrmat(totalprice)#
       
 
Subtotal:
#dollarFormat(USR_orderTotal)#
 
Shipping:
#dollarFormat(USR_sh)#
 
Tax:
#dollarFormat(USR_CPTAX)#
 
Total:
#dollarFormat(USR_grandTotal)#

 

Home Page

*orders may not appear immediately in the "order history" section of "my account."

The following order was placed through your shopping cart: ------------------------ Invoice No: #orderID# System Order ID: #MTSEQ# Customer ID: #left(MBSEQ,8)# Name : #form.LastName#, #form.FirstName# Billing Address : #form.Address# #form.City#, #form.State# #form.zipCode# #country# Email : #form.Email# Shipping Address: #USR_shipFirstName# #USR_shipLastName# #form.USR_shipAddress# #form.USR_shipCity#, #form.USR_shipState# #form.USR_shipZip# #USR_shipcountry# #form.USR_ShipPhone# Customer is tax exempted. Tax exemption certificate no: #form.TaxExemptCert# ------------------------ Products Purchased: #CurrentRow# select itemname from items where itemcode = '#ItemCode#' Item Name: #get_item_name.ItemName# (#ItemCode#) Item Size: #itemsize# #itemColor# Item Qty: #Quantity# Line Total: #DollarFormat(TotalPrice)# ----------------------- ------------------------------------------- Sub total: #DollarFormat(form.USR_orderTotal)# S/H : #DollarFormat(USR_SH)# Sales Tax: #DollarFormat(USR_CPTAX)# ----------------------- Grand Tot: #DollarFormat(USR_grandTotal)# Thank you for your purchase. Below is your invoice. ------------------------ Invoice No: #orderID# System Order ID: #MTSEQ# Customer ID: #left(MBSEQ,8)# Name : #form.LastName#, #form.FirstName# Billing Address : #form.Address# #form.City#, #form.State# #form.zipCode# #country# Email : #form.Email# Shipping Address: #USR_shipFirstName# #USR_shipLastName# #form.USR_shipAddress# #form.USR_shipCity#, #form.USR_shipState# #form.USR_shipZip# #USR_shipcountry# Customer is tax exempted. Tax exemption certificate no: #form.TaxExemptCert# ------------------------ Products Purchased: #CurrentRow# select itemname from items where itemcode = '#ItemCode#' Item Name: #get_item_name.ItemName# (#ItemCode#) Item Size: #itemsize# #itemColor# Item Qty: #Quantity# Line Total: #DollarFormat(TotalPrice)# ----------------------- ------------------------------------------- Sub total: #DollarFormat(form.USR_orderTotal)# S/H : #DollarFormat(USR_SH)# Sales Tax: #DollarFormat(USR_CPTAX)# ----------------------- Grand Tot: #DollarFormat(USR_grandTotal)#