wws_items - West Wind Web Store .NET

wws_items

The inventory table holds all product information as well as some processing information such as discounts and commission values.

Table Indexes

descript
Index Key: descript
pk
Index Key: pk
PK_wws_items
Index Key: pk
sku
Index Key: sku

Table Fields

Field	Description
Abstract	Contains an abstract description for this item. This is used for various item category list displays if filled. This field can be autofilled from the Long Description via the busItem.AutoFillAbstract() method. varchar(2048)
categories	Carriage Return delimited list of categories this item fits into. Must match category entries in the Lookups table. varchar(1024)
commission	The percentage of the item's actual sale price paid to the vendor. decimal(8,4)
cost	Cost for the item. numeric(11,2)
descript	One line description used for the item header char(50)
emailto	CC for email to be sent. varchar(128)
expected	Date when the item is expected in if OnOrder. datetime
image	Name of an image file. Image files are considered to be stored in the ItemImages directory of the main Web Store root. varchar(128)
keywords	Carriage return delimited list of keywords for this item. varchar(512)
ldescript	Long detailed description. This description can contain HTML. Any linebreaks are automatically expanded into HTML breaks (<br> and <p>) text
mfr	The manufacturer or vendor of the item. varchar(50)
noweb	If set this item doesn't display on the Web. bit
onorder	Number of items on order. numeric(11,2)
physical	Flag that determines whether the item tracks inventory. bit
pk	Primary Key int
price	Price for the item numeric(11,2)
redirect	If set the item page redirects to this URL. varchar(255)
regauto	If true allows the item to be automatically be confirmed electronically without manual checks. Use this flag on any non-upgrade electronic items that can be immediately downloaded once the order is confirmed. Set to false on all items that require physical validation such as upgrades and anything that needs to be sent physically. Defaults to false. bit
regpass	Registration password. Printed out on invoices. varchar(50)
regtext	Registration text used to send email confirmations. Usually contains download link and password. text
savemail	Email address of a vendor who's to receive an XML email with the sold item details varchar(128)
sku	Sku for the item. This is the primary identifier used for this item besides PK. char(25)
sortorder	A numeric value to describe the sort order for the item. Higher number means it displays first in category lists. int
special	If set to non-zero means this item is included in the specials list. The number determines the sort order - the higher the more priority in the list. int
specialhd	Header text used for the special item in the special item list. varchar(128)
specialprc	Special price for the item if on sale. (not used) numeric(11,2)
specialtext	The description used for this special item. text
stock	Stock qty for physical items. numeric(11,2)
storepk	not used int
timestamp_column	timestamp
type	Type of item - used for custom subtypes like Colors, Sizes etc. The type determines what INPUT fields are saved from the HTML form in the XML Properties. char(5)
url	The URL for the product page for more information. varchar(255)
weight	Weight for physical items numeric(11,2)
xml	XML Properties field. text