ÈËÉú¾ÍÊDz©¡¤(Öйú)×ðÁúAGÆì½¢Ìü

ÈËÉú¾ÍÊDz©¡¤(Öйú)×ðÁúAGÆì½¢Ìü(LianLian Global)¹ÙÍøÊ×Ò³

ǨáãÊÐËÁÖÁShopify-TransporterµÄ¿Í»§CSVÁбêÍ·ÓÐÄÄЩ£¿£¿£¿£¿£¿

2021/11/23

ǨáãÊÐËÁÖÁShopify-Transporter ÖеĿͻ§ CSV ÁÐÐÎò

¿Í»§ CSV ÎļþµÄ¸÷ÁÐÐÎò

ÈôҪʹÓà Transporter Ó¦Óý«¿Í»§µ¼Èë Shopify£¬£¬ £¬£¬£¬ÄúÐèÒªÒ»¸ö½ö°üÀ¨´Ë¼Í¼ÀàÐ굀 CSV Îļþ¡£¡£¡£¡£¡£¡£¡£

CSV ʾÀýÎļþ

Äú¿ÉÒÔʹÓà Transporter ÏÂÁîÐй¤¾ßÌìÉú´Ë CSV Îļþ£¬£¬ £¬£¬£¬»òÕ߯¾Ö¤ÏÂÎÄÐÎòµÄÃûÌÃ×Ô¼º½¨Éè´ËÎļþ¡£¡£¡£¡£¡£¡£¡£

ÁÐÐÎò

ϱíÏÈÈÝÁË CSV ÎļþµÄÁбêÍ·£º

ÁÐÐÎò
First name¿Í»§µÄÃû×Ö¡£¡£¡£¡£¡£¡£¡£ÈôÊǼȲ»°üÀ¨ Email ÁÐÒ²²»°üÀ¨ Phone ÁУ¬£¬ £¬£¬£¬Ôò±ØÐèÌîд´ËÁк͠Last Name ÁС£¡£¡£¡£¡£¡£¡£
Last name¿Í»§µÄÐÕÊÏ¡£¡£¡£¡£¡£¡£¡£ÈôÊǼȲ»°üÀ¨ Email ÁÐÒ²²»°üÀ¨ Phone ÁУ¬£¬ £¬£¬£¬Ôò±ØÐèÌîд´ËÁк͠First name ÁС£¡£¡£¡£¡£¡£¡£
Email¿Í»§µÄΨһµç×ÓÓʼþµØµã¡£¡£¡£¡£¡£¡£¡£ÈôÊÇ Phone »ò First Name ºÍ Last Name Áв»±£´æ£¬£¬ £¬£¬£¬Ôò±ØÐèÌîд´ËÁС£¡£¡£¡£¡£¡£¡£ÓòÃû£¨ÀýÈ磬£¬ £¬£¬£¬@mydomain.com£©±ØÐèÓÐÓᣡ£¡£¡£¡£¡£¡£
Company¿Í»§ÓªÒµµÄÃû³Æ£¨ÈôÊDZ£´æ£©¡£¡£¡£¡£¡£¡£¡£
Address1µÚÒ»¸öµØµãÐС£¡£¡£¡£¡£¡£¡£ÐèҪʹÓôËÁÐÀ´ÌṩµØµã¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬150 Elgin St¡£¡£¡£¡£¡£¡£¡£
Address2¿ÉÑ¡ÌîµÄµØµãÐС£¡£¡£¡£¡£¡£¡£ÀýÈç Unit 202¡£¡£¡£¡£¡£¡£¡£
City¶¼»áÃû³Æ¡£¡£¡£¡£¡£¡£¡£ÐèҪʹÓôËÁÐÀ´ÌṩµØµã¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬ä×Ì«»ª»ò°ØÁÖ¡£¡£¡£¡£¡£¡£¡£
Province¿Í»§ËùÔÚÇøÓò£¨ÀýÈçÊ¡¡¢ÖÝ¡¢Ï½Çø»òÁìµØ£©µÄÃû³Æ¡£¡£¡£¡£¡£¡£¡£ÈôÊÇÄúÔÚ´ËÁÐÖаüÀ¨Öµ£¬£¬ £¬£¬£¬Ôò»¹±ØÐèÔÚÊ¡´úÂëÁÐÖаüÀ¨Öµ¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬Ä«Î÷¸ç³Ç¡¢Å¦Ô¼»òŬÄÉÎäÌØ¡£¡£¡£¡£¡£¡£¡£
Province codeÇøÓò£¨ÀýÈç¹ú¼Ò/µØÇøµÄÖÝ¡¢Ê¡¡¢ÏØ»òÁìÍÁ£©µÄϸ·Ö´úÂë (ISO 3166-2)¡£¡£¡£¡£¡£¡£¡£ÔÚÖ¸¶¨ Province ÁÐʱ£¬£¬ £¬£¬£¬±ØÐèÌîд´ËÁС£¡£¡£¡£¡£¡£¡£ISO 3116-2 ´úÂë°üÀ¨ÒÔϲ¿·Ö£º
  • 2 ¸ö×Ö·ûµÄ¹ú¼Ò/µØÇø´úÂë - ÇëÎð°üÀ¨´Ë²¿·Ö¡£¡£¡£¡£¡£¡£¡£

  • ÓÃÓÚÍÑÀë´úÂëÁ½¸ö²¿·ÖµÄÁ¬×Ö·û (-) - ÇëÎð°üÀ¨Á¬×Ö·û¡£¡£¡£¡£¡£¡£¡£

  • 1 µ½ 3 ¸ö×Ö·ûµÄϸ·Ö´úÂë - ½ö°üÀ¨´Ë²¿·Ö¡£¡£¡£¡£¡£¡£¡£

ISO 3166-2 ϸ·Ö´úÂëÊ¡´úÂëMX-MEX£¨Ä«Î÷¸ç³Ç£¬£¬ £¬£¬£¬Ä«Î÷¸ç£©MEXUS-NY£¨ÃÀ¹úŦԼ£©NYAR-B£¨°¢¸ùÍ¢²¼ÒËŵ˹°¬Àû˹£©BFR-21£¨·¨¹ú¿Æ¶û¶àÊ¡£¡£¡£¡£¡£¡£¡£©21
Country¿Í»§µØµãËùÔÚ¹ú¼Ò/µØÇøµÄÃû³Æ¡£¡£¡£¡£¡£¡£¡£ÐèҪʹÓôËÁÐÀ´ÌṩµØµã¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬¼ÓÄôó»ò°Ä´óÀûÑÇ¡£¡£¡£¡£¡£¡£¡£
Country codeÌåÏÖ¿Í»§µØµãËùÔÚ¹ú¼Ò/µØÇøµÄÁ½¸ö×Öĸ ISO 3166-1 alpha-2 ´úÂë¡£¡£¡£¡£¡£¡£¡£×ÝÈ»ÄúÖ¸¶¨ÁË Country£¬£¬ £¬£¬£¬Ò²ÇëÖ¸¶¨ Country code¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬¼ÓÄôóµÄ´úÂëΪ CA£¬£¬ £¬£¬£¬°Ä´óÀûÑǵĴúÂëΪ AU¡£¡£¡£¡£¡£¡£¡£
Zip¿Í»§µØµãµÄÓÊÕþ±àÂë¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬K2P 1L4¡£¡£¡£¡£¡£¡£¡£
Phone¿Í»§µÄΨһµç»°ºÅÂ루E.164 ÃûÌã©¡£¡£¡£¡£¡£¡£¡£ÈôÊǼȲ»°üÀ¨ÓÊÏäÁУ¬£¬ £¬£¬£¬Ò²²»°üÀ¨Ãû×ÖºÍÐÕÊÏÁУ¬£¬ £¬£¬£¬Ôò±ØÐèÌîд´ËÁС£¡£¡£¡£¡£¡£¡£¿£¿£¿£¿£¿ÉÒÔ°´²î±ðÃûÌÃÊäÈëµç»°ºÅÂ룬£¬ £¬£¬£¬µ«Ã¿ÖÖÃûÌö¼±ØÐèÌåÏÖ¿ÉÒÔ´ÓÌìÏÂÉÏÈκεط½²¦Í¨µÄºÅÂë¡£¡£¡£¡£¡£¡£¡£ÒÔÏÂÃûÌþùÓÐÓãº
6135551212
+16135551212
(613)555-1212
+1 613-555-1212
Accepts Marketing¿Í»§ÊÇ·ñÔÞ³Éͨ¹ýµç×ÓÓʼþÎüÊÕÓªÏúÖÊÁÏ¡£¡£¡£¡£¡£¡£¡£ÓÐÓÃÖµ£º
  • yes - ¿Í»§ÒÑÔÞ³ÉÎüÊÕÓªÏúÖÊÁÏ¡£¡£¡£¡£¡£¡£¡£

  • no - ¿Í»§ÉÐδÔÞ³ÉÎüÊÕÓªÏúÖÊÁÏ¡£¡£¡£¡£¡£¡£¡£´ËΪĬÈÏÖµ¡£¡£¡£¡£¡£¡£¡£

ÖµÇø·Ö¾Þϸд¡£¡£¡£¡£¡£¡£¡£
TagsÒ»´®ÒÔ¶ÙºÅÍÑÀëµÄ±êÇ©£¬£¬ £¬£¬£¬ÓÃÓÚÔÚ Shopify ºǫ́ºÍµêÃæÖоÙÐÐɸѡºÍËÑË÷¡£¡£¡£¡£¡£¡£¡£Ã¿¸öÒÔ¶ÙºÅÍÑÀëµÄ±êÇ©×î¶à¿ÉÒÔ°üÀ¨ 255 ¸ö×Ö·û¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬¡°ÖÒʵ¡¢Ð¿ͻ§¡¢ÓªÏú¡±¡£¡£¡£¡£¡£¡£¡£
NoteÓйؿͻ§µÄ±¸×¢¡£¡£¡£¡£¡£¡£¡£ÀýÈ磬£¬ £¬£¬£¬¡°´Ë¿Í»§Ëù϶©µ¥ÓÐڲƭÖÒÑÔ¡±»ò¡°Harry ϲ»¶·ÛÉ«¡±¡£¡£¡£¡£¡£¡£¡£
Tax Exempt¿Í»§µÄ¶©µ¥ÊÇ·ñÃâ˰¡£¡£¡£¡£¡£¡£¡£ÓÐÓÃÖµ£º
  • yes - ½áÕËʱ²»»áÏò¿Í»§µÄ¶©µ¥ÊÕȡ˰·Ñ¡£¡£¡£¡£¡£¡£¡£

  • no - ½áÕËʱ»áÏò¿Í»§µÄ¶©µ¥ÊÕȡ˰·Ñ¡£¡£¡£¡£¡£¡£¡£´ËΪĬÈÏÖµ¡£¡£¡£¡£¡£¡£¡£

ÖµÇø·Ö¾Þϸд¡£¡£¡£¡£¡£¡£¡£
Metafield NamespaceÒ»×éÔª×ֶεÄÈÝÆ÷¡£¡£¡£¡£¡£¡£¡£ÈôÒªµ¼ÈëÔª×ֶΣ¬£¬ £¬£¬£¬ÄúÐèÒª°üÀ¨ËùÓÐ 4 ¸öÔª×Ö¶ÎÁУ¨Metafield Namespace¡¢Metafield Key¡¢Metafield Value ºÍ Metafield Value Type£©ÖеÄÖµ¡£¡£¡£¡£¡£¡£¡£ÄúÓ¦¸ÃΪԪ×ֶνç˵×Ô½ç˵ÃüÃû¿Õ¼äÒÔÇø·ÖÓ¦ÓÃºÍ Shopify ʹÓõÄÓ¦Ó㨰üÀ¨Ä¬ÈϵĠglobal£©¡£¡£¡£¡£¡£¡£¡£×î´ó³¤¶È£º20 ¸ö×Ö·û¡£¡£¡£¡£¡£¡£¡£
Metafield KeyÔª×ֶεÄÃû³Æ¡£¡£¡£¡£¡£¡£¡£×î´ó³¤¶È£º30 ¸ö×Ö·û¡£¡£¡£¡£¡£¡£¡£ÈôÊǰüÀ¨ÆäËûÔª×Ö¶ÎÁУ¬£¬ £¬£¬£¬Ôò±ØÐèÌîд´ËÁС£¡£¡£¡£¡£¡£¡£
Metafield ValueÒª´æ´¢ÎªÔªÊý¾ÝµÄÐÅÏ¢¡£¡£¡£¡£¡£¡£¡£°üÀ¨ÆäËûÔª×Ö¶ÎÁÐʱ±ØÐèÌîд´ËÁС£¡£¡£¡£¡£¡£¡£
Metafield Value TypeÔª×ֶεÄÐÅÏ¢ÀàÐÍ¡£¡£¡£¡£¡£¡£¡£ÓÐÓÃÖµ£º
  • string

  • integer

  • json_string

ÖµÇø·Ö¾Þϸд¡£¡£¡£¡£¡£¡£¡£°üÀ¨ÆäËûÔª×Ö¶ÎÁÐʱ£¬£¬ £¬£¬£¬±ØÐèÌîд´ËÁС£¡£¡£¡£¡£¡£¡£

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:

ColumnDescription
First nameThe first name of the customer. This column and the Last Name column are required if neither the Email nor the Phone columns are included.
Last nameThe last name of the customer. This column and the First name column are required if neither the Email nor the Phone columns are included.
EmailThe unique email address of the customer. This column is required if the Phone or the First Name and Last Name columns 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, Ottawa or Berlin.
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 the Province Code column. For example, Mexico cityNew York, or Nunavut.
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 the Province column. 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)21
CountryThe name of the country of the customer address. This column is required for an address. For example, Canada or Australia.
Country codeThe two-letter ISO 3166-1 alpha-2 code for the country of the customer address. Specify the Country code even when you specify Country. For example, CA for Canada and AU for 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 the Email column nor the First name and Last name columns 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-1212
Accepts 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.
NoteA note about the customer. For example, "This customer placed an order that had a fraud warning" or "Harry loves the color pink".
Tax ExemptWhether 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 NamespaceA container for a set of metafields. To import metafields, you need to include values in all 4 metafield columns (Metafield NamespaceMetafield KeyMetafield Value, and Metafield Value Type). You should define a custom namespace for your metafields to distinguish them from namespaces used by apps and Shopify (including the default global). 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.

ÎÄÕÂÄÚÈÝȪԴ£ºShopifyÉÌ»§¹Ù·½ÍøÕ¾ 

¸ü¶à
¡¾ÍøÕ¾µØÍ¼¡¿¡¾sitemap¡¿