Import/Update Customers
Download import template for Customers
Required Columns
Make sure to include these columns in your upload file. Otherwise, you can't proceed to the next step properly.
- ID: If Email and Phone are not included in the upload file
- Email: If ID and Phone are not included in the upload file
- First Name
- Last Name
- Phone: If ID an Email are not included in the upload file
Available Columns
Basic Columns
Column | Description | Accepted Value | Example Value |
|---|---|---|---|
ID | A unique identifier assigned to each customer. Used to track and manage customer records within the system. | Alphanumeric text | 123456789 |
The customer's primary email address, used for communication, order tracking, and as a unique identifier. If login is required, it serves as the username. Each email must be unique within the store and is used to link orders to customers. If not provided, First Name must be filled | A valid email format | ||
First name | The given name of the customer, used for personalization and identification. If the Email field is empty, this field must be provided. If the Address First Name is missing, this value will be used for the address. | Alphabetic text | john |
Last name | The surname of the customer, used for identification and personalization. If the Address Last Name is missing, this value will be used for the address. | Alphabetic text | doe |
Phone | It must include the country code and be valid for the respective country. Each phone number must be unique, as Shopify assigns orders to customers using this field when no email is provided. When importing customers, if ID and Email are missing, the system will identify existing customers by their phone number. The + sign is optional but can help Shopify detect the country code. | Numeric text with optional special characters (+, -, (), and spaces). | (+84) 1234 567 899 |
Language | The preferred language of the customer, used for localization and communication. This field helps personalize emails, notifications, and store interactions based on the customer’s language preference. | Language code in ISO 639-1 format (e.g., en for English, fr for French). | en |
Email Marketing: Status | Indicates whether the customer has opted in to receive marketing emails. This status determines if promotional emails, newsletters, or special offers can be sent. | Predefined status values subscribed, unsubscribed, pending , invalid,not_subscribed | pending |
Email Marketing: Level | Specifies the level of email marketing consent provided by the customer, determining the type of promotional emails they receive. | Predefined values single_opt_inconfirmed_opt_inunknown | single_opt_in |
Email Marketing: Updated At | The timestamp of the last update to the customer’s email marketing subscription status. This helps track when the customer’s marketing preferences were last changed. | Date-Time format (YYYY-MM-DD HH:MM:SS), preferably in UTC. | 2024-02-07 15:30:00 |
SMS Marketing: Status | Indicates whether the customer has opted in to receive SMS marketing messagesRestrictions:SMS Marketing Status can only be updated if the current SMS Marketing Status is not_subscribed .Customer cannot update to redacted SMS Marketing Status.Customer can only be updated to pending SMS Marketing Status in combination with confirmed_opt_in SMS marketing levelCreating customer:Customer cannot be created with redacted SMS Marketing Status.Customer can be created withpending SMS Marketing Status only in combination with confirmed_opt_in SMS marketing levelCreating customers with not_subscribed SMS Marketing Status will always set SMS Marketing Level to single_opt_in no matter what is specified in the import file.Other SMS Marketing Status and Level combinations should work when creating customer. | not_subscribed – The customer hasn’t subscribed to SMS marketing.pending – The customer is in the process of subscribing to SMS marketing.redacted– The customer’s personal data is erased. This value is internally-set and read-only.subscribed – The customer is subscribed to SMS marketing.unsubscribed – The customer isn’t currently subscribed to SMS marketing but was previously subscribed. | pending |
SMS Marketing: Level | Specifies the level of consent provided by the customer for receiving SMS marketing messages | Predefined values single_opt_inconfirmed_opt_inunknownDefault: single_opt_in | single_opt_in |
SMS Marketing: Updated At | The timestamp of the last update to the customer’s SMS marketing subscription status. This helps track when the customer’s SMS marketing preferences were last changed. | Date-Time format (YYYY-MM-DD HH:MM:SS), preferably in UTC. | 2024-02-07 15:30:00 |
Note | A custom note associated with the customer, typically used for internal reference or special instructions. This field is not visible to customers. | Alphanumeric text | VIP customer – offer priority support |
Verified Email | Indicates whether the customer's email address has been verified. A verified email ensures that the customer can receive order confirmations and marketing emails. | Boolean (true or false).Default: FALSE | TRUE |
Tax Exempt | Indicates whether the customer is exempt from paying taxes on purchases. | Boolean (true or false). | TRUE |
Tags | Labels or keywords assigned to a customer for categorization, segmentation, and filtering. | Comma-separated alphanumeric text. | VIP, Repeat Customer, Wholesale |
Send Account Activation Email | Determines whether an account activation email should be sent to the customer after import | Boolean (TRUE or FALSE)Default: FALSE | TRUE |
Multipass Identifier | Enables seamless single sign-on (SSO) for users moving between an external website and a Shopify store. When users log in to the external site and navigate to the Shopify store, they are automatically logged in using the same email. If no Shopify account exists for the email, one is created. | Alphanumeric text | 123456789abcdef |
Addresses
Each customer can have multiple addresses used for shipping, with one designated as the Primary address, marked in the Address Is Default column.
All of these addresses can be both imported and exported.
Customers with multiple addresses are handled similarly to products with multiple variants: for each additional address, you’ll need to create a new row and copy the basic customer information into it. To ensure the address is linked to the correct customer, you must repeat either the ID or Email (whichever comes first). If both are missing, then at least the First Name and Last Name must be repeated. You may also duplicate any other fields if that’s more convenient.
All these address-related fields correspond to those available in the Shopify Admin when editing a customer and clicking the Change button in the Default Address card.
Column | Description | Accepted Value | Example Value |
|---|---|---|---|
Address First Name | The first name associated with the specific address, which may differ from the customer's main first name. This name will be used for shipping to this address. If left empty, the system will default to the First Name in this address row. | Alphanumeric text | John |
Address Last Name | The last name associated with the specific address, which may differ from the customer's main last name. This name will be used for shipping to this address. If left empty, the system will default to the Last Name in this address ro | Alphanumeric text | Doe |
Address Phone | The phone number associated with this shipping address. If left empty, the system will use the Phone value from this address row. The number should include the country code for better detection by the platform. | Numeric (including country code, spaces, dashes, or plus signs). | #ERROR! |
Address Company | The company name associated with the specific address. | Alphanumeric text | LitGroup |
Address Line 1 | The primary street address for the customer, typically including the house number and street name. | Alphanumeric text | 123 Main Street |
Address Line 2 | Additional address details, such as apartment, suite, unit, or building number. | Alphanumeric text | 124 Main Street |
Address City | The city associated with the customer's address | Alphanumeric text | New York |
Address Province | The state, region, or province associated with the customer's address. Platforms validates province names against its geographic classifier—invalid values will cause the customer creation to fail. | Alphanumeric text | California |
Address Province Code | The standardized code for the province, state, or region of the customer's address. If provided, the platform will use this code instead of the province name. | Alphanumeric text | CA |
Address Country | The country associated with the customer's address. Platforms validate country names against its geographic classifier—invalid values will cause customer creation to fail. | Full country name | United States |
Address Country Code | A two-letter international country code (ISO 3166-1 alpha-2) representing the customer's country. If Address Country is provided, this field can be left empty, and the platform will derive the country from it. | Two-letter country code | US |
Address Zip | The postal or ZIP code for the customer's address. It is required for certain countries and helps ensure accurate shipping and tax calculations. | Alphanumeric text | 10001 |
Address Is Default | Indicates whether this address is the default shipping or billing address for the customer. A customer can have multiple addresses, but only one can be marked as default. | Boolean (TRUE or FALSE) | TRUE |
Updated on: 01/07/2025
Thank you!