You can import usage data by uploading a file through the Zuora UI or by calling the Import usage file operation.
A usage file can be in comma-separated value (.csv), Microsoft Excel (.xls), or ZIP format. The maximum size of a usage file is 20 MB. If the size of a usage file exceeds 20 MB, zip the usage file before uploading it. One ZIP file can only contain one CSV or Excel file.
The name of a usage file cannot be longer than 50 characters, including the length of the file name extension.
If you have the Active Rating feature enabled, the columns you specified in the usage import file will be different from the old usage import file:
The usage file must include the following fields in CSV, Excel, or ZIP format. The ZIP file can only have one CSV or Excel file. You can specify the column fields in random order.
| Column | Description | Required? |
|---|---|---|
|
AccountNumber |
The account number, for example, A00000001. The customer account must be the subscription owner. The account number must be valid, and the account must be active. |
Yes |
|
Tag |
Specifies which subscription, charge, or account the usage record is related to. The value of this field can contain a maximum of 255 characters. The value of this field should be in the following formats:
If the value of this field is in the AccountNumber:value format, the value must be the same as the value of the AccountNumber field. If the value of this field is in the ChargeNumber:value format, the value must be the same as the value of the UnitOfMeasure field corresponding to the usage charge. The subscription number, charge number, and account number must be active, and the subscription cannot be in Draft status. The customer account must be the subscription and charge owner. |
Yes |
|
UnitOfMeasure |
The units to measure the usage consumption. The value of this field is case insensitive. |
Yes |
|
StartDateTime |
The start date and time when this usage is consumed. For example, 2017-03-14T21:32:37Z. Date format: YYYY-MM-DDTHH:MM:SS[+ -]HH:MM |
Yes |
|
Quantity |
The number of units the usage record is used. |
Yes |
|
Description |
The description of the usage record. The description can contain a maximum of 200 characters. |
No |
|
UniqueKey |
A unique key of the usage record. You can define the unique key for each usage record. This field is optional. It helps you prevent duplicate usage records created accidentally. |
No |
|
GroupId |
The group ID used for usage rating by group. Zuora groups the usage records based on the group ID when you choose the Custom Group option for usage rating. The Usage Rating by Group feature is in Limited Availability. If you wish to have access to the feature, submit a request at Zuora Global Support. |
No |
| CustomFields.field_name | The value of the custom fields. Use the custom field name to replace field_name. | No |
You can download the sample usage file and replace the sample data with your usage data in the file.
Vision