Customers template

Create and update BigCommerce customers using Shift.

tip

Check out our step-by-step guides for how to import & export.

Quick start

The best way to get started is to run an export and use the file as a guide to the format required.

You can also download the customer template.

Import & export columns

Basic columns

Column	Description
ID	This is the unique identifier provided by BigCommerce for existing customers. It's unique per BigCommerce store. This field is required to update existing customers. It is a read-only field.
Email	The email of the customer This must be unique.
First Name	The first name of the customer
Last Name	The last name of the customer
Phone	The phone number of the customer
Customer Group ID	The ID of the customer group to which they belong.
Company	The company of the customer
Registration IP Address	The IP address from which this customer was registered. It can be sent when creating customers but cannot be updated on existing customers.
Notes	The customer notes.
Tax Exempt Category	The tax-exempt code
Date Modified	When the customer was last updated
Date Created	When the customer was created
Address Count	The total number of customer addresses
Attribute Count	The total number of customer attributes
Authentication	Uses to force a customer to reset their password on next login, or to set a specific password. To force the customer to change their password on next login, use: {"force_password_reset":true} Shift does not support setting a specific customer password at this time due to security concerns. Should you require this feature, please get in touch.
Addresses	Support coming soon
Form Fields	Support coming soon
Store Credit Amounts	Support coming soon
Accepts Product Review Abandoned Cart Email	Whether the customer is subscribed to product review or abandoned cart emails
Original Channel ID	The channel that the customer was created in. This can only be set when the customer is created
Channel IDs	This is the list of channels that a customer can log into.

Metafield columns

Fields

Description

{namespace}.{key}

You can create and update customer metafields by adding a column named after the metafield namespace and metafield key separated by a .. If the metafield already exists for the customer, it will be updated, otherwise, it will be created. The metafield namespace and key each must be fewer than 65 characters. Metafield values can be up to 65,535 characters long. An empty string or a string with only whitespace is not a valid metafield value. All metafields will be created with write and storefront access permissions so they can be queried via the storefront GraphQL API.

info

As we don't know the names of metafields in advance, you can only select all metafields when exporting.

Export filters

You can filter customer exports by:

• Specific customers
• Company (text match)
• Customer group
• Date created
• Date updated
• Name

info

As you reduce the number of items in your export, or change what data should be included, the estimate of the number of records and duration of the export will be updated.