You are here:
Apply a Product's List Price
Configure a fallback search so an order uses a customer-specific price when one exists, and the product's standard list price otherwise.
Required Editions
| Available in: Lightning Experience |
| Available in: Enterprise and Unlimited Editions in Manufacturing Cloud, Automotive Cloud, and Consumer Goods Cloud, with required add-ons. |
Let's consider a scenario where Acme Fabrication orders Steel Bracket A100. Because Acme Fabrication has a negotiated customer-specific price, the order must use $95 per unit instead of the $120 standard list price. A different customer ordering the same product, with no negotiated price on file, must still see the $120 list price.
-
Define the Pricing Key Types.
See Create a Pricing Key Type for the create/activate procedure. Create two key types, as follows.
- "Account + Product" — Anchor Type: Account And Account Hierarchy and Product And Product Hierarchy. Click Save, then Activate.
- "Product" — Anchor Type: Product And Product Hierarchy. Click Save, then Activate.
-
Define the Search Strategy.
- See Create a Pricing Search Strategy for the create/activate procedure.
- Enter a Name (for example, "Search By Account and Product"), select a Context Definition, and click Save.
- Add two Pricing Search Strategy Steps: step 1 with Pricing Key Type = "Account + Product" and Sort = 10 (matches Acme Fabrication's negotiated price for Steel Bracket A100); step 2 with Pricing Key Type = "Product" and Sort = 20 (matches the product's list price when no account-specific record exists).
- Click Save, then Activate.
-
Define the List Price Specification.
- See Create a Pricing Specification for the create/activate procedure. Create a specification named "List Price."
- Set Meta Type to Price, Base to Value or Quantity, and Condition Level to OrderItem. Link the search strategy from the previous step. Click Save, then Activate.
-
Define the Calculation Schema.
- See Create a Pricing Calculation Schema for the create/activate procedure. Create a schema named "Standard Pricing Procedure."
- Add a Calculation Schema Step referencing the List Price specification, with Position = 10 and Mandatory checked, so pricing fails with an error rather than silently pricing an item at zero if no price is found. Click Save, then Activate.
-
Define the Procedure Plan.
Note There's no meta type literally called "List Price" — Price is the correct value for a base/list price step.- See Create a Procedure Plan for the create/activate procedure. Map your Sales Organization / Internal Organization Unit and Order Pricing Type to this calculation schema.
-
Load the Pricing Data.
- From Setup, in Quick Find, enter Data Loader, and select it. Click Insert, select External Pricing Key Value, and import two records: one keyed by Acme Fabrication's Account + Steel Bracket A100 with a Pricing Value of 95, and one keyed by Steel Bracket A100 only with a Pricing Value of 120.
- Run the External Pricing Key Value Consolidation job so the imported records become available at runtime. See Load Pricing Data from a Backend ERP System for the full job procedure — every scenario in this section reuses it.
-
Simulate the Price.
- Create an order for Acme Fabrication with a line item for Steel Bracket A100 (see Price an Order).
- Click Calculate Price.
- Open the Pricing Details tab for the line item. The Calculation Result for step 10 shows $95, and the Condition Found column confirms the "Account + Product" search step matched — the customer-specific price, not the list price.
- Create a second order for a different customer, with no negotiated price on file, for the same product. The Calculation Result shows $120, and Condition Found confirms the "Product" step matched instead.
- Load Pricing Data from a Backend ERP System
Export pricing condition data from an ERP system and consolidate it for runtime pricing lookups — the load-and-consolidate procedure shared by the pricing scenarios in this section.
Did this article solve your issue?
Let us know so we can improve!
