Browse by Topic

Exporting Customers

Whether you're sending your customer data to a third-party software or just making backups, the Export Tool makes it easy to export your customer information with a few clicks.

Choosing an Export Template

An export template determines specifically what customer information you're exporting. All export templates will include details like the customer's name and email address, but you can get more granular about other details. For a full list of exportable information, see the table of Exportable Fields.

BigCommerce comes with a few customer export templates built in:

  • Bulk Edit (recommended) — The bulk edit template was made for updating your customer information. It includes the majority of exportable fields, and has specifically named columns that let you skip steps in the importing process.
  • Default — The default template includes only basic product details such as name, weight, description, and price.
  • MYOB — This template is specifically for exporting to MYOB accounting software
  • Peachtree — This template is specifically for exporting to Peachtree accounting software.

You can also create a custom export template and select which of the exportable fields you want it to include.

Exporting Your Customers

1. Go to CustomersExport.

2. Select your export settings.

Export template and File Format Options

  • Template — We recommend Bulk Edit or a custom export template.
  • File Format — You can export your file as a CSV (recommended) or XML. You can only re-import CSV files, not XML or any other file type.
  • Save export to the server for later download? — Select this option to save the file to your exports folder in WebDAV (recommended for exporting 1000+ customers).

3. Click Continue, then click Export my customers to a CSV file.

Export Customers pop-up

4. When the file is ready for download, click the download link.

Download customer export pop-up

Exportable Fields

Below is a table of all customer attributes that are exportable via a CSV. The majority of these fields are included when using the Bulk Edit export template. See Custom Export Template Fields for a list of fields that do not appear in the Bulk Edit template but can be added to a custom export template.

FieldDescriptionExample
EmailThe customer's email addressjohn.smith@email.com
First NameThe customer's first nameJohn
Last NameThe customer's last nameSmith
CompanyThe company, if the customer orders on behalf of a businessAcme, Inc.
PhoneCustomer's phone number555-555-5555
NotesYour notes about the customerCustomer is tax-exempt
Store CreditUse this to apply store credit for the customer to use when shopping. (This will allow the customer to pay with store credit.)50 (uses your default currency; e.g. 50 = $50 if you are using USD)
Customer GroupAssigned customer group if using the Customer Group featureRetail
AddressesContains the following fields:
Address IDThe unique system-created ID for the addressNumber
Address First NameThe first name associated with a particular addressSarah Jane
Address Last NameThe last name associated with a particular addressSmith
Address CompanyThe company associated with a particular addressAcme, Inc.
Address Line 1The first line with an address; normally contains street and house/housing complex number123 Main St
Address Line 2The second line with an address; normally contains care of information and unit or building numberApartment 201
City/SuburbThe address' city or suburbAustin
State/ProvinceThe address' state or provinceTexas
Zip/PostcodeThe address zip or postal code78726
CountryThe address countryUnited States
Address PhoneThe phone number associated with that address555-555-5555
Address Form FieldsIf you created address form fields, your customers' responses will be included hereQuestion: Where did you hear about us? Response: Online ad
   
Form FieldsIf you created form fields, your customers' responses will be included hereQuestion: Where did you hear about us? Response: Online ad
Receive Marketing EmailsRecords whether the client opted in or out of receiving product review requests or abandoned cart emails1 = Yes, 0 = No

CUSTOM EXPORT TEMPLATE FIELDS

These fields are not exported in the Bulk Edit export template by default but can be added to a custom export template.

FieldDescriptionExample
Customer IDThe system-created unique ID for the customerNumber
Customer NameThe customer's first and last nameJohn Smith
Date JoinedThe date the customer account was created10/15/2017
Address: Address NameThe full name associated with a particular address, can be different from the customer placing the orderSarah Jane Smith
Address: State AbbreviationThe abbreviated form of the address' state or provinceTX
Address: Building TypeThe address building type (commercial or residential). Used for shipping purposes.Residential or Commercial
OrdersThe number of orders the customer has placed (exportable only)2
Tax Exempt CategoryOnly used if you have linked your paid Avalara account.See tax exempt category code

Was this article helpful?