CatalogProducts Table
The CatalogProducts table contains information about non-multilingual items in the catalog to which the table refers. There is one CatalogProducts table for each catalog in your system. The Catalog System creates this table when it creates the catalog. The table name has the format <CatalogName>_CatalogProducts.
The columns in this table are the default non-multilingual properties and the non-multilingual properties that you have defined for the items in the catalog. If you have defined multi-lingual properties, they are included in the <CatalogName>_<LanguageIdentifier>_Catalog Table.
The following table describes the default columns in the CatalogProducts table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
CategoryName |
nvarchar(128) |
yes |
The name of the category to which the catalog item belongs. |
IsSearchable |
bit |
yes |
Specifies whether the catalog item is searchable. |
cy_list_price |
money |
yes |
The list price of the catalog item. |
UseCategoryPricing |
bit |
yes |
Specifies if category pricing should be used for the catalog item. |
TimeStamp |
timestamp |
yes |
The timestamp on the catalog item. |
OriginalPrice |
money |
yes |
The original price of the catalog item. This is useful only if category pricing is enabled. |
i_ClassType |
int |
yes |
The class type of the catalog item. |
ParentOID |
int |
no |
The object ID (OID) of the parent catalog item. |
ProductID |
nvarchar(256) |
yes |
The ID of the catalog item. |
VariantID |
nvarchar(256) |
yes |
The variant ID of the variant. |
LastModified |
datetime |
no |
The date and time the catalog item was last modified. |
CatalogName |
nvarchar(85) |
no |
The name of the base catalog. This is a primary key. |
PrimaryParentCategory |
nvarchar(128) |
yes |
The name of the primary parent category for this catalog item. |
DynamicCategoryWhereClause |
nvarchar(512) |
yes |
Not used. |
ExportReady |
bit |
yes |
Specifies whether this catalog item should be exported. |
DefinitionName |
nvarchar(128) |
no |
The name of the definition used to create this catalog item. |
oid |
int |
no |
The object ID (OID) of the catalog item. This is a primary key. |