Purchase Information
SELECT a.*, c.DiscountType, c.DiscountAmount, c.DiscountEndDate, c.DiscountStartDate, (select count(*) from OptionName where OptionName.ProductID = a.ProductID) as optionCount, UnitPrice, WholesalePrice FROM (Products a LEFT OUTER JOIN Discounts c ON (a.ProductID = c.ProductID)) LEFT JOIN ProductsPrice e ON a.productID = e.ProductID WHERE a.ProductID = #varBasketProductID# AND (#varBasketQuantity# >= e.QtyBeginRange and #varBasketQuantity# <= e.QtyEndRange) "#tablebgColor#""#altRowBgColor#"> Item / Product Name Options Quantity Price Subtotal #htmleditformat(productname)# New! SKU: #productpartno# Mfg. Part No.: #vendorpartno# SELECT a.name, a.nameid, a.required FROM OptionName a INNER JOIN OptionValue b ON (a.nameID = b.nameID) and (a.productid = b.productid) WHERE a.productid = #ProductAttributes.productID# GROUP BY a.name, a.nameid, a.required #selectedOptionValue# - Add #dollarFormat(selectedOptions_addCost)#   #varBasketQuantity# #dollarFormat(UnitPrice)# #dollarFormat(varUnitPrice)# #addText# #dollarFormat(UnitPrice)# #dollarFormat(WholesalePrice)# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - (unitprice * memberDiscountAmount))# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - memberDiscountAmount)# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - (unitprice * DiscountAmount))# #addText# #dollarFormat(UnitPrice)# #dollarFormat(unitprice - DiscountAmount)# #addText# #dollarFormat(UnitPrice)# #addText# #dollarFormat(varUnitPrice * varBasketQuantity)# Total Weight: #form.totalweight# #scale# Total Qty: #form.totalQty# Subtotal: #dollarformat(varUnitPrice)# Please select a shipping method.   Ship Via Cost checkedchecked> checkedchecked> #provider# - #shipViaDesc# #dollarFormat(calcShipCost)#   Ship Via Cost checked> #element_provider# - #element_shipviadesc#      Certified or Registered Mail: Certified Mail (Add $2.30) Certified Mail + Return Receipt (Add $4.05) Registered Mail (Add $7.50) Registered Mail + Return Receipt (Add $9.25) #dollarFormat(element_shipcost)# Handling: $ Total Cost: (not including sales tax if any) $
Note: Fields with an * is required.
Credit Card Information Credit Card Information
*Credit Card Type:	checked>  checked>  checked>  checked>
*Credit Card No.:
*Exp. Date:	selected> selected>01 selected>02 selected>03 selected>04 selected>05 selected>06 selected>07 selected>08 selected>09 selected>10 selected>11 selected>12 / selected> selected> #dateformat(dateadd("yyyy", (index - 1), now()), "yyyy")#
Billing Information
*First Name:
*Last Name:
Company Name:
Military Unit:
*Telephone:
Fax:
*E-Mail:
Are you able to receive HTML formatted E-Mail?: Yes No Yes No
Billing Address
*Address:
*City:
*Country:
*US State (If country is USA):	*Required if Country is USA*
*Province:	*Required if Country is NOT the USA*
*Zip/Postal Code:	*Required if Country is USA*
Remember Me
Remember my billing address information for future purchases. Yes No Yes No
Email Offers
Get exclusive time and money-saving offers from #companyName#? Yes No Yes No