You can export customer data using the built-in functionality available alongside the search capabilities of the Control Panel.
Both customer details and subscription data are included in the .CSV (comma-separated values) files that you can export. Essentially, information on single or multiple subscriptions acquired by the same customer is included in the .CSV file.
Optionally, you can also include the renewal price for customer licenses.
Note: You can only search for customers that have at least one subscription attached. Customers that were created via API (that are not tied to a subscription) cannot be found in the Control Panel Customers search.
Follow the steps below to generate a customer export file.
- Log in to the 2Checkout Control Panel.
- Go to Orders & customers -> Customers.
- Use the existing filters to search for the customer you want to export data for.
- Click Export as CSV.
- Choose whether or not to include the renewal price for customer licenses.
- Click Export.
The table below shows the fields included in customer exports.
|AvangateCustomerReference||System generated customer reference number in the 2Checkout system|
|ExternalCustomerReference||External customer reference that you control|
|CustomerFirstName||Billing first name|
|CustomerLastName||Billing last name|
|CustomerEmail||Billing email address|
|CustomerPhone||Customer phone number|
|CustomerFax||Customer fax number|
|CustomerAddress1||Customer address field|
|CustomerAddress2||Customer address field|
|CustomerZip||Customer zip code|
|CustomerCompany||Customer company name|
|LicenseUniqueId||Subscription ID that you control|
|IdProduct||Unique system generated product ID|
|PurchaseDate||Subscription purchase date|
|ExpirationDate||Subscription expiration date|
|FirstName||Delivery first name|
|LastName||Delivery last name|
|Delivery email address|
|CommunicationLanguage||Language selected in the shopping cart upon purchase|
|ProductVersion||Purchased product version|
|Company||Business customer company name|
|Phone||Business customer phone number|
|Fax||Business customer fax number|
|Address1||Delivery address field|
|Address2||Delivery address field|
|Zip||Delivery zip code|
|CountryCode||ISO country code|
|ProductOptions||Product pricing options|
|ActivationCode||Subscription activation code|
|IdPartner||Partner ID (if the order was placed by a reseller)|
|LicenseCode||Unique system generated subscription code|
|Refno||Order reference number|
Subscription renewal type:
|URL||Merchant homepage URL|
|NextRenewalPrice||Renewal price for the next billing cycle|
|NextRenewalPriceCurrency||Currency of the next renewal price|
|TimeZone||Your account time zone|
|ShopperReferenceNumber||Shopper reference number for orders placed by resellers. Can be used in searches for customers, subscriptions and orders.|
|AdditionalInfo||Extra information that you can attach to a subscription, such as the source of the initial purchase.|
|PastDueDay(s)||Number of days passed since the subscription reached Past Due status|
Indicates test orders:
|SubscriptionStartDate||Subscription generation start date|
Unique affiliate identifier from the 2Checkout platform. Possible values:
|CustomerValue||High level guideline for the overall business value of a customer. Calculated based on the completed orders placed by the customer. Test orders are not considered.|
|CustomerValueCurrency||Currency of the customer value.|