迁徙商店至Shopify-Transporter的客户CSV列标头有哪些??
迁徙商店至Shopify-Transporter 中的客户 CSV 列描述
客户 CSV 文件的各列描述
若要使用 Transporter 利用将客户导入 Shopify,您必要一个仅蕴含此纪录类型的 CSV 文件。。。
CSV 示例文件
您能够使用 Transporter 号令行工具天生此 CSV 文件,或者依照下文描述的体式自己创建此文件。。。
列描述
下表介绍了 CSV 文件的列标头::
| 列 | 描述 |
|---|---|
| First name | 客户的名字。。。若是既不蕴含 Email 列也不蕴含 Phone 列,则必须填写此列和 Last Name 列。。。 |
| Last name | 客户的姓氏。。。若是既不蕴含 Email 列也不蕴含 Phone 列,则必须填写此列和 First name 列。。。 |
客户的唯一电子邮件地址。。。若是 Phone 或 First Name 和 Last Name 列不存在,则必须填写此列。。。域名(例如,@mydomain.com)必须有效。。。 | |
| Company | 客户业务的名称(若是存在)。。。 |
| Address1 | 第一个地址行。。。必要使用此列来提供地址。。。例如,150 Elgin St。。。 |
| Address2 | 可选填的地址行。。。例如 Unit 202。。。 |
| City | 城市名称。。。必要使用此列来提供地址。。。例如,渥太华或柏林。。。 |
| Province | 客户地点区域(例如省、州、辖区或领地)的名称。。。若是您在此列中蕴含值,则还必须在省代码列中蕴含值。。。例如,墨西哥城、纽约或努纳武特。。。 |
| Province code | 区域(例如国度/地域的州、省、县或领土)的细分代码 (ISO 3166-2)。。。在指定 Province 列时,必须填写此列。。。ISO 3116-2 代码蕴含以下部门::
|
| Country | 客户地址地点国度/地域的名称。。。必要使用此列来提供地址。。。例如,加拿大或澳大利亚。。。 |
| Country code | 暗示客户地址地点国度/地域的两个字母 ISO 3166-1 alpha-2 代码。。。即便您指定了 Country,也请指定 Country code。。。例如,加拿大的代码为 CA,澳大利亚的代码为 AU。。。 |
| Zip | 客户地址的邮政编码。。。例如,K2P 1L4。。。 |
| Phone | 客户的唯一电话号码(E.164 体式)。。。若是既不蕴含邮箱列,也不蕴含名字和姓氏列,则必须填写此列。。?D芄话捶制缣迨绞淙氲缁昂怕,但每种体式都必须暗示能够从世界上任何处所拨通的号码。。。以下体式均有效::6135551212+16135551212(613)555-1212+1 613-555-1212 |
| Accepts Marketing | 客户是否赞成通过电子邮件接管营销资料。。。有效值::
|
| Tags | 一串以顿号分隔的标签,用于在 Shopify 后盾和店面中进行筛选和搜索。。。每个以顿号分隔的标签最多能够蕴含 255 个字符。。。例如,“忠诚、新客户、营销”。。。 |
| Note | 有关客户的备注。。。例如,“此客户所下订单有诓骗忠告”或“Harry 喜欢粉色”。。。 |
| Tax Exempt | 客户的订单是否免税。。。有效值::
|
| Metafield Namespace | 一组元字段的容器。。。若要导入元字段,您必要蕴含所有 4 个元字段列(Metafield Namespace、Metafield Key、Metafield Value 和 Metafield Value Type)中的值。。。您应该为元字段界说自界说定名空间以分辨利用和 Shopify 使用的利用(蕴含默认的 global)。。。最大长度::20 个字符。。。 |
| Metafield Key | 元字段的名称。。。最大长度::30 个字符。。。若是蕴含其他元字段列,则必须填写此列。。。 |
| Metafield Value | 要存储为元数据的信息。。。蕴含其他元字段列时必须填写此列。。。 |
| Metafield Value Type | 元字段的信息类型。。。有效值::
|
Shopify商户官网原文详情::
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:
Column Description First name The first name of the customer. This column and the Last Namecolumn are required if neither thePhonecolumns are included.Last name The last name of the customer. This column and the First namecolumn are required if neither thePhonecolumns are included.The unique email address of the customer. This column is required if the Phoneor theFirst NameandLast Namecolumns are not present. The domain (for example, @mydomain.com) needs to be valid.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, 150 Elgin St.Address2 The optional address line. For example, Unit 202.City The name of the city. This column is required for an address. For example, OttawaorBerlin.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 Codecolumn. For example,Mexico city,New York, orNunavut.Province code The 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 the Provincecolumn. An ISO 3166-2 code has the following parts: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)21
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.
Country The name of the country of the customer address. This column is required for an address. For example, CanadaorAustralia.Country code The two-letter ISO 3166-1 alpha-2 code for the country of the customer address. Specify the Country codeeven when you specifyCountry. For example,CAfor Canada andAUfor Australia.Zip The zip, postal code, or postcode of the customer address. For example, K2P 1L4.Phone The unique phone number in E.164 format for the customer. This column is required if neither the First 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 Marketing Whether the customer has consented to receive marketing material via email. Valid values: Values are case sensitive.
yes- The customer has agreed to receive marketing material.
no- The customer hasn't agreed to receive marketing material. This is the default value.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, "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: Values are case sensitive.
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.Metafield Namespace A container for a set of metafields. 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 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: Values are case sensitive. This column is required when other metafield columns are included.
string
integer
json_string
文章内容起源::Shopify商户官方网站