Customers

Create and update BigCommerce customers using Shift.

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.

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.

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}

To set the customer's password, use:

{"new_password": "password123}

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.

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]

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us