Welcome to Zuora Product Documentation

Explore our rich library of product information

Price Calculation in Zuora Connector for Salesforce CPQ

This article presents how each Salesforce CPQ price setting is mapped to a Zuora charge model and provides sample calculation for the mappings.

This article presents how each Salesforce CPQ price setting is mapped to a Zuora charge model and provides sample calculation for the mappings.

Salesforce CPQ prices are translated to Zuora charges as below.

Salesforce CPQ Price SettingZuora Charge ModelPrice Format
Price Book EntryFlat Feen/a
Price Book EntryPer Unitn/a
Discount Schedule - SlabTiered PricingPer Unit
Discount Schedule - RangeVolume PricingPer Unit
Block PriceVolume PricingFlat Fee

Price calculation in Zuora Connector for Salesforce CPQ can be summarized as below:

  • Per unit, flat rate, and tier charges without an additional discount: The price is copied from the product catalog.
  • Tier charges with an additional discount percentage: The price is copied from the product catalog, and each tier is multiplied by the discount percentage.
  • Tier charges with an additional discount amount: Using the net total as total price over the term, a flat rate of price per billing period is calculated. In Salesforce CPQ, the net price calculations differ among Discount Schedule Range, Discount Schedule Slab, and Block Price. See the below sections for how the net prices are calculated for each type of pricing.

Sample Price Calculations for Price Book Entry

Salesforce CPQ price book entries are translated to the flat fee or per unit charges in Zuora in the following steps:

  1. Salesforce CPQ calculates the Net Price, a unit price over the full term:
    • Net Price for newly added products = Salesforce CPQ Customer Price * Prorate Multiplier
    • Net Price for updates and renewals = Salesforce CPQ Renewal Price * Prorate Multiplier
  2. Zuora Connector for Salesforce CPQ calculates the Zuora Price and sends it to Zuora:
    1. Final Net Price = Net Price with any additional discount is applied against
    2. Zuora requires a unit price for a single billing period:Zuora Price = Final Net Price / Prorate Multiplier

The following table shows sample price calculations for Price Book Entry prices.

The Contract Terms for all the examples are assumed to be 12 months.

Billing PeriodProrate MultiplierCustomer PriceQuantityNet PriceAdditional Discount AmtAdditional Discount%Zuora Price
Month12120011200100
Month121180112002098.33333
Month12840112003070
Annual11001100100
Month12360031200100
Month123480312004096.66666667
Month121800312005050
Annual13003100100

Sample Price Calculations for Discount Schedule - Range

Salesforce CPQ Discount Schedule - Range prices are translated to Per Unit Volume Charges in Zuora.

Overriding any tiers outside the range is not supported.

  • For no additional discount - Zuora Connector for Salesforce CPQ copies the Salesforce CPQ List Price to Zuora Price.
  • To apply an Additional Discount Percentage - Zuora Connector for Salesforce CPQ multiplies each tier price by the Additional Discount %.
  • To apply an Additional Discount Amount - Any additional discount is applied against the Net Unit Price, then divided by the Prorate Multiplier:
  1. Salesforce CPQ calculates the Net Price. For Discount Schedule - Range, the Net Price is a unit price over the full term:
    • Net Price = Unit Price * Prorate Multiplier
  2. Zuora Connector for Salesforce CPQ calculates the Zuora Price and sends it to Zuora:
    1. Final Net Price = Net Price - Additional Discount Amount
    2. A single flat fee is sent to Zuora.Zuora Price = (Final Net Price / Prorate Multiplier) * Quantity

The following table shows sample price calculations for Discount Schedule Range. The Contract Terms for all the examples are assumed to be 12 months.

Billing PeriodProrate MultiplierList PriceQuantityNet Unit PriceAdditional Discount AmtAdditional Discount%Zuora Price
Month12

1-10: $100

10-100: $50

11

600

= 50 * 12

1-10: $100

10-100: $50

Month12

1-10: $100

10-100: $50

1160030

1-10: $70

10-100: $35

Month12

1-10: $100

10-100: $50

1160020

$531 Flat Fee

Annual1

1-10: $100

10-100: $50

1150

1-10: $100

10-100: $50

Sample Price Calculations for Discount Schedule- Slab

Salesforce CPQ Discount Schedule - Slab prices are translated to Per Unit Tier charges in Zuora as below.

  • For no additional discount - Zuora Connector for Salesforce CPQ copies the Salesforce CPQ List Price to Zuora Price.
  • To apply an additional discount percentage - Zuora Connector for Salesforce CPQ multiplies each tier price by the Additional Discount %.
  • To apply an additional discount amount - Any additional discount is applied against the Net Unit Price, then divided by the Prorate Multiplier:
  1. Salesforce CPQ calculates the Net Price. For Discount Schedule - Slab, the Net Price is calculated:
    • Net Price = (Unit Price * Quantity) for all applicable tiers * Prorate MultiplierNote that in Salesforce CPQ, the end of a tier range is exclusive.
  2. Zuora Connector for Salesforce CPQ calculates the Zuora Price and sends it to Zuora:
    1. Final Net Price = Net Price - Additional Discount Amount
    2. A single flat fee is sent to Zuora.Zuora Price = Final Net Price / Prorate Multiplier

The following table shows sample price calculations for Discount Schedule Slab. The Contract Terms for all the examples are assumed to be 12 months.

Billing PeriodProrate MultiplierList PriceQuantityNet PriceAdditional Discount AmtAdditional Discount%Zuora Price
Month121-10: $10010-100: $5011

12000 =

(9 * 100+ 2 * 50)* 12

1-10: $10010-100: $50
Month121-10: $10010-100: $50111200040$996.666Flat Fee
Month121-10: $10010-100: $501112000501-10: $5010-100: $25
Annual11-10: $10010-100: $501110001-10: $10010-100: $50

Sample Price Calculations for Block Price

Salesforce CPQ Block Prices are translated to Flat Fee Volume charges in Zuora as below.

  • For no additional discount - Zuora Connector for Salesforce CPQ copies the Salesforce CPQ List Price to Zuora Price.
  • To apply an additional discount percentage - Zuora Connector for Salesforce CPQ multiplies each tier price by the Additional Discount %.
  • To apply an additional discount amount - Any additional discount is applied against the Net Unit Price, then divided by the Prorate Multiplier:
  1. Salesforce CPQ calculates the Net Price. For Block Price, the Net Price is a unit price over the full term:
    • Net Price = Unit Price * Prorate Multiplier
  2. Zuora Connector for Salesforce CPQ calculates the Zuora Price and sends it to Zuora.
    1. Final Net Price = Net Price - Additional Discount Amount
    2. A single flat fee is sent to Zuora.Zuora Price = Final Net Price / Prorate Multiplier

The following table shows sample price calculations for Block Price. The Contract Terms for all the examples are assumed to be 12 months.

Billing PeriodProrate MultiplierList PriceQuantityNet PriceAdditional Discount AmtAdditional Discount%Zuora Price
Month121-10: $100 flat10-100: $50 flat11

600 =

50 * 12

1-10: $100 flat10-100: $50 flat
Month121-10: $100 flat10-100: $50 flat1160020$48.333 flat
Month121-10: $100 flat10-100: $50 flat11600301-10: $70 flat10-100: $35 flat
Annual11-10: $100 flat10-100: $50 flat11501-10: $100 flat10-100: $50 flat