Price lists

A price list is a list of catalog entries with associated prices in one or more currencies. WebSphere Commerce uses price lists in price rules to set prices for catalog entries on your storefront. When you manage your price lists with the Catalog Filter and Pricing tool in Management Center, you can take advantage of many features to implement flexible pricing and simplify maintenance.

You can view and manage a price list in a single scrollable page, as shown here:

A price list in the Catalog Filter and Pricing tool

WebSphere Commerce provides two default price lists, the Offer Price list and the List Price list. You can use the default price lists to maintain prices for your catalog. If needed, you can create and manage any additional price lists that make sense for your business. For example:

If your business uses cost-based pricing, you could create a "Cost" price list.
To track distribution costs for specific catalog entries, you could create a "Distribution Cost" price list.
For a B2B direct store, you could create a "Contract A Tire Prices" price list that contains tire prices that you negotiate with specific business customer.

Then, by creating a price rule, you can use the price lists for storefront pricing, without involving IT.

Here are some additional capabilities of the Catalog Filter and Pricing tool that can help make price management easier and more flexible:

Export a price list to a spreadsheet for more convenient editing, and then upload the revised price list to Management Center.
Upload new price lists in CSV (comma-separated value) format files so that they are available for storefront pricing.
You can also have an administrator use the Data Load utility to load price lists, which you can then manage in the Catalog Filter and Pricing tool.
Create price rules that use price lists for pricing data. Then, display the price list price, or an adjusted price, on your storefront. Here are a few examples of how price rules can use price lists to give you the pricing flexibility you need:
- Mark price list prices up or down by a percentage.
- Perform simple and complex pricing calculations using any price list for data.
- Use more than one price list at the same time to set pricing for a store or a contract, depending on certain conditions. For example, a price rule could use "Price List A" to set furniture prices and "Price List B" to set prices for everything else in the catalog.
- Add prices from two price lists together. For example, a price rule can take the "Cost" price list price, add margins, and then add the "Distribution Cost" price list price.
For more information about price rule capabilities, see Price rules: An overview.

If your price list is large and therefore difficult to manage using the Catalog Filter and Pricing tool, consider:

Maintaining your price list in a spreadsheet and then uploading changes to Management Center
Using the Data Load utility to load pricing data

Default price lists and how they are used on WebSphere Commerce starter stores

To understand the default price lists, you should be familiar with the terminology used in WebSphere Commerce to define prices that relate to price lists:

Offer price: The offer price is the price at which a store offers catalog entries for purchase. The offer price is the actual price customers must pay, before taxes, discounts, and shipping.
List price: The list price is intended for catalog display purposes only; it is not typically used as the actual price customers must pay. A store might display a list price above an offer price to show customers that they are getting a better deal with the offer price. One common use of the list price is to display the MSRP (manufacturer's suggested retail price). Your site can choose not to use a list price at all.

When you publish a starter store after you enable WebSphere Commerce Version 7 Feature Pack 2, two default price lists are created:

Offer Price list: This price list contains offer prices for all catalog entries in the master catalog, in US dollars.
List Price list: This price list contains list prices for all catalog entries in the master catalog, in US dollars.

You can modify these default price lists for your own catalog and then use them for pricing on your own store.

Tip: To identify the two default price lists for your starter store, read the price list description. The description indicates whether the list is the Offer Price or the List Price list. For an example, refer to the previous screen capture.

When you publish a WebSphere Commerce starter store after you enable WebSphere Commerce Version 7, Feature Pack 2, the starter store uses two default price rules for pricing. These simple price rules pull prices from the default Offer Price and List Price lists and display them on the storefront. The following illustration shows the product display page from the Madisons starter store for a Hermitage Fit and Flare Dress:

Offer price and list price on the storefront

1 This is the list price. A default price rule called "List price rule" pulls the price from the default List Price list for display on the page.
2 This is the offer price. A default price rule called "Offer price rule" pulls the price from the default Offer Price list for display on the page.

If your store displays prices from the default Offer Price list and List Price list without adjusting them, you do not need to modify the default price rules at all. These price rules are simply a means to get your price list prices on the storefront. If this default pricing configuration does not meet your needs, you can:

Modify the two default price rules. For example, you can add instructions to the price rule to adjust the price list prices, or use different price lists.
Create new price rules and assign them to store or customer contracts so that the new price rule is used to set pricing on the storefront.

Migration considerations for existing WebSphere Commerce customers

If your store already used the list price before Feature Pack 2 for WebSphere Commerce Version 7 is installed, consider migrating your list price data. If you do not migrate, your list price data remains stored in a database table that the Catalog Filter and Pricing tool cannot access. If you do migrate, you can:

Use the Catalog Filter and Pricing tool to manage your List Price list. You can continue to use the Catalogs tool as well.
Create price rules that are based on the List Price list. By creating these rules, you can dynamically adjust list prices for a specific store or contract without editing the price list directly.

If these options are not important to you, then you do not need to migrate. In this case, you can continue managing your list price as you do today. For more information, see Deciding whether to migrate list price data.

Limitations

Workspaces:
The Catalog Filter and Pricing tool does not support the workspace feature. When workspaces are enabled and you are working with tasks or task groups, the Catalog Filter and Pricing tool is not available. The tool is available when you are working on approved content.