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.

A Sale price book contains a price table for the product listing volume-based discounts as follows, with 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:

For a quantity of one, the price from the List price book automatically appears as the best price. This price is used because there isn't another price defined for a quantity of one.
For a quantity of one, the additional volume-based discount price information shown is taken from the Sale price book price table. This discount price information is used because it's the best price for the volume-based discount.
For a quantity of two or more, the best price is delivered from the Sale price book price table, because those prices are the cheapest.
Based On price book contains the best price.

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:

For a quantity of one, the best price appears as $9.99 because it is the cheapest price defined for a quantity of one.
For a quantity of one, the additional volume-based discount information shown comes from the Based On price book because it is the lowest price found.
For a quantity of greater than one, the best price comes from the Based On price book because it has the lowest prices.
For a quantity of greater than one, the additional volume-based discount information shown comes from the Based On price book, because it contains the lowest prices.