Customer CSV column descriptions
Descriptions of the columns for the customers CSV file.
To import customers into Shopify using the Transporter app, you need a CSV file that contains only this record type.
CSV sample file
Download a sample customer CSV file: customers.csv.
You can use the Transporter command-line tool to generate this CSV file or you can follow the format described below to create it yourself.
The following table describes the column headers for the CSV file:
||The first name of the customer. This column and the
|Last name||The last name of the customer. This column and the
|The unique email address of the customer. This column is required if the
|Company||The name of the customer's business, if one exists.|
|Address1||The first address line. This column is required for an address. For example,
|Address2||The optional address line. For example,
|City||The name of the city. This column is required for an address. For example,
|Province||The name of the region (such as the province, state, prefecture, or territory), where the customer is located. If you include a value for this column, then you must also include a value for the
|Province code||This column is required when you specify the
|Country||The name of the country of the customer address. This column is required for an address. For example,
|Country code||Specify the
|Zip||The zip, postal code, or postcode of the customer address. For example, K2P 1L4.|
The unique phone number (E.164 format) for the customer. This column is required if neither the
A phone number can be formatted using different formats, but each format must represent a number that can be dialed from anywhere in the world. The following formats are all valid:
|Accepts Marketing||Whether the customer has consented to receive marketing material via email. Valid values:
|Tags||A string of comma-separated tags that are used for filtering and search in your Shopify admin and in your storefront. Each comma-separated tag can have up to 255 characters. For example,
|Note||A note about the customer. For example,
|Tax Exempt||Whether the customer is exempt from paying taxes on their order. Valid values:
|Metafield Namespace||A container for a set of metafields. To import metafields, you need to include values in all 4 metafield columns (
|Metafield Key||The name of the metafield. Maximum length: 30 characters. This column is required when other metafield columns are included.|
|Metafield Value||The information to be stored as metadata. This column is required when other metafield columns are included.|
|Metafield Value Type||The metafield's information type. Valid values:
The name of your CSV file needs to include the word
customer (name of the object type that it contains). For example, mycustomers.csv. The file needs to be in UTF-8 format.
A customer can be uniquely identified by one of the following:
Your CSV file must contain these unique identifier columns.
If your customer has multiple addresses, then create a row for each additional address.
In the customer row, enter the customer's default address.
In each additional address row, include the customer's unique identifier, which is either their
Phone Number, or
First Name and
Last Name combination.
Additional addresses cannot have separate names associated with them. The first and last name of the customer applies to all addresses. Additional phone numbers can be added for each additional address (provided that you aren't using the phone number as the customer's unique identifier).