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