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 |
|
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
.
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: 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 |
|
The customer's given name.
Last Name
Description | Example Value |
Customer's last name |
|
The customer's family name or surname.
Phone
Description | Example Value |
Customer's phone number |
|
The customer's primary phone number.
Language
Description | Example Value |
Customer's preferred language |
|
The customer's preferred language code (e.g., en
for English, fr
for French).
State
Description | Example Value |
Account state: ENABLED, DISABLED |
|
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 |
|
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 |
|
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 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 |
|
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: 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 |
|
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: 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 |
|
The timestamp when the customer account was originally created in Shopify.
Updated At
Description | Example Value |
Date and time when account was last modified |
|
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: 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 |
|
Used when a customer spans multiple rows (e.g., when including multiple addresses).
Address: ID
Description | Example Value |
Unique identifier for the address |
|
The unique identifier for a specific address associated with the customer.
Address: Command
Description | Example Value |
Action to perform: MERGE, DELETE, NEW |
|
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 |
|
The first name associated with this specific address.
Address: Last Name
Description | Example Value |
Last name for this address |
|
The last name associated with this specific address.
Address: Company
Description | Example Value |
Company name for this address |
|
The company name associated with this address, if applicable.
Address: Phone
Description | Example Value |
Phone number for this address |
|
The phone number associated with this specific address.
Address: Line 1
Description | Example Value |
Street address |
|
The primary street address line.
Address: Line 2
Description | Example Value |
Additional address details |
|
Additional address information like apartment, suite, or unit number.
Address: City
Description | Example Value |
City |
|
The city for this address.
Address: Province
Description | Example Value |
State/province |
|
The state, province, or region for this address.
Address: Zip
Description | Example Value |
Postal/zip code |
|
The postal or zip code for this address.
Address: Country
Description | Example Value |
Country |
|
The country for this address.
Address: Is Default
Description | Example Value |
Whether this is the default address |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 addresscreated_at
: Filter by creation dateupdated_at
: Filter by last update datetotal_spent
: Filter by total spent amountorders_count
: Filter by number of orderstag
: Filter by tag (include)tag_not
: Filter by tag (exclude)