Skip to main content

Bundle upload

Zuora

Bundle upload

Before the sales order lines can be automatically split into child transaction lines, you must define how Zuora Revenue should expand or explode a single sales order line into multiple transaction lines. To do this, you must upload the bundle definition file to Zuora Revenue.

Before you begin

Before you can upload bundle definitions to Zuora Revenue, ensure the following requirements are met:

  • POB templates are created for each child lines of the bundle. For information, see Create POB template.

  • Advanced rules are associated with the appropriate POB templates. For information, see Advanced Rule.

  • The Enable_Bundle_Upload profile is set to Yes on the Setups > Application > Profiles page.

Procedure

Complete the following steps to upload bundle definitions to Zuora Revenue:

  1. Navigate to File Upload > Bundle.

  2. If the bundle template does not exist yet, create one by completing the following steps:

    1. In the Templates section on the Bundle page, click icon-add.png. The New Bundle Template windows is displayed.

    2. In the Template Definition tab, provide a unique template name and optionally a short description.

    3. Toggle the Enabled switch to Yes to enable this template.

    4. Select the type of file to be uploaded for the File Type field.

    5. If you select Text in the previous step, enter the separator between items in the Field Separator field.

    6. If a review is required for the template, toggle the Is Review Required switch to Yes.

    7. (Optional): Select the date format to validate the date value in the uploaded file for the Data Format field.

    8. (Optional): Select the start row to identify the row number from which the actual data is inserted into the staging table from the uploaded file for the Start Row field.

    9. Click icon-save.png. The template is created.

    10. Click the Field Mapping tab, enable the fields as bundle criteria by toggling the Bundle Criteria column to Yes for the field. If the field does not exist, click icon-save-green.png to add it.

    11. Save the field mapping configuration by clicking icon-save-green.png and close the window.

  3. To upload the bundle definition based on a template, complete the following steps:

    1. In the Templates section on the Bundle page, hover your mouse over the template line and click the Freeze icon icon-freeze.png so that no changes can be made in the template.

    2. Click the Download Template icon icon-download-template.png to download the template file.

    3. Open the template file, fill in the bundle information, and save the file.

      Header Description
      Bndl Cfg Valid From

      Required for the parent line.

      The effective start date of the line item.

      If the start date is not provided for the child line, it follows the start date of the parent line. If a valid start date is present for the child line, it takes precedence over the parent line’s start date.

      Bndl Cfg Valid Until The effective end date of the line item.

      The Bndl Cfg Valid From and Bndl Cfg Valid Until dates determine the effective period of the bundle configuration. When a sales order (SO) line comes in, the system will check whether the SO Date falls into the bundle configuration effective period. If yes, the bundle split occurs for the sales order line; otherwise, the sales order line will not be split.

      After the bundle split has happened to the SO line, any subsequent transaction lines (such as invoice, SO update, RORD, etc.) that are associated with this SO line will always follow the bundle configuration of the SO line.

      Parent Item Num The parent product/item number for all the child lines.
      Sell Price Split Type

      Required for the parent line.

      The calculation method for splitting the selling price. Valid values are:

      • PCT_OF_SP: Calculate based on a percentage.
      • FIXED_PRICE: A fixed sell price.
      • SAME: The same price as the parent line.
      Sell Price Split Val

      Applicable to child lines only.

      The selling price of the child line as a percentage of the parent line’s selling price.

      List Price Split Type

      The calculation method for splitting the list price. Valid values are:

      • PCT_OF_LP: Calculate based on a percentage.
      • FIXED_PRICE: A fixed price.
      • SAME: The same price as the parent line.
      List Price Split Val The list price of the child line as a percentage of the parent line’s list price.
      Cost Price Split Type

      The calculation method for splitting the cost price. Valid values are:

      • PCT_OF_CP: Calculated based on a percentage.
      • FIXED_PRICE: A fixed price.
      • SAME: The same price as the parent line.
      Cost Price Split Val The cost price of the child line as a percentage of the parent line’s list price.
      Bndl Cfg Quantity

      The quantity of the line item in the bundle configuration.

      For example, if the parent item quantity is 2 and the child line item quantity is 3, the actual quantity of the split line items is 6.

      Bndl Cfg Duration The term in months of the line item.
      Bndl Cfg Item Num The SO item number of the parent line or child line.

      The Split Type columns are only for the parent line. The line with the Split Type value specified will be considered as the parent line. Its child lines must have the Parent Item Num value specified to build a correlation between the parent and the child. If multiple parent and child lines are uploaded in the same file, the correlation between the different parent and child lines must be maintained based on this logic so that bundle split can happen correctly.

    4. Hover your mouse over the template line and click the Upload icon icon-upload.png.

    5. In the File Upload window, choose the local file with the bundle information that you added and click Upload.

What to do next

In the Uploaded Files section on the Bundle page, you can view the file upload result.  After the bundle definition file is uploaded to Zuora Revenue, the sales order file can be uploaded with one line (parent) and the total sales order value. Zuora Revenue will split the sales order line details into multiple child lines based on the bundle definition and POB templates.