Download PDF
Download page Creating a Price List.
Creating a Price List
You can create a price list at any time; however, it is most efficient to create a price list before creating products to easily associate the products with the price list.
To create a price list
- Go to ADMIN SETUP > Pricing Administration > Price Lists. The Price Lists page is displayed.
- Click Add New. The New Price List pop-up is displayed.
Enter the following details:
Field Description Price List Name Enter the name for the price list. This is a mandatory field. Active Turn this field on to make the price list active. Currency Enter to search and select the currency for the price list. By default, the currency of the org is selected. This is a mandatory field.
Account Search and select an account to be associated with the price list. Description Enter a description for the price list. Effective Date Select a date from when the price list must be effective. Expiration Date Select a date on which the price list must be expired or made inactive. Price List Type Select the type of price list from the drop-down. Supported values are:
- Standard: Select standard price list if the quote derives its pricing from price list and its related price list items configured in CPQ.
- Contract: Select contract price list if the quote derives its pricing from an agreement. You must also associate a contract number when you select this price list.
Contract Number Enter a contract number to which you want to associate this price list. This enables contract pricing in CPQ. Disable based on currency Adjustment Turn this setting on to disable currency conversion on the price list. By default, this setting is turned off.
When this setting is enabled, CPQ ignores the currency conversion. For example, the currency of the master price list is USD [100 USD] and the child price list is based on master PL and the currency is GBP. When this setting is enabled, CPQ displays 100 GBP on the cart.
Based on Price List Based on Price List Name Search and select the name of an existing price list depending on which the new price list is created.
This field is useful in scenarios such as your organization wants to sell the same products in different currencies or in the same currency with some discount.
For example, your organization sells products in the United States in the USD currency. You have created a price list called USD Price List. For all products, you have created the required price list items, which are associated with USD Price List. Now you want to sell the same products in Great Britain in the GBP currency. You can create another price list with the following details:
- PriceList Name: GBP Price List
- Currency: GBP - British Pound
- Based On Price List: USD Price List
If you sell a product that costs 1 USD in the Unites States, the price of it will be converted to GBP based on the currency conversion rate defined. In this way, you can create a price list based on another price list, without creating corresponding price list items.
Price List Level Adjustment
Adjustment Type Select the type of adjustment. Supported values are:
- % Discount: If the user applies a % discount type of adjustment, the list price is discounted by a percentage specified in the Adjustment Amount field. The new amount is stored on the cart line item.
- Discount Amount: If the user applies a discount amount of adjustment, the list price is discounted by a percentage specified in the Adjustment Amount field. The new amount is stored on the cart line item.
- Markup Amount: If the user applies a markup amount of adjustment, the list price is increased by the amount specified in the Amount adjustment field. The new amount is stored on the cart line item.
- Price Factor: This is a multiplier. Select this and enter an amount in the Adjustment Amount field. Using this price factor, CPQ multiplies the list price on the cart.
- % Markup: If the user applies a percentage markup of adjustment, the list price is increased by the percentage specified in the Amount adjustment field. The new amount is stored on the cart line item. For example, if you want to increase the price of laptops during the month of September, you can apply a markup amount or a percentage markup that adds to the List price.
Adjustment Amount Enter a value based on the adjustment type that you have selected. Click Save. The Price List Details page is displayed with all information you provided.
- On the Details tab, update the details if required and click Save.
A price list is created and saved. You can associate products with the price list.