Customers
Create and update BigCommerce customers using Shift.
Quick start
The best way to get started is to run an export and use the file as a guide to the format required.
However, you can also download the category 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. |
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:
To set the customer's password, use:
|
| 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 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. |
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 to only include:
- Specific customers
- Specific customer groups
[insert image]
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
[insert image]