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. |