Data Loader templates for advanced multi action orders

This article provides reference templates for common order scenarios in Data Loader, such as renewing subscriptions, removing products, creating subscriptions with multiple rate plans, and adding products with recurring charges.

Sample Templates

The Zuora Data Loader Advance Multi Action Template template is designed for flexibility, allowing users to tailor the CSV file to their specific data migration needs. This means you can retain only the columns necessary for your operation and remove any that are not required. However, it's crucial to ensure that all mandatory fields—indicated by an asterisk (*) in the template—are included to prevent errors during the data import process.

By customizing the template to include only relevant fields, you can streamline the data preparation process and focus on the information pertinent to your business requirements. These customized templates can be reused for future data loads, provided there are no changes to the field configurations in your Zuora tenant.

If there have been modifications to the tenant's configuration—such as the addition of new custom fields or changes to existing ones—it's recommended to download a fresh template directly from the target tenant. This ensures that your template reflects the most up-to-date field configurations, maintaining alignment between your data and the tenant's current setup.

Add Product with Recurring Flat Fee Charge

The file provided is designed to add a product with a recurring flat fee override to an existing account using Zuora's Data Loader Advance Multi Action Template . Here are the column headers and a brief description of the headers.


Column Name	Description
Trigger Dates Trigger Date	The specific date when the order action is triggered.
Trigger Dates Name	Defines when the order takes effect (e.g., ContractEffective).
Subscriptions Subscription Number	Specifies the existing subscription number if modifying. Required if not creating a new one.
Processing Options Run Billing	Boolean flag indicating if billing should be triggered. Optional.
Processing Options Collect Payment	Boolean flag indicating if payment should be collected. Optional.
Order Date*	The effective date for the order. Required.
Order Actions Change Reason	Optional explanation for the order action.
IsNewTriggerDate	Boolean value that specifies whether a new trigger condition is defined.
IsNewSubscription	Indicates whether a new subscription is being created. Should be True for the first row of a new subscription.
IsNewOrderAction	Boolean flag indicating if a new order action is being defined. Required for each distinct action.
IsNewOrder*	Indicates if a new order is being created. Required and should be True for the first line of each new order.
IsNewCharge	Indicates if a new charge override is being applied. Should be True for the first override line.
Existing Account Number*	The customer account number to which the order is being added. Required.
Description	Optional text describing the order.
Charge Type*	Defines the type of charge (e.g., recurringFlatFee). Required.
Charge Product Rate Plan Charge Id*	ID of the charge in the product rate plan. Required.
Charge List Price	Price override for the charge. Optional if using default pricing.
Category	Optional descriptive field to classify the order.
Action Type*	Defines the action type such as addProduct. Required.
Action Product Rate Plan Id	ID of the product rate plan being added. Required for product-related actions.

Note:

Only required columns (marked with an asterisk *) must be included to process the job successfully.
This file is a minimal and effective template for adding a product to an existing account and customizing the charge price using charge overrides.
Columns unrelated to this specific use case (e.g., order line items, discounts, usage charges) are intentionally removed for clarity and ease of use.

Renew Subscription and Remove Product

This file appears to handle a use case involving subscription renewal and product removal within a single order using multiple order actions.


Column Name	Description
IsNewOrder*	Required. Indicates whether a new order is being created (True for the first row of the order).
Existing Account Number*	Required. Specifies the Zuora account number to which the order will be applied.
Order Date*	Required. The effective date of the order.
Category, Description	Optional metadata fields for order classification and notes.
Processing Options Collect Payment, Processing Options Run Billing	Flags to control billing and payment during processing.
IsNewSubscription	Indicates whether a new subscription is being created (True) or not. In this case, it's a renewal, so it references an existing subscription.
Subscriptions Subscription Number	Required for actions on existing subscriptions, such as renewals or product removals.
IsNewOrderAction	Required. Indicates the beginning of a new order action. Multiple True entries imply multiple actions in the same order.
Order Actions Change Reason	Optional. Use this field to document the reason for the order action (e.g., business justification).
IsNewTriggerDate, Trigger Dates Name, Trigger Dates Trigger Date	These columns control when the order action is triggered. Typically ContractEffective for renewals.
Action Type*	Required. Type of action such as renewSubscription, removeProduct.
Action Product Rate Plan Id	Required for actions involving product manipulation (e.g., add/remove).
IsNewCharge, Charge Product Rate Plan Charge Id, Charge Type, Charge List Price	Optional. Relevant if you are overriding pricing for a product being added, not used here.

Note:

The file uses multiple rows to define distinct order actions (renew and remove product) in a single order, which is efficient for complex order workflows.
Only necessary columns are retained, making the file clean and focused.
Charge override fields are unused, as this file is not adding or customizing charges.
Use this template when you want to renew an existing subscription and remove a product within the same order.
Make sure IsNewOrder is marked True only on the first row.
For each action (renew, removeProduct), set IsNewOrderAction to True and provide appropriate fields.
If custom fields or new rate plans are added to the tenant, download a fresh template to capture updated configurations.

Create Subscription with Multiple Rate Plans

This file is used to create a subscription with multiple rate plans and charge configurations.


Column Name	Description
IsNewOrder	Indicates the start of a new order. Only marked True for the first row of the order.
Existing Account Number*	Identifies the customer account in Zuora Billing. Required.
Order Date*	Date on which the order is placed. Required.
IsNewSubscription	Marks whether a new subscription is being created.
Action Type*	Specifies the action to be performed (e.g., createSubscription). Required.
IsNewOrderAction, Order Actions Change Reason	Indicates if a new order action is being defined in the current row.
IsNewRatePlanSubscribeToRatePlans	Marks the addition of a new rate plan under the subscription.
Action Subscribe To Rate Plans Product Rate Plan Id*	Identifies the product rate plan being added. Required when subscribing to rate plans
IsNewCharge	Indicates the start of a new charge being configured.
Charge Product Rate Plan Charge Id*	Identifies the specific charge within the product rate plan. Required.
Charge Type*	Specifies the charge type (e.g., recurringTiered, oneTimeFlatFee).
Charge Tier Number*	Used for tiered charges to specify the tier index.
Charge Tier Price*	The price for that tier
Charge Tier Starting Unit*, Charge Tier Ending Unit	Used in tiered pricing to define unit ranges.
Charge List Price	Price for flat fee or one-time charges

Note:

This template is designed to:

Create a new order and subscription.
Add multiple rate plans under the subscription.
Configure both tiered and flat fee charges within the same subscription.

Each row continues a specific part of the order structure. By marking IsNewOrderAction, IsNewCharge, and other flags appropriately, this structure supports complex product setups

Data Dictionary for Advance Multi Action Orders

See Advance Multi Action Order Data Dictionary and the following sample CSV files with Data:

Known Facts

Data Loader is considering the support for the following fields:


OrderAction	ArrayofObject	Fields
AddProduct	ChargeOverrides	ratingPropertiesOverride isProrateParticlaMonth prorationunit daysInMonth accountReceivableAccCode
AddProduct	ChargeOverrides>Pricing> recurringdeliverybased	recurringdeliverybased pricechangeoption priceincreaseoption deliveryschedule listprice priceIntervals
Create Subscription, Owner Transfer, Terms and Conditions		PaymentProfile Payment GatewayID PaymentMethodID
Create Subscription		newSubOwnerAccount billtocontact taxInfo soldtocontact

Note:

Data Loader does not support credit card fields
Scheduling orders fields are not supported.

Welcome to Zuora Product Documentation

Explore our rich library of product information

Data Loader templates for advanced multi action orders

Sample Templates

Add Product with Recurring Flat Fee Charge

Renew Subscription and Remove Product

Create Subscription with Multiple Rate Plans

Data Dictionary for Advance Multi Action Orders

Known Facts

zuora-footer