Skip to main content

Create a Product Rate Plan Charge (PRPC)

Zuora

Create a Product Rate Plan Charge (PRPC)

  1. Last updated
  2. Save as PDF

With the new catalog, you can define attribute-based pricing (ABP) for charges, along with the ability to set a base price.

Base price

Set the default price of the PRPC without attributes (i.e., non-ABP charges).

Upload Pricing

Use the Upload screen to upload a .csv or .xlsx pricing file for a specific rate plan. This allows you to bulk upload static pricing data using a spreadsheet or *.csv file. This is useful when:

  • You have multiple products or rate plans to update quickly.
  • Each product/attribute combination has a fixed price.
  • You are not using attribute-based rules or segmentation.

You can upload a file containing region-based or attribute-based pricing data for a product rate plan. After uploading, you will map the headers in the file to the appropriate pricing attributes in Zuora before finalizing the setup.

The file must include a header row with columns corresponding to attribute fields such as State, Currency, Price, Min, and Max.

To upload a file:

  1. In the Upload screen, drag and drop the .csv or .xlsx file, or click Select File to upload it. The Source File Header Fields section will remain empty until the file is successfully uploaded. Once uploaded, the header fields are displayed.
  2. (optional) Provide a description of the file.
  3. Click Next to proceed to the Mapping step. The Mapping screen allows you to match your uploaded file’s header fields to Zuora’s supported pricing attributes, such as Country, Segment, or Product. These attributes must be pre-defined in Zuora (created under the Context and Attributes section under the Extension Studio option).
    clipboard_e23cf8a4c0eef0a512b0e19fa5a68e31a.png

All required fields are marked with an asterisk (*). You must map these fields to continue. For example, Price is mandatory and must be mapped to a column in your file.

  1. Select the corresponding column name from your uploaded file that matches each target field. For example, if your CSV file has a column called Region, map it to the Country or County field. The Target fields are predefined attributes in Zuora used to filter and apply pricing dynamically, for example, Product, Country, Term length, Segment, and so on.
    You can view the raw values from your uploaded file for the currently selected mapping. This preview helps confirm you’ve chosen the correct source field.
    Example: Suppose your uploaded file includes the following headers:
    url, region, product_code, term_months, tier1_price. You can map them as:
Target Field Source Header
County url
Country region
Product* product_code
Term length term_months
Price*` unitPrice
  1. Click Next to proceed to the Review screen.
  2. Verify the uploaded pricing data before applying it to the product catalog.
  3. Click Save to save your changes. Or, click Back to return to the Mapping step and adjust your selections.
  4. Before saving, ensure that:
    • File headers do not contain spaces.
    • There are no duplicate rows in the file.
    • Field mappings are accurate.
    • If you need to update a Charge with uploaded pricing, you can upload a new file. Note that:
      • Condition columns cannot be added or removed.
      • New rows can be added.
      • Column values can be updated.
      • Adjustment and price limits can be added or removed.
      • Column mapping must remain the same.