Migrate your store to Shopify – Customer CSV column descriptions in Transporter
Descriptions of columns in the Customer 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
You can generate this CSV file using the Transporter command-line tool, or create it yourself using the format described below.
Column descriptions
The following table describes the column headers for the CSV file:
Column descriptionsFirst nameThe customer’s first name. If neither the Email nor the Phone column is included, this column and the Last Name column are required.Last nameThe customer’s last name. If neither the Email nor the Phone column is included, this column and the First name column are required.EmailThe customer’s unique email address. If the Phone or First Name and Last Name columns do not exist, this column is required.The domain name (for example, @mydomain.com) must be valid.CompanyThe name of the customer’s business, if it exists.Address1The first address line. This column is required to provide an address. For example, 150 Elgin St. Address2Optional address row. For example, Unit 202. CityName of the city. This column is required to provide the address. For example, Ottawa or Berlin. ProvinceName of the region (such as the province, state, jurisdiction, or territory) where the customer is located. If you include a value in this column, you must also include a value in the Province code column. For example, Mexico City, New York, or Nunavut. Province codeISO 3166-2 subdivision code for the region (such as the state, province, county, or territory of a country). This column is required when the Province column is specified. ISO 3116-2 codes have the following parts:
2-character country code – do not include this part.
Hyphen (-) to separate the two parts of the code – do not include the hyphen.
1- to 3-character subdivision code – include only this part.
ISO 3166-2 subdivision codeProvince codeMX-MEX (Mexico City, Mexico)MEXUS-NY (New York, USA)NYAR-B (Buenos Aires, Argentina)BFR-21 (Cordoba, France)21CountryThe name of the country where the customer’s address is located. This column is required to provide the address. For example, Canada or Australia.Country codeThe two-letter ISO 3166-1 alpha-2 code for the country where the customer’s address is located. Specify the Country code even if you specify Country. For example, the code for Canada is CA and the code for Australia is AU.ZipThe postal code for the customer’s address. For example, K2P 1L4.PhoneThe customer’s unique phone number (in E.164 format). This column is required if you include neither the Email address column nor the First and Last Name columns. Phone numbers can be entered in different formats, but each format must represent a number that can be dialed from anywhere in the world. The following formats are all valid:6135551212+16135551212(613)555-1212+1 613-555-1212Accepts MarketingWhether the customer has consented to receive marketing materials via email. Valid values:
yes- The customer has consented to receive marketing materials.
no- The customer has not consented to receive marketing materials. This is the default value.
Values are case-sensitive. TagsA comma-delimited string of tags used for filtering and searching in the Shopify admin and storefront. Each comma-delimited tag can contain up to 255 characters. For example, “loyal, new customer, marketing”. NoteA note about the customer. For example, “This customer has placed an order with a fraud alert” or “Harry likes the color pink”. Tax ExemptWhether the customer’s orders are tax-exempt. Valid values:
yes- Taxes will not be charged to the customer’s orders at checkout.
no- Taxes will be charged to the customer’s orders at checkout. This is the default value.
Values are case-sensitive. Metafield NamespaceContainer for a set of metafields. To import metafields, you need to include values from all 4 metafield columns (Metafield Namespace, Metafield Key, Metafield Value, and Metafield Value Type). You should define custom namespaces for metafields to distinguish between your app and the ones used by Shopify (including the default global). Maximum length: 20 characters. Metafield KeyThe name of the metafield. Maximum length: 30 characters. Required if you include other metafield columns. Metafield ValueThe information to store as metadata. Required if you include other metafield columns. Metafield Value TypeThe type of information for the metafield. Valid values:
string
integer
json_string
Values are case-sensitive. Required if you include other metafield columns.
Shopify Merchant Official Website Original Details:
Customer CSV column descriptions in Transporter
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
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.
Column descriptions
The following table describes the column headers for the CSV file:
ColumnDescriptionFirst nameThe first name of the customer. This column and theLast Namecolumn are required if neither theEmailnor thePhonecolumns are included.Last nameThe last name of the customer. This column and theFirst namecolumn are required if neither theEmailnor thePhonecolumns are included.EmailThe unique email address of the customer. This column is required if thePhoneor theFirst NameandLast Namecolumns are not present. The domain (for example,@mydomain.com) needs to be valid.CompanyThe name of the customer’s business, if one exists.Address1The first address line. This column is required for an address. For example,150 Elgin St.Address2The optional address line. For example,Unit 202.CityThe name of the city. This column is required for an address. For example,OttawaorBerlin.ProvinceThe 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 theProvince Codecolumn. For example,Mexico city,New York, orNunavut.Province codeThe subdivision assigned code (ISO 3166-2) for the region, such as the state, province, prefecture, or territory, in the country. This column is required when you specify theProvincecolumn. An ISO 3166-2 code has the following parts:
2-character country code – do not include this part.
hyphen (-) that separates the two parts of the code – do not include the hyphen.
1-to-3-character subdivision code – include this part only.
ISO 3166-2 subdivision codeProvince codeMX-MEX (Mexico City, Mexico)MEXUS-NY (New York, United States)NYAR-B (Buenos Aires, Argentina)BFR-21 (C?te-d'Or, France)21CountryThe name of the country of the customer address. This column is required for an address. For example,CanadaorAustralia.Country codeThe two-letterISO 3166-1 alpha-2 codefor the country of the customer address. Specify theCountry codeeven when you specifyCountry. For example,CAfor Canada andAUfor Australia.ZipThe zip, postal code, or postcode of the customer address. For example,K2P 1L4.PhoneThe unique phone number in E.164 format for the customer. This column is required if neither theEmailcolumn nor theFirst nameandLast namecolumns are included. A phone number can be entered 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:6135551212+16135551212(613)555-1212+1 613-555-1212Accepts MarketingWhether the customer has consented to receive marketing material via email. Valid values:
yes- The customer has agreed to receive marketing material.
no- The customer hasn't agreed to receive marketing material. This is the default value.
Values are case sensitive.TagsA 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,"Loyal, New customer, Marketing.Note A note about the customer. For example,"This customer placed an order that had a fraud warning"or"Harry loves the color pink".Tax Exempt Whether the customer is exempt from paying taxes on their order. Valid values:
yes- Taxes won't be charged to the customer's orders at checkout.
no- Taxes will be charged to the customer's orders at checkout. This is the default value.
Values are case sensitive.Metafield Namespace A container for a set ofmetafields. To import metafields, you need to include values in all 4 metafield columns (Metafield Namespace,Metafield Key,Metafield Value, andMetafield Value Type). You should define a custom namespace for your metafields to distinguish them from namespaces used by apps and Shopify (including the defaultglobal). Maximum length: 20 characters.Metafield KeyThe name of the metafield. Maximum length: 30 characters. This column is required when other metafield columns are included.Metafield ValueThe information to be stored as metadata. This column is required when other metafield columns are included.Metafield Value TypeThe metafield’s information type. Valid values:
string
integer
json_string
Values are case sensitive. This column is required when other metafield columns are included.
Article content source: Shopify merchant official website