Best practices for Import job in a Zuora Tenant
- The import file should be a CSV, UTF-8 format
- Ensure that the file does not contain duplicate or empty headers.
- The first row of the file should contain column headers.
- Ensure that all the date fields are rightly formatted.
- A maximum file size of 1GB is allowed.
- Make sure that the ‘IsMarker’ Column is mapped right when importing records in a nested object. For example, Standalone Invoices, Payment Schedules, Price Book Items etc.
- When loading records in Accounts and Contact, please do the following:
- Change the associated communication profile for ‘Migration’ to ‘Silent’.
- Change the Batch to a Batch that is created for migration
- Accounts and Contact will be created in Active state