Price List Data Model
The new tables introduced by price lists allow for several approaches to maintaining prices for SKUs in a Broadleaf implementation.
BLC_SKU_PRICE_DATA and BLC_SKU_BNDL_ITM_PRC_DATA support the need to explicitly define a price for a product in the context of a price list.
BLC_PRICE_MODIFIER allows you to define rules and formulas to modify prices. For example, you could provide a pricelist to customers that provided 20% off the base price for items in a selected category.
Tables
| Table | Related Entity | Description |
|---|---|---|
BLC_PRICE_LIST |
PriceList | Primary entity representing a price list. |
BLC_SKU_PRICE_DATA |
SkuPriceData | Supports overriding the price and availability data for a SKU |
BLC_SKU_BNDL_ITM_PRC_DATA |
SkuBundleItemPriceData | Supports overriding the price and availability data for a bundle item |
BLC_PRICE_ADJUSTMENT |
PriceAdjustment | Used to override the adjusted price for a charge related to a product option |
BLC_RULE_MAP |
n/a | Join table between Price List and it's rules. |
BLC_PL_CRITERIA_RULE |
PriceListRuleCriteria | Contains rule data for when this price list would be active |
BLC_PRICE_MODIFIER |
PriceModifier | Information to indicate how a price list modifies the price |