Price Lookup Example

The following scenario illustrates the lookup of an effective sales price for a certain set and configuration of price books associated with a site.

The following price books are defined and associated with the same site:

Price Book ID Locale Active Currency
A ListPrices de_DE yes EUR
B StorePrices de_DE yes EUR
C AmazonPrices de_DE yes EUR
D ListPrices de_AT yes EUR
E StorePrices de_AT yes EUR
F AmazonPrices de_AT yes, Based on AllAffiliates EUR
G AllAffiliates de_AT yes EUR

Given these example price books, with these storefront entry points, the price lookup would include these price books:

Storefront Locale Price Books
Site de_DE A and B
Entering via Amazon de_DE A, B, and C
Site de_AT D and E
Entering via Amazon de_AT D, E, F, and G (G is the parent price book of F)

Customer group discount

The List Price book for the product is defined with the price 10.99 for a quantity of one. The price table for the product in the List price book is defined with volume-based discounts (and is in effect) as follows:

Quantity Price Note
2 9.49 Pay 9.49 each if you buy two items.
5 8.49 Pay 8.49 each if you buy five items.

There is a Sale price book defined (and in effect) that contains a price table for the product listing volume-based discounts as follows (and no price defined for a quantity of one):

Quantity Price Note
2 8.49 Pay 8.49 each if you buy two items.
5 7.49 Pay 7.49 each if you buy five items.

When a customer orders, the prices appear according to the following rules:

The List price book defines the price for the product as $10.99 for a quantity of one. The Sale price book is defined with volume-based discounts (and is in effect) as follows:

Quantity Price Note
1 9.99 Pay 9.99 for one item.
2 9.49 Pay 9.49 each if you buy two items.
5 8.49 Pay 8.49 each if you buy five items.

There is a List price book defined (and in effect) that contains a price table for the product that lists volume-based discounts as follows:

Quantity Price Note
2 8.49 Pay 8.49 each if you buy two items.
5 7.49 Pay 7.49 each if you buy five items.

There is a Based On price book defined (and in effect) that contains a price table for the product that lists volume-based discounts as follows:

Quantity Price Note
2 7.49 Pay 7.49 each if you buy two items.
5 6.49 Pay 6.49 each if you buy five items.

When a customer orders, the prices appear according to the following:

Related Links

Price Books for Developers

X Privacy Update: We use cookies to make interactions with our websites and services easy and meaningful, to better understand how they are used and to tailor advertising. By continuing to use this site you are giving us your consent to do this.