Tiered and volume pricing data model
Key Takeaway
Tiers change a product's price only after their activated schedule is linked to the product's Price Book Entry by a PricebookEntryAdjustment record.
Tiered pricing gives buyers in a B2B Commerce store discounts for bulk purchases, based on how many items they buy. The data model builds it in layers. A Price Book Entry sets a product's list price in a Price Book. A Price Adjustment Schedule and its Price Adjustment Tiers then change that price at quantity thresholds.
Price Books set the list price
The base layer is the Price Book. A Price Book (Pricebook2) contains price definitions for a group of products. A Price Book Entry (PricebookEntry) is the association between one Pricebook2 record and one Product2 record. Its UnitPrice field, labeled "List Price", holds the price. You create one Price Book Entry for each price and currency combination for a product in a Price Book.
When you load price data, load a product's standard price before its custom prices. Pricebook2Id and Product2Id are required on a Price Book Entry. You can't change them in an update, so a wrong link means creating a new entry.
If UseStandardPrice is true on a Price Book Entry, UnitPrice is read-only. Its value matches the UnitPrice of the entry in the standard Price Book for the same product and currency. Entries in the standard Price Book must set UseStandardPrice to true.