Importing your customers is the fastest way to add or update their information in bulk. A customer import involves having all of your customer information in a CSV file, which can be edited as a spreadsheet. Upon import, your column headers will be matched with their corresponding customer fields in BigCommerce, and the customer information will be updated accordingly.
Creating an Import Template
Whether you are adding new customers or updating your existing customers, we recommend exporting your customers using the Bulk Edit template. This template will provide you with the same column headers used by BigCommerce, which will streamline the update process. You can also create a custom import template by making a copy of the Bulk Edit template.
The following fields are required when adding or updating your customers.
- Email Address — no two can be the same. A customer’s account can only be assigned to one at a time.
- First Name — customer's first name
- Last Name — customer’s last name
Did you know? Abbreviations will cause an address failure at checkout. If entering a customer’s address information, the state or province must be spelled out, not abbreviated. (For example, use California, not CA.)
Importing Your Customers
The steps below will guide you through importing your customers into BigCommerce.
Before beginning, make sure that you have a backup (an unedited Bulk Edit export) of your customers so that you can put things back to how they were should things go awry.
1. Go to Customers › Import.
2. If you exported your file using the Bulk Edit template, check Bulk Edit Re-import, which selects the recommended settings and automatically configures the Match Import Fields step.
Did you know? If you do not use the Bulk Edit template column names, you will need to match your CSV's columns to their corresponding fields.
3. Under the File Details section next to Import File, upload your CSV file directly from your computer by browsing to it.
Attempting to upload too large a file can cause the import to fail. If your file is larger than 512 MB, try breaking it up into smaller files.
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.
- 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.
- 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 tie phrases together (e.g. "Socks and Shoes")?
5. Click Next when done.
6. Click Next when done.
7. Click Start Import when ready to begin importing your products.
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.
Be careful! If a customer is imported without a password, they will need to go through the password reset process.
Matching Import Fields
Next, to Match (field), select your CSV's corresponding column name from the drop-down. You do not need to match every column, but you must match the required columns.
Table of Importable Fields
Below is a table of all fields that are importable via the CSV. The field names are those used in the Bulk Edit Template. Fields in bold are required.
You can create a Password column to import customer passwords. During the Match Import Fields, you will have to match the Password field with the Password column manually. Passwords are not exportable.
|Field||Column in Excel (Bulk Edit)||Description||Format|
|Email address||A||Your customer’s email address; no two can be the same, and a customer’s account can only be assigned to one at a firstname.lastname@example.org|
|First Name||B||Your customer's first name||Text|
|Last Name||C||Your customer’s last name||Text|
|Company||D||Your customer's company (if business order)||Text|
|Phone||E||Your customer's phone number||Numeric|
|Notes||F||Your notes about the customer||Text|
|Store Credit||G||The amount of [store credit] you want the customer to have available|
|Customer Group||H||The [customer group] to which the customer is assigned||Name of customer group|
|Address ID - 1||I||The system-generated ID for an address in the customer's address book|
|Address First Name - 1||J||The first name that appears in the saved address||Text|
|Address Last Name - 1||K||The last name that is displayed in the saved address||Text|
|Address Company - 1||L||The company (if any) listed in the saved address||Text|
|Address Line 1 - 1||M||The first address line in the saved address||E.g. 1234 Main St|
|Address Line 2 - 1||N||The second address line in the saved address||E.g. Apt. #3|
|Address City - 1||O||The city in the saved address||E.g. Austin|
|Address State - 1||P||The state in the saved address||Must be spelled out – E.g. Texas (not TX)|
|Address Zip - 1||Q||The zip or postal code in the saved address||E.g. 78787|
|Address Country - 1||R||The country in the saved address||E.g. United States|
|Address Phone - 1||S||The phone number associated with the saved address||E.g. 555-555-5555 (can be any format)|
|Password||Manually entered||Your customer’s password; you can import passwords but not export them||Alphanumeric|
|Tax Exempt Category||Manually entered||Only used if you have linked your paid Avalara account||Alphanumeric|
|Receive Review/Abandoned Cart Emails?||BA||Should marketing emails such as product review requests be sent to this customer?||1 (Yes), 0 (No)|
You can add additional addresses by changing the 1 in the column (e.g. Address First Name - 1) to 2 or more. All addresses will appear in the customer's address book, but there is no distinction between billing or shipping addresses