Price Maintenance-SKU Based


Prices are best maintained in pricebooks (part number + price code drive the price). Pricebooks are used when there is a need for defining prices in different currencies for the same products placed in diverse markets. For example, sales person wants to place some products to European customers. He will define pricebook for European market. If he also wants to sell same products to the Japanese market, he will need to create another pricebook for that specific market, different from the first one. With this feature, he can create as much pricebooks as there are different markets he is placing his products to. Price will be obtained by taking value of dynamically built part number and using it along with price code to get the price from pricebook. The same pricing mechanism will be used every time product price is calculated (part number + price code to retrieve price).


Pricebooks can be created/updated in 3 ways:
1. Update records through the Pricebook setup
2. Update records by editing the product and updating pricing through View Prices link
3. Update records with another system through CPQ API

Option 1
Update records through the pricebook setup Pricebook Definition can be assessed from CPQ Setup→Pricing/Calculations→Pricebooks. This opens up the pricing page as shown in figure A. To add a new table, click Add New Pricebook button.

Pricebooks page

To update existing pricebook entries, click on the icon, this opens the pricebook entries in a table view(Figure A). You will be able to create new table entries manually or with the assistance of templates and excel spread sheets. You can export any existing pricebook entries into an Excel spreadsheet. This allows quickly updating pricing, descriptions, or any other field that the spreadsheet contains. Once re-uploaded, the modifications will be made to the prices in the system.

Figure A - View Table Entries page

You can update existing entries manually (one at a time) by clicking the button or by clicking the Export button for mass update of entries. Entries can also be created manually (one at a time) by selecting or through import by selecting , pricebook will be exported to Excel file template. The Excel file template should be completed and uploaded by clicking the button.

When creating new entries in the spreadsheet, value in the CpqTableEntryId column shouldn't be added. This value is strictly for the system’s use. When entries are exported this column will be filled with that part number’s system ID. This allows the system to uniquely identify each part number row in the spreadsheet.

Pricebook Import template

Once the spreadsheet is completed/updated, Click button on the View Table Entries page, this opens up the Import Entries page, Click the Browse button. Choose the modified template and click Save.

Import Entries page

Once you have uploaded and saved your information, you can go to the user side to verify pricing information.

Option 2
Update records through View Prices link for a product. You can update pricebook entries for a particular product through View Prices link (Pricing section) on the product definition tab. Navigate through CPQ Setup→Products→Attributes and edit the product (let’s assume “Blackberry”). Go to the pricing section of product definition tab, select pricebook lookup as the pricing mechanism. Click the View prices link, this opens a pop up window as shown in figure B.

Figure B -Pop up window shows pricebooks entries

Once you have updated and saved your information, you can go to the user side to verify pricing information for that product (Blackberry).

Option 3
Update records with another system through CPQ API. Please note that this is a different web method - not the standard Pricing API method. For more details, go to Upsert API Method for pricebook.

You are here: SAP CPQ Online HelpBest PracticesPricing/CalculationsPrice Maintenance-SKU Based