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.
Store Credit
Store credit allows you to issue credit amounts to customers that they can use for future purchases. Each customer can have multiple store credit accounts in different currencies.
Store Credit: Amount
Description | Example Value |
Target balance for the store credit account |
|
The target balance amount for the customer's store credit account in the specified currency. When importing, the system will credit or debit the account to reach this exact amount.
Store Credit: Adjust
Description | Example Value |
Amount to credit (positive) or debit (negative) |
|
The adjustment amount to apply to the store credit account:
Positive values (e.g.,
25.00): Credit the account by this amountNegative values (e.g.,
-15.50): Debit the account by this amount
If both Amount and Adjust have values, the Adjust value will be used and the Amount value will be ignored.
Store Credit: Currency
Description | Example Value |
Currency code for the store credit account |
|
The three-letter currency code (ISO 4217) for the store credit account. Each customer can have separate store credit accounts for different currencies. Defaults to the store's currency code.
Note: If no store credit account exists for the specified currency, Shopify will automatically create one with a starting balance of 0 when the first credit operation is performed.
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)