Best practices for update jobs in Data Loader
Use this reference to prepare, validate, test, and deploy update jobs in Data Loader.
-
Export the existing records that you want to update. Use Zuora Central Platform Data Query to retrieve the required record IDs.
-
Create a backup of the current data before you make update, so that you can recover the data if required.
-
Verify that the data complies with the Zuora Billing and Zuora Payments API validation rules, and that the CSV file uses a template format that Data Loader supports:
-
The file must be in CSV format and encoded in UTF-8.
-
The first row must contain unique, non-empty column headers.
-
The record IDs must be included for accurate updates.
-
All date fields must follow the supported formats defined in the Data Dictionary.
-
The maximum supported file size is 300 MB.
-
-
When you add prices for new currencies to an existing Product Rate Plan Charge, export the current pricing, retain the existing currency rows, add the new currency rows, and then upload the complete currency set for the charge.
-
Run the update job in a sandbox environment before you apply it to production, so that you can identify and fix any issues.
-
After successful validation, execute the update in production environment and review the status in the data loader list view page.