Catalogid
A unique number assigned to this product. It is an auto number field assigned when the product is added
Product Name
Item name that appears in the cart. This is a required field.
Product Description
The description of the item. It can be any length and can include html tags such as <b> <i> <font>
Product Selling Price
The price you are charging for this item.
Product Categories
Select one or more categories the product belongs in. To select more than one category, hold down the CTRL key when making a selection.
Product Code.
Code you wish to further identify with this product such as the UPC code or SKU.
Product Sub Categories
Select one or more subcategories the product belongs in. To select more than one category, hold down the CTRL key when making a selection.
Product Extended Description Page
Filename or ASP page. VP-ASP will automatically generate a hyperlink back to this page when the product is displayed. It can be a full URL (http://www…)
Product Feature Numbers
This is normally for display only. It is the features for this product from the prodfeatures table. A list of available features is shown in the form. You can manually enter or click on the features in the form. Note you must clear the field before clicking to change.
Product Features
Select one or more features for the product. To select more than one category, hold down the CTRL key when making a selection.
Product Image
Thumbnail image of this product. May include full URL or folder such as ..\images\thumbnail.gif
Product Order Button Image
If you are using individual order buttons, you can replace the normal default button on a product by product basis. This is the name of an image file. May include full URL or folder such as ..\images\button.gif  
Product Stock Available
Stock level (a number). Only used if VP-ASP stock control has been activated.
Product Weight
Number. Only used if you have selected a shipping calculation based on weight.
Product Manufacturer
Can be anything. Unused by VP-ASP.
Product Supplier
Leave blank if you are not using VP-ASP supplier reports. Otherwise it is the supplier number from the suppliers table.
Product Cross Selling Items
A list of associated products. This is a list of catalogids (unique number assigned to a product). For example 99, 123,2
Product Date Available
Enter the date available. This is unused by VP-ASP.
Product Other1 field (pother1)
Unused by VP-ASP. You may use this field in different routines. If you need additional fields in the products table to be used to generate select lists, use the “featureother” field in the prodfeatures table. For example, to create an additional select list using the pother1 field in the products table, set the following in the prodfeatures table.

Featuretype=”selectlist”
Featurecaption=”Caption for this feature”
Featureother=”Pother1” 

Product  Other2 field (pother2)
Unused by VP-ASP. You may use this field in different routines.
Product Other3 field (pother3)
Unused by VP-ASP. You may use this field in different routines. 
Product OTher4 field (pother4)
Unused by VP-ASP. You may use this field in different routines.  
Product Other5 field (pother5)
Unused by VP-ASP. You may use this field in different routines. 
Product Retail Price
If you want VP-ASP to automatically display a price below the normal price, put a value here. Otherwise it is unused by VP-ASP.
Product Special Offer
If something is in this field, the normal VP-ASP sort, displays these products first with the information supplied. Otherwise it is unused.
Product Allow User Text
Obsolete. For compatibility only.
Keywords
Keywords to be used for searching.
Product Template File
Using the Option Package extended description, you can supply a unique template per product. The default is tmp_product.htm
Product More Information
Used only by the Option Package to generate the extended description of the product. There is no limit to the size.
Product Large Image
Used only by the Option Package to generate the extended description page. A larger image of the product.
Product Selection List
Used when features are very specific to the product. A list in the form of Small, Large [2.00], Very Large [3.00]

Product Minimum Quantity
Leave empty unless you want VP-ASP to generate a drop down list for quantity using this number as a base. For example if you put 10 here, then the customer can only buy in multiples of 10. 10,20,30 … Alternatively this now means that the customer cannot select a quantity less than this number.
Product Maximum Quantity
Leave empty unless you want VP-ASP to limit the number of this product that can be ordered. The customer may choose multiple of these products.
Product Hide
0 or false = do not hide the product
1 or true = hide the product from displaying
Product Discount group
You can group products together to form a group where quantity discount will apply. The group name must match a group in the quantity prices table. When a customer purchases products in the same group, then the discount is applied to all the products based on the rules you have created.
Product Language
This name must match the language currently being used. When a language switch occurs, VP-ASP will display products only matching that language. Language switching is part of the VP-ASP Option Package. CDN, the part after _ as in shop$language_cdn is the language code in this instance.
Product Attachment
VP-ASP can automatically add attachments at the completion of the order. This is the location of the file. It cannot be a URL. It must be a full disk address in form c:\mydirectory\myfile.xxx
Product Download
VP-ASP can automatically generate download hyperlinks at the end of the order. This is the location of the file. It can be any valid URL or filename.
Product Match Customer
Allows customers authorized to view this product if wording entered matches the wording in productgroup in customer table. If blank all customers such as retail or wholesale can view.  
Product Match
To restrict display of specific products that this field matches xproductmatch in shop$config.asp. Allows different sub-directories setup as unique sites which still share the same database.
Product Points
Used only if points systems is enabled. The number of points customer receives if they purchase the product.
Product Redeem Points
Currently unused by VP-ASP. Routines can be added to shoppointsdb.asp for rewards.
Product Price2 field
Unused by VP-ASP. You may use this field in different routines.
Product Price3 field
Unused by VP-ASP. You may use this field in different routines.
Recurring Billing price
The amount to be billed on each billing interval
Recurring Billing Installments
The number of installments.
Recurring Billing Installment Type
The type of installment period. weekly, Monthly, Yearly, Daily
Recurring Billing Installment Interval
A number such that says how often to bill. For example if one is set and the installment type is monthly, then a bill is sent once per month.
Product Admin User ID
The administrative user assigned to the product. Leave blank and VP-ASP will automatically add the current logged in administrator.