Product Catalog Database Tables

The Product Catalog tables are found in the database referred to by the Product Catalog site resource.

The following table describes each of the tables in a product catalog database.

Table Name Description
CatalogAttributes Contains a row for each user defined catalog property definition, describing the attributes of the property.
CatalogDefinitions Contains a row for each category or product definition.
CatalogDefinitionProperties Relates category and product definitions to the properties they contain.
CatalogGlobal Contains a row for each product catalog.
CatalogUsedDefinitions Records which product or category definitions are in use by one of more catalogs.
CatalogEnumValues Defines the legal values for the catalog enumeration data type properties.
CatalogStatus Records the status of import and export operations.
CatalogCustomCatalogs Contains a row for each custom catalog.
CatalogCustomPrices Records the custom price rules applied to categories in custom catalogs.
catalogname_ProductsComplete Contains all the products, product variants, and categories for the catalog named catalogname.
catalogname_Relationships Contains all the relationships between products and/or categories for the catalog named catalogname.
catalogname_Hierarchy Records the category hierarchy (parent-child relationships) for the catalog named catalogname.
CatalogSet_Catalogs Defines the mapping of catalogs to catalog sets.
CatalogSet_Info Contains a row for each catalog set with details about the catalog set.
CatalogToVendorAssociation Contains details about a vendor associated with each catalog.


All rights reserved.