Skip to main content

Customer Fields

Shoppers who have created accounts or made purchases in your Shopify store

Updated this week

Sample File

This sample file shows the basic columns that you need to set in order to import customers to Shopify.

Download sample Customer Import File.

General

ID

Description

Example Value

Shopify's unique customer identifier

789012

If present, the ID will be used to find an existing customer on the store. When importing, the ID will be used to see if the customer already exists. If there's no ID match the app will attempt to find an existing customer using the Email.

Email

Description

Example Value

Customer's email address

The customer's email address is used as the unique identifier for the customer account. This is also used for grouping multiple rows together and finding an existing customer on the store if the ID is not present.

Command

Description

Example Value

Action to perform: MERGE, DELETE, NEW

MERGE

  • MERGE: Update existing customer or create if not found

  • DELETE: Remove the customer from the store

  • NEW: Create a new customer (will fail if customer already exists)

First Name

Description

Example Value

Customer's first name

Jane

The customer's given name.

Last Name

Description

Example Value

Customer's last name

Smith

The customer's family name or surname.

Phone

Description

Example Value

Customer's phone number

+1-555-0123

The customer's primary phone number.

Language

Description

Example Value

Customer's preferred language

en

The customer's preferred language code (e.g., en for English, fr for French).

State

Description

Example Value

Account state: ENABLED, DISABLED

ENABLED

  • ENABLED: Customer account is active and can place orders

  • DISABLED: Customer account is disabled and cannot place orders

Note

Description

Example Value

Internal notes about the customer

VIP customer

Internal notes that staff can add about the customer. These are not visible to the customer.

Tags

Description

Example Value

Comma-separated list of tags

vip, wholesale

Tags help categorize and organize customers, making them easier to find and filter.

Tags Command

Description

Example Value

Tag action: ADD, REPLACE, REMOVE

ADD

  • ADD: Add the specified tags to existing tags

  • REPLACE: Replace all existing tags with specified tags

  • REMOVE: Remove the specified tags from the customer

Tax Exempt

Description

Example Value

Whether customer is exempt from taxes

FALSE

  • TRUE: Customer is exempt from paying taxes

  • FALSE: Customer is subject to applicable taxes

Email Marketing: Status

Description

Example Value

Email marketing subscription status

SUBSCRIBED

  • SUBSCRIBED: Customer has opted in to receive marketing emails

  • NOT_SUBSCRIBED: Customer has not opted in or has unsubscribed

  • PENDING: Subscription is pending confirmation

Email Marketing: Level

Description

Example Value

Email marketing opt-in level

CONFIRMED_OPT_IN

  • SINGLE_OPT_IN: Customer signed up with single opt-in

  • CONFIRMED_OPT_IN: Customer confirmed their subscription via email

  • UNKNOWN: Opt-in level is not known

SMS Marketing: Status

Description

Example Value

SMS marketing subscription status

SUBSCRIBED

  • SUBSCRIBED: Customer has opted in to receive SMS marketing

  • NOT_SUBSCRIBED: Customer has not opted in or has unsubscribed

  • PENDING: Subscription is pending confirmation

Created At

Description

Example Value

Date and time when account was created

2023-01-15 10:00:00 -0500

The timestamp when the customer account was originally created in Shopify.

Updated At

Description

Example Value

Date and time when account was last modified

2023-06-20 15:30:00 -0500

The timestamp when the customer account was last modified or updated.

Addresses

Top Row

Description

Example Value

Whether this is the first row for this customer

TRUE

  • TRUE: This is the primary row for the customer

  • FALSE: This is a secondary row (e.g., for addresses or additional data)

Row

Description

Example Value

Row number for multi-row data

2

Used when a customer spans multiple rows (e.g., when including multiple addresses).

Address: ID

Description

Example Value

Unique identifier for the address

345678

The unique identifier for a specific address associated with the customer.

Address: Command

Description

Example Value

Action to perform: MERGE, DELETE, NEW

MERGE

  • MERGE: Update existing address or create if not found

  • DELETE: Remove the address from the customer

  • NEW: Create a new address (will fail if address already exists)

Address: First Name

Description

Example Value

First name for this address

Jane

The first name associated with this specific address.

Address: Last Name

Description

Example Value

Last name for this address

Smith

The last name associated with this specific address.

Address: Company

Description

Example Value

Company name for this address

Acme Inc

The company name associated with this address, if applicable.

Address: Phone

Description

Example Value

Phone number for this address

+1-555-0123

The phone number associated with this specific address.

Address: Line 1

Description

Example Value

Street address

123 Main St

The primary street address line.

Address: Line 2

Description

Example Value

Additional address details

Suite 100

Additional address information like apartment, suite, or unit number.

Address: City

Description

Example Value

City

New York

The city for this address.

Address: Province

Description

Example Value

State/province

New York

The state, province, or region for this address.

Address: Zip

Description

Example Value

Postal/zip code

10001

The postal or zip code for this address.

Address: Country

Description

Example Value

Country

United States

The country for this address.

Address: Is Default

Description

Example Value

Whether this is the default address

TRUE

  • TRUE: This is the customer's default address

  • FALSE: This is an additional address

First and Last Order

Total Orders

Description

Example Value

Number of orders placed

25

The total number of orders the customer has placed. This field is export-only and cannot be imported.

Total Spent

Description

Example Value

Total amount spent by customer

2499.99

The total amount the customer has spent across all orders. This field is export-only and cannot be imported.

First Order: ID

Description

Example Value

ID of customer's first order

1001

The unique identifier of the customer's first order. This field is export-only and cannot be imported.

Last Order: ID

Description

Example Value

ID of customer's most recent order

1025

The unique identifier of the customer's most recent order. This field is export-only and cannot be imported.

Activation URLs

Account Activation URL

Description

Example Value

URL for customer to activate account

https://shop.myshopify.com/account/activate/...

A secure URL that customers can use to activate their account. This field is export-only and cannot be imported.

Metafields

Metafields can be imported and exported with customers to store custom metadata and additional attributes.

For detailed information about working with metafields, see our Metafields guide.

Export Filters

You can use these filters to limit which customers are exported:

  • email: Filter by email address

  • created_at: Filter by creation date

  • updated_at: Filter by last update date

  • total_spent: Filter by total spent amount

  • orders_count: Filter by number of orders

  • tag: Filter by tag (include)

  • tag_not: Filter by tag (exclude)

Did this answer your question?