Usage Import
You can import subscription usage CSV data for a customer only when SuiteBilling and the related features are enabled on your account. For more information, see SuiteBilling Overview.
Before you can import any subscription usage data for a customer, a subscription must exist for that customer. For more information, see Subscription Management.
Usage Fields
To prepare usage CSV data for import, make sure that your CSV file includes the following fields. They are required for a successful CSV import.
-
External ID – A unique identifier for the record. You can specify any value that has not been used as the External ID in previous CSV imports. This field is preferred but not required.
-
Subscription – Subscription the imported usage data is related to.
-
Quantity – Item quantity used.
-
Usage Date – Date on which usage occurred.
To learn about other supported fields, see Subscription Management.
Usage CSV File Example
The following table shows how you might structure a file for importing subscription usage data.
|
External ID |
Subscription |
Subscription Line |
Subscription Plan |
Item |
Quantity |
Usage Date |
|---|---|---|---|---|---|---|
|
USG001 |
Vending Services 12 Months |
7 |
Vending Service Gold |
One-Time Charge |
5 |
10/23/2015 |
|
USG002 |
Enterprise 12 Month Solution |
8 |
Enterprise Solution |
Service Item |
1 |
11/10/2015 |
|
USG003 |
Annual Maintenance |
6 |
Vending Service Gold |
Fixed Usage |
1 |
11/11/2015 |
|
USG004 |
Vending Restocking Services |
9 |
Vending Service Gold |
Usage |
6 |
11/12/2015 |
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. Select the Transactions import type and the Usage record type. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.