User Guide

Chapter 9164
Data Map Second Row (Destination DB field)
identifies the name of the database
destination field for a given shopping cart column when the cart is submitted to
your orders database. Values for this row will depend on your database schema,
but you will typically want to store the ProductID, quantity and price. There will
likely be several columns that are not submitted to a database destination such as a
name, since this could be looked up from the Product ID). For these columns,
enter "None".
Data Map Third Row (Column Key) Do not change this row. Provides keys for
required columns of the shopping cart. This allows the shopping cart code to track
required columns without having to know the column title or the relative column
position. As a result, you can name the cart columns anything you like and order
them however you want. The csv file contains entries for this row. Do not change
them. All columns beyond the required columns should be left blank. The non-
asterisked columns in the following table are required (although you can change
the column names). The asterisked columns are optional and will appear only if
you choose the CSV files that include the options for weight-based shipping
calculations and/or line-item discounts.
Weight-based shipping calculations columns are defined as follows:
Weight column that stores the product's weight in pounds.
Totalweight column that will multiply the Quantity column times the Weight
column.
Column Name Column Key
Quantity QUANTITY
Title PRODUCT
Price PRICE
Total TOTAL
Product ID ID
*Weight WEIGHT
*TotalWt TOTALWEIGHT
*Disc_Threshold DISC_THRESHOLD
*Disc_Weight DISC_WEIGHT
*Disc_Value DISC_VALUE
*Disc_Type DISC_TYPE
Remove REMOVE