Documentation Home
Database Model Catalog Product
This version of the framework is no longer supported. View the latest documentation.

Catalog Product

Detailed ERD

Catalog Product Detail

Tables

Table Related Entity Description
BLC_PRODUCT Product A product is a general description of an item that can be sold (for example: a hat). Products are not sold or added to a cart.
BLC_PRODUCT_ATTRIBUTE ProductAttribute Defines attributes for a product.
BLC_SKU_XREF - Cross reference table that points to the skus for the product.
BLC_PRODUCT_BUNDLE ProductBundle Represents the product being sold in a bundle.
BLC_SKU_OPTION_VALUE_XREF - Represents the cross reference between sku and a product option value.
BLC_PRODUCT_OPTION_VALUE ProductOptionValue Defines the value of a Product Option.
BLC_PRODUCT_OPTION ProductOption Designates a Product Option.
BLC_PRODUCT_CROSS_SALE RelatedProduct Represents the products in the category.
BLC_PRODUCT_UP_SALE RelatedProduct Represents the products in the category.
BLC_PRODUCT_FEATURED PromotableProduct Represents the products in the category.
Table Related Entity Description
BLC_CATEGORY Category Represents a category.
BLC_SKU Sku A SKU is a specific item that can be sold including any specific attributes of the item such as color or size.