Importing and Exporting Customers

A customer import or export involves having all of your customer information in a CSV file, which can be edited as a spreadsheet. Whether you're moving customers to a particular customer group or adding store credit, exporting and importing customer data is a fast way to update existing customer information or add new customers in bulk.

• To export customers, you must have the Manage Customers and Export Customers permissions enabled on your user account.
• To manage export templates, you must have the Manage Export Templates permission enabled on your user account.
• To import customers, you must have the Manage Customers and Import Customers permissions enabled on your user account.
• The following fields are required when adding or updating your customers:
  • Email Address — must be unique. A customer account can only be assigned to one email address at a time.
  • First Name — customer's first name
  • Last Name — customer’s last name

1. Go to Customers › Export.

2. Select your export settings.

• Template — We recommend Bulk edit or a custom export template.
• File format — You can export your file as a CSV (recommended) or XML.
  • Note that only CSV files are eligible to be imported.
  • 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.

  

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

  

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 customer information from using certain templates. For a full list of exportable information, see the table of Supported Fields.

BigCommerce comes with built-in customer export templates:

• Bulk Edit (recommended) — Includes the majority of exportable fields, and has specifically named columns that let you skip steps in the importing process.
• Default — Includes only basic customer details, such as first name, last name, email address, phone number, and addresses.

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

Customizing your template ensures that your customer export contains the fields that best suit your business needs.

While you can create templates from scratch, we recommend using a copy of the Bulk Edit template and modifying it for your needs. This will let you bypass the settings and field mapping when you go to re-import it later.

To start, go to Settings › Export templates. Use the Action menu to Create a Copy of the Bulk Edit template.

Type a name for your template in the Template Details section. Since this template will be for customers, ensure Enable Customers Exporting is the only option selected under Export Options. The tabs listed along the top will update with your selections.

Customize the Field Formatting Options, Product Export Options, Advanced CSV Export Settings sections as needed. When you're ready, click the Customers tab at the top to view the available export fields.

Go through and check or uncheck each field as needed. Click Save & Exit when you have made your changes. You can now export your data using your new template.

The steps below will guide you through importing your customers into BigCommerce.

1. Go to Customers › Import.

2. If you exported your file using the Bulk Edit template, check the box next to to File was exported using the ‘Bulk Edit’ template. This selects the recommended settings and automatically configures the Link Import Fields step.

3. Under the File details section next to Import file, upload your CSV file directly from your computer by browsing to it.

4. You can typically leave the additional File details settings alone. They are used if you are uploading a non-spreadsheet CSV and need to specify the import settings. Click Next when done.

• Use a file already on the server — If you have a larger file or a slow internet connection, you can connect to WebDAV and save your file to the import_files folder, then select this option. Files can be up to 512 MB.
• This file contains headers — Does the file contain column headings?
• Field separator — In non-spreadsheet CSVs, what punctuation is used to separate the fields?
• Field Enclosure — In non-spreadsheet CSVs, what punctuation is used to enclose field values (such as "Socks and Shoes")?

5. Click Next for a second time if your CSV file is using the Bulk Edit template headers. Otherwise, you will need to assign your column headers to their corresponding fields before proceeding. Next to the Match field, select your CSV file's corresponding column name from the drop-down. You do not need to match every column, but you must match the required columns. Click Next when done.

6. Click Start Import when ready to begin importing your customers.

When the import is complete, you will see an import summary.

If there was an issue when importing, click More Information to see any errors generated during the import.

Passwords cannot be exported via CSV file.

To import passwords, you will need to manually add a new column to your CSV file, labeled as Password, then add your customers' passwords. Match the Password column with the password field during the Link Import Fields step.

If a customer is imported without a password, they will need to go through the password reset process.

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

Manually Added Fields

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