wws_items
| West Wind Web Store |
| wws_items
|
The inventory table holds all product information as well as some processing information such as discounts and commission values.
| Field | Description |
|---|---|
 categories | Carriage Return delimited list of categories this item fits into. Must match category entries in the Lookups table. text |
| commission | The percentage of the item's actual sale price paid to the vendor. decimal(20) |
| 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. text |
| 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. text |
| keywords | Carriage return delimited list of keywords for this item. text |
| 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. char(30) |
| 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. text |
| regpass | Registration password. Printed out on invoices. text |
| 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 text |
| sku | Sku for the item. This is the primary identifier used for this item besides PK. char(15) |
| sortorder | A numeric value to describe the sort order for the item. Higher number means it displays first in category lists. numeric(4) |
| special | Special price for the item if on sale. (not used) numeric(11,2) |
| 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. text |
| weight | Weight for physical items numeric(11,2) |
| xml | XML Properties field. text |