The Mass Updater is a tool that allows you to easily perform mass actions in Zuora. Instead of performing an action over and over again, you can put all the data in a single
.csv file and upload that file to the Mass Updater. The Mass Updater asynchronously performs the actions for you, and returns a response file with information about the outcome of each action.
You can perform mass actions through the Zuora UI or REST API. For REST API, see the Mass Updater resource group.
You must have Z-Finance enabled on your tenant to use the Mass Updater.
You can perform the following mass actions:
Each row in the file you upload represents an individual action in Zuora, such as updating the accounting code on an invoice item or creating a revenue schedule. We refer to each row as a "record." Records are processed in the order that they appear in the uploaded file.
Each column in the file represents a field. See the articles in the "Supported Mass Actions" section above for details about the columns you can use with each mass action type.
When you upload a file, Zuora checks the formatting. If the formatting is correct, the mass action is executed. If the format is incorrect, an error message is displayed.
The file you upload must be one of the following:
If you are using Microsoft Excel on Mac OS, you must save the
The maximum file size is 4 MB.
All dates in the uploaded file must be in YYYY-MM-DD format. For example:
If you are using Microsoft Excel, you must manually change the cell formatting to this format.
All mass actions support informational columns. Informational columns allow you to include additional information in the upload file. These columns are for your reference only and are not processed when you upload the file.
To create an informational column, prefix the column name with a hash (#), for example, "#Currency". You can add any number of informational columns and they can be placed anywhere in the uploaded file.
When a mass action is complete, a response file appears in the Upload History. The response file is a zipped
.csv file. The response file is identical to the file you uploaded, with additional columns providing information about the outcome of each record.
See the articles in the "Supported Mass Actions" section above for more information about the response files for each type of mass action.
To perform a mass action, do the following:
Select an action from the Mass Action to Perform drop-down menu.
After you have uploaded a file, you can check on the progress of the mass action in the Upload History. The following three columns are updated in real-time:
You must refresh the page or click the Refresh button to get the most recent information about the progress of a mass action.
The following table describes the mass action statuses.
Mass action has not yet started being processed.
Mass action is in progress.
Mass action is in the process of stopping, but has not yet stopped.
Mass action has stopped.
Mass action was successfully completed. There may still be failed records.
Mass action failed. No records were processed. No response file is returned. An error message is displayed in the Response File column.
You can stop a mass action while its status is Pending or Processing. On the Mass Updater page, do the following:
If you stop a mass action when its status is Pending, no actions have been processed and therefore no response file is returned.
If you stop a mass action when its status is Processing, a response file is returned. You can check the response file to see which records have been processed. In the response file, the Success column has the value
Y (successful) or
N (failed) for processed records, and a blank value for unprocessed records.
Records that have already been processed when a mass action is stopped are not rolled back.