INFO I want to add new form fields to the checkout pages, how would I do that?

Article # 5020

The information in this article applies to this particular SalesCart Product(s): 
STD, PRO, SQL


SYMPTOMS
I would like to add new fields to the checkout pages so that I can collect more information from my visitors. How can I do this?

CAUSE
This is a database customization. In addition you will have to modify the SQL statement on two pages. Please follow the instructions below. NOTE: This tutorial is only to inform you that it is in fact possible to modify the cart. Proceed with caution and always Backup your checkoutpage before proceeding. We will not provide support for any modified checkout pages, instead we will restore the page to their original state if we are asked to.

RESOLUTION

1. Open the Shop Database in the fpdb folder

2. Go to the customer table and add two new fields to it. Call the first field keycode and the second one contactsource.

Note: The field names are case sensitive!

4. Open the details1.asp in the cgi-bin and add the two text box fields to the form.

5. Change the SQL statement on the next page. The newly added scripting will gather the data from the details1.asp page and send it to the database. This is the code, the red part is the additional part!

order = Session("orderid")

subweight = FGetVar("subweight",1,"n")
subsize = FGetVar("subsize",1,"n")
subquantity = FGetVar("subquantity",1,"n")
subtotal= FGetVar("subtotal",1,"n")
subship= FGetVar("subship",1,"n")
subhand= FGetVar("subhand",1,"n")

Keycode = FGetVar("Keycode",1,"n")
Contactsource = FGetVar("Contactsource",1,"n")

6. Add the new fields to the SQL statement. Notice that if its a text field, then the field must be surrounded by ' single quotes.

'WRITE STUFF to Database
Dim objSimpleAdo, rstRS, SQLStmt

SQLStmt = "UPDATE DISTINCTROW [customer] "
SQLStmt = SQLStmt & "SET shipfname='" & shipfname & "', "

SQLStmt = SQLStmt & "Keycode='" & Keycode & "', "
SQLStmt = SQLStmt & "Contactsource='" & Contactsource & "', "


SQLStmt = SQLStmt & "password='" & password & "', "
SQLStmt = SQLStmt & "shiplname='" & shiplname & "', "
SQLStmt = SQLStmt & "shipemail='" & shipemail & "', "
SQLStmt = SQLStmt & "shipcompany='" & shipcompany & "', "
SQLStmt = SQLStmt & "shipaddress='" & shipaddress & "', "
SQLStmt = SQLStmt & "shipcity='" & shipcity & "', "
SQLStmt = SQLStmt & "shipstate='" & shipstate & "', "
SQLStmt = SQLStmt & "shipcounty='" & shipcounty & "', "
SQLStmt = SQLStmt & "shipcountry='" & shipcountry & "', "
SQLStmt = SQLStmt & "shipzip='" & shipzip & "', "
SQLStmt = SQLStmt & "shipphone='" & shipphone & "', "
SQLStmt = SQLStmt & "mailinglist='" & mailinglist & "', "
SQLStmt = SQLStmt & "giftmessage='" & giftmessage & "', "
SQLStmt = SQLStmt & "shipfax='" & shipfax & "' "
SQLStmt = SQLStmt & "WHERE Orderid=" & order & ";"

You are all done. Now test the the pages but placing and order and checking out. Make sure that the data is stored in the database by checking it.

Good luck, with the customization!

SUMMARY
Note: Before proceeding make a backup copy of your Shop Database as well as your checkout pages.

STATUS
Closed

REFERENCE
none


Additional Query Words: customize checkout pages, adding new fields to the database, form fields, new form fields, additional form fields

Active/inactive: Active
Author:
 Will Sani
Date:
 02/06/02