Data Loader templates for advanced multi-action orders

This article provides reference templates for renewing subscriptions, removing products, creating subscriptions with multiple rate plans, and adding products with recurring charges.

Sample Templates

If the tenant configuration has been modified, such as adding new custom fields or updating existing ones, download a fresh template from the target tenant. This ensures the template reflects the latest field configurations and stays aligned with your data and the tenant's current setup.

The Zuora Data Loader Advanced Multi-Action template enables flexible data migration by allowing users to customize the CSV file. Users can remove unnecessary columns and retain only required fields. All mandatory fields, marked with an asterisk (*), must be included to ensure successful processing and avoid validation errors

Customized templates can be reused for subsequent data loads if the tenant configuration remains unchanged. If the configuration is updated (for example, by adding new custom fields or modifying existing ones), download a new template from the target tenant to ensure alignment with the current schema.

Add Product with Recurring Flat Fee Charge

This file is used to add a product with a recurring flat fee override to an existing account using the Advanced Multi-Action template.


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 handles a use case that includes 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

Field Support Considerations


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.

Data Dictionary for Advanced Multi-Action Orders

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

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

Field Support Considerations

Data Dictionary for Advanced Multi-Action Orders

zuora-footer