Loading
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Calculate the Derived Price of Product

          Calculate the Derived Price of Product

          Use the discovery procedure and the derived price element in a pricing procedure, to calculate a product’s price from another product or asset.

          Required Editions

          Available in: Lightning Experience
          Available in: Enterprise, Unlimited, and Developer Editions of Revenue Cloud where Salesforce Pricing is enabled
          User Permissions Needed
          To create pricing procedures: Salesforce Pricing Design Time
          To run pricing procedures: Salesforce Pricing Run Time

          Let's calculate the price of a laptop bag when a user purchases a Laptop Pro Bundle. Our pricing strategy is to tie the price of the laptop bag to the Laptop Pro Bundle. We'll price the laptop at 10% of the Laptop Pro Bundle's price.

          Create Derived Products

          Before you begin, remember these key pieces of information.

          • The derived and source products must belong to the same price book. In our example, we’re using the predefined Standard Price Book.
          • If you select Header (Quote Line) as your pricing source, you don’t need to provide a source product. You can calculate the derived price of a product from the total cart values.
          1. From the App Launcher, find and select Products.
          2. Under the Product Name, click Laptop Bag.
          3. On the Related tab, under Price Books, select Add Standard Price.
          4. Specify these details.
            1. Is Derived: Selected
            2. List Price: $0.00
            3. Product Selling Model: Evergreen Yearly
          5. Save your changes.

          Create Derived Price Record

          To determine the formula used to calculate the derived price of a product, you’ll need to create derived price records. The pricing data from the derived price records is stored in the Derived Pricing Entries decision table.

          1. From the App Launcher, find and select Derived Prices.
          2. Click New.
          3. On the New Derived Price page, specify these details:
            1. Derived Pricing Scope: Transactional
            2. Pricing Source: Product
            3. Price Book: Standard Price Book
            4. Derived Product: Laptop Bag
            5. Source Product: Laptop Pro Bundle
            6. Formula: ListPrice * 0.10
            7. Effective From: 01-01-2025
          4. Save your changes.
          Important
          Important

          Refresh the Derived Pricing Entries and the Price Book Entries V2 decision tables to ensure that the derived pricing records are available for pricing.

          Configure Your Discovery Procedure

          1. From the App Launcher, find and select Discovery Procedures.
          2. Select the Default Discovery Procedure.
          3. Delete the Asset Discovery element. Since our scenario is transactional, we don’t need this element.
          4. Save the discovery procedure as new discovery procedure and provide a name.
            For our example, you can name your discovery procedure as Discovery Procedure for Derived Pricing.
          5. Click Simulate.
          6. Provide your input values.
            Remember that the Laptop Pro Bundle's DerivedPricingAttribute field must be set to false, because it is the source product. The Laptop Bag's DerivedPricingAttribute fields must be set to true because we’ll derive it's price from the source product.

          You’ll not see the results in waterfall view. The purpose of simulating the discovery procedure is to fetch all the contributing factors and write them back into the context definition.

          Create a Pricing Procedure for Derived Price

          Important
          Important You can’t apply discount distribution to a pricing procedure that was used to calculate a product's derived price.
          1. Create a pricing procedure. To create a pricing procedure, follow the first 5 steps in Configure Your Pricing Procedure.
          2. Click Add Element iconto add the Pricing Setting element and map these variables.
            • Input Variables
              • Line Item: LineItem
              • Is Derived: DerivedPricingAttribute
            • Output Variables
              • Price Waterfall: price_water_fall
              • Net Unit Price: NetUnitPrice.
              • Subtotal: ItemNetTotalPrice
          3. Add the List Price element to fetch the base price of the product.
            Under Lookup Table Details, select the Price Book Entries V2 decision table and map these variables.
            • Input Rule Variables
              • Product: Product
              • Price Book: PriceBooks
              • Product Selling Model: ProductSellingModel
            • Input Variables
              • Quantity: LineItemQuantity
            • Output Variables
              • List Price: ListPrice
              • Subtotal: ItemNetTotalPrice
          4. Add the Derived Price element to calculate the derived price. Map these input variables.
            • Quantity: LineItemQuantity
            • Contributing Net Unit Price: ContributorUnitPrice
            • Contributing Sub Total: ContributorTotalPrice
            • Contributing Source: ContributorSource
            • Contributing Scope: ContributorScope
            • Transactional List Price: ListPrice
            • Non-Transactional List Price: ContributorListPrice
            • Derived Formula: ContributorFormulaInput
            • Contributor: Contributor
            • Contributing Product: ContributorProduct
            • Header Total: TotalAmount
          5. Click Pricing Procedure Builder iconand select Include in Output.
          6. Finally, set your preferences to set profile access and rank information.
          7. Save your procedure.
          8. Click Simulate to test your procedure.
          9. Enter the input values for your contributor product (Laptop Pro Bundle) and the derived product (Laptop Bag). Click Simulate again.
            The price waterfall shows the Laptop Bag’s price was derived from the Laptop Pro Bundle, confirming that your procedure is working as expected.
            Derived Price waterfall view
           
          Loading
          Salesforce Help | Article