Pricing Matrix Templates

Overview

Pricing for many industries require that pricing be calculated based on multiple inputs (multiple UIs, from / to country, value in excess of an allocated value, etc.) and in some cases that multiple charges or prices also be output from the Pricing Engine (e.g. a price for Mobile and a separate one for Landline call minutes).

The Pricing Matrix Templates module supports pricing that requires the Pricing Engine to use a custom dynamic matrix as the basis for calculating runtime prices. Pricing Matrix Templates can be used to price both one-time or recurring product prices and charges. Usage charges require a Rate Card since a specific unit price cannot be determined until later when actual usage metrics are available. Pricing Matrix Templates are used to define the specific metadata or columns that will be used to specify conditional pricing.

The process for defining a dynamic attribute-based matrix pricing involves four steps:

  1. Define Lookups with valid values for any menu type attributes you will use in your dynamic pricing.

  2. Create a Pricing Matrix Template to define the specific metadata or columns you will use to define one or more dynamic pricing attributes (ex. market, industry) use Lookups to define the list of valid values.

  3. Select the Pricing Matrix Template as the Dynamic Pricing type for a product charge.

  4. Define the specific column values and the resulting per unit prices for each combination of these values.

Pricing Matrix Template Pages

ClosedPricing Matrix Template List Page

The Pricing Matrix Templates page lists available Attribute-based Charge Templates and Rate Card Templates.

Note: The Rate Card Templates are now supported inside the Pricing Matrix Templates module and are no longer a stand-alone Pricing Portal module. Rate Card Template functionality has not been changed.

Each Attribute-based Charge Pricing Matrix Template can be used to define one or more Charges.

Pricing administrators can perform the following tasks from this page:

Pricing Matrix Template List Page

Item Description

1

Navigate to the Pricing Portal.

2

Enter search criteria to filter Pricing Matrix Templates.

3

Add a new Pricing Matrix Template (Attribute-based Charge or Rate Card) or manage columns.

4

Sort Pricing Matrix Templates using the Name, Variable Name, Template Type, or Status column headers.

5

Edit an existing Pricing Matrix Template by clicking on the Name link or selecting Edit from the line ellipsis drop-down.

6

 View linked Price Models or Rate Cards by clicking on the Linked Objects number.

7

Edit or Delete an existing Pricing Matrix Template by clicking on the line ellipsis.

Note: Pricing Matrix Templates with linked Price Models cannot be inactivated or deleted.

ClosedPricing Matrix Template Page

The Pricing Matrix Template page for an Attribute-based Charge type Template shows the basic details. It also lists the Input Columns and Output Columns that define the custom dynamic matrix. Pricing administrators can perform the following tasks from this page:

Prcing Matrix Template Page

Item Description

1

 Navigate to Pricing Matrix Templates list page.

2

Navigate to Next or Previous Pricing Matrix Template in the Pricing Matrix Template list or filtered Pricing Matrix Template search results list.

3

Modify the Basic Details for the Attribute-based Charge Template. If applicable, a Charge Definition Constraint can be specified in this section.

4

Add, Reorder, or Manage Columns for the input column lines.

5

Edit an existing input column by clicking on the Name link or selecting Edit from the line ellipsis drop-down.

6

 Edit or Delete an existing input column by clicking on the line ellipsis.

7

Add Block Size/Price attributes, Add an Item Price Attribute, Reorder, or Manage Columns for output columns.

Note: Both Block Size and Block Price attributes are added when Add Block Size/Price is selected. Correspondingly, if the Block Size attribute or the Block Price attribute is deleted, both of these interdependent attributes are also deleted.

8

Edit an existing output column by clicking on the Name link or selecting Edit from the line ellipsis drop-down.

9

Edit or Delete an existing output column by clicking on the line ellipsis.

Pricing Matrix Template - Product Charge Relationship

The following image shows the relationship between Pricing Matrix Template fields and Dynamic Attribute-based Matrix Pricing for a product price or charge.

  1. After a Pricing Matrix Template has been defined, it can be selected as a Dynamic Pricing type when creating a product price or charge.

  2. Input Columns in the Pricing Matrix Template define fields to specify the criteria for desired conditional pricing in the product price or charge.

  3. Output Columns in the Pricing Matrix Template define the pricing fields that are available. Pricing values are defined for each condition in the product price or charge. When Block Pricing is desired, the Block Size and Block Price attributes are added as Output Columns in the Pricing Matrix Template.

Pricing Matrix Template - Product Charge Relationship

To add dynamic matrix pricing to a Price Model Item product price or charge, the pricing administrator begins by selecting a customer pre-defined Pricing Matrix Template from the Dynamic Pricing drop-down.

Select a Pricing Matrix Template

After selecting the appropriate Pricing Matrix Template, the pricing administrator clicks the + icon to add a conditional row item to specify conditions and pricing.

Add Conditional Criteria and Pricing

Administration

ClosedAdd a Pricing Matrix Template

Complete the following steps to create an Attribute-based Charge type Pricing Matrix Template in the CPQ Pricing Portal.

  1. Navigate to the Admin page.

  2. Click Pricing Portal in the Products section.

  3. Click on the Pricing Matrix Template card.

  4. Select Add from the Actions drop-down.

  5. Enter the Name.

  6. Enter the Variable Name.

  7. Select Attribute-based Charge from the Template Type drop-down.

  8. (optional) Enter a Description.

  9. Click Create.

  10. If required, complete the following to add a Charge Definition Constraint.

    1. Click the Basic Details Edit button.

    2. Click on More Details.

    3. Click inside the Charge Definition Constraint field, and the select the applicable Charge Definitions.

    4. Click the Basic Details Update button.

  11. Complete the following to add Pricing Matrix Template Input Columns.

    1. Select Add from the Input Columns - Actions drop-down.

    2. Enter a Name for the input column.

    3. Enter the Variable Name for the input column.

    4. Select the Data Type.

    5. Select a Pricing Lookup from the Lookup drop-down.

      Note: This field is only available for string data types. Refer to Pricing Lookups for more information.

    6. Select the Operator function to use for the specified Pricing Attribute.

    7. Select the applicable Pricing Attribute.

      Note: You can enter text in the Pricing Attribute field to filter the Pricing Attributes list.

    8. (optional) Select or enter a Default Value.

    9. Check Default Value Overridable if the default value can be modified by a sales user.

      • This option is only editable when a Default Value is specified.

      • The default value cannot be specified for currency data types.

      • Only True or False values can be selected for Boolean data types.

      • When a Lookup is selected, you can select a default value from values defined in Pricing Lookups.

    10. Check Required to make this field mandatory.

    11. Check Null as Wildcard to regard a Null value in the pricing matrix as a wildcard in matching the input condition.

      For example, a customer has the following discounts for T-shirt based on sizes and colors. (When the Size is large, the discount is 10% regardless of Color):

      • Size: large, Color: red, Discount: 10%

      • Size: large, Color: white, Discount: 10%

        Size: small, Color: red, Discount: 5%

      • Size: small, Color: white, Discount: 15%

        When this option is enabled, the setup can be simplified by setting Color as Null instead of enumerating all color choices. (Size: large, Color: null, Discount: 10%)

    12. (optional) Enter a Description.

    13. Click Create.

  12. Repeat Step 11 to create additional input columns.

    Note: The Item Price attribute is automatically populated as a default output column.

  13. If required, select Add Block Size/Price from the Output Columns - Actions drop-down to add block pricing output columns.

    Note: Both Block Size and Block Price attributes are added when Add Block Size/Price is selected. Correspondingly, if the Block Size attribute or the Block Price attribute is deleted, both of these interdependent attributes are also deleted.

ClosedAdd a Rate Card Template Oracle CPQ 24B and Later

Beginning in Oracle CPQ 24B, Rate Card Templates are defined in the Pricing Matrix Templates module. To add a Rate Card Template for releases prior to Oracle CPQ 24B (releases 23D - 24A), refer to Rate Cards.

Complete the following steps to create a Rate Card Template for releases Oracle CPQ 24B and Later.

  1. Navigate to the Admin page.

  2. Click Pricing Portal in the Products section.

  3. Click on the Pricing Matrix Templates card.
  4. Click Add.
  5. Enter the Name.
  6. Enter the Variable Name.
  7. Select Rate Card for the Template Type drop-down.
  8. (optional) Enter a Description.
  9. Click Create.

Add Pricing Matrix Template Columns

  1. Select Add from the Actions drop-down.
  2. Enter a Name for the Pricing Matrix Template column.
  3. Enter the Variable Name for the Pricing Matrix Template column.
  4. Select the Data Type.

  5. Select a Pricing Lookup from the Lookup drop-down.

    • This field is only available for string data types.
    • Refer to Pricing Lookups for more information.

  6. (optional) Select or enter a Default Value.

    • The default value cannot be specified for currency data types.
    • Only True or False values can be selected for Boolean data types.
    • When a Lookup is selected, you can select a default value from values defined in Pricing Lookups.

  7. Check the Default Value Overridable option if the default value can be modified a sales user.

  8. Check Negotiable to allow modification of this attribute at runtime.

  9. Check Key to identify this field as a unique identifier.

  10. Check Required to make this field mandatory.

  11. optional) Enter a Description.

  12. Click Create.

 

Notes

Notes:

  • Rate Card Templates and columns are no longer supported in bulk service, but they continued to be supported in Migration.

    This is consistent with CPQ's direction to use migration for moving schema-type data.

  • Pricing Matrices, including Rate Cards, are not supported in Migration.

  • Fields not relevant to a specific row in the CSV file are ignored.

    (e.g. Block Size, Block Price for a charge that is defined by a rate card or attribute-based matrix are ignored in the PART_PRICES.csv)

  • Uploading pre-24B CSV files with the older rate card entity names are still supported.

  • Incremental migration for Pricing Matrix Templates is not supported when a matrix template column with the same variable name has been created independently in n-1 and n sites.

Related Topics

Related Topics Link IconSee Also