Total Pageviews

Friday, June 16, 2017


Importing and exporting customer lists

please help me add my INSTAGRAM account, and FACEBOOK group with name of my business!
If you have a customer list that you want to use in Shopify, you can enter it into a customer CSV file and then import it in your Shopify admin. You can also use the customer CSV template to build a new customer list.


If you want to edit multiple customers that already exist in your customer list, you might find it easier to use bulk editing instead.

CSV files

CSV stands for Comma Separated Values, and it's a file format (.csv) for spreadsheets. Shopify accepts the import and export of CSV files for the ProductsCustomersOrders (export only), and Discounts (export only) of your store.
CSV files might seem intimidating at first, but when you understand what the text and characters represent in a spreadsheet, you might use it for some bigger tasks (such as bulk editing products and customers).
CSV files with UTF-8 encoding are the only file format that can be used to import to or export from Shopify.


If you are updating a CSV file export, then remember to confirm the UTF-8 encoding to avoid generating unwanted special characters in your file. If you save your file after forgetting to confirm its UTF-8 encoding, then your data will be corrupted when you upload it as a new spreadsheet. Shopify can't recover corrupted files for you.
In a CSV file, each entry represents a cell in a spreadsheet, each line represents a new row, and each comma indicates where one entry ends and another one begins.
For example, the entries in this customer CSV file:
Csv file1
look like this in a spreadsheet program:
Csv file2
Shopify recommends using Google Sheets to view a formatted version of your CSV files. To use Google Sheets, you must import the CSV file into the program, then export it as a .csv file to your computer.
CSVs are useful for stores that:
  • are switching to Shopify from another ecommerce platform
  • have a list of Customer Accounts
  • prefer to upload Products using a spreadsheet
  • temporarily have limited internet connectivity.

Import CSV files into Google Sheets

When you export a CSV file from your Shopify admin, it opens as a .csv file in your computer's native text editor. You can also use an alternative text editor, but it's recommended that you use a spreadsheet program to view and edit your CSV files instead.


You can download Shopify's sample CSV templates for products and customers.
To import a CSV in to Google Sheets:
  1. On the Google Sheets page, click Blank in the Start a new spreadsheet section:
    Sheets start blank
  2. From the Untitled Spreadsheet page, go to File > Import...:
    File import


    A CSV file with UTF-8 encoding is the only file format that can be used to import to or export from Shopify.
  3. Locate and select the CSV file that you want to edit.
  4. In the Import file dialog, select your preferred options under the Import actionSeparator character, and Convert text to numbers and dates sections.
  5. Click Import:
    Import file dialog
Your CSV will look something like this after you've uploaded it:
Csv sheets example
From here you can edit your CSV. When you are done, you can export it from Google Sheets as a .csv file.

Export CSV files using Google Sheets

When you are done viewing or editing your CSV file in Google Sheets, you can export it as a .csv file to your computer.
To export your CSV file:
From your CSV spreadsheet page, go to File > Download as > Comma-separated values (.csv, current sheet):
Download as csv
You CSV file will appear in your downloads folder.

Customer CSV template

If you import the blank customer CSV template without adding any new customers to it, then it creates two default customer records in your store:
  • Jane Doe is an example of a customer with only an email address
  • John Doe is an example of an customer with an email address and a shipping address.
The customer CSV template file will look something like this:
Customer csv template


Importing a CSV file will create a customer in your store for each email address in the file. Any customers with duplicate email addresses will be skipped during an import—only the last record with the duplicated email address will be imported into the customer list in your Shopify admin.

Import existing customers using the customer CSV

Shopify provides a template file that you can use as a guide to create your own customer list to import into your store. You can download and view our customer CSV template.
Shopify's ability to import customer accounts from other platforms is limited. If you are trying to import customer email lists from another platform to Shopify, then see here for more information.


Shopify recommends importing your CSV to Google Sheets to view a formatted version of it.
To import a customer CSV:
  1. From your Shopify admin, click Customers.
  2. Click Import customers:
    Import customer
  3. In the Import Customers By CSV dialog, click Choose file, and then select your customer CSV file:
    Choose customer csv
  4. If you want to update any existing customers, then click Overwrite existing customers that have the same email.
  5. Click Import customers:
    Import customer csv
The customers whose records you've added to the CSV will appear on the Customers page in your Shopify admin.

Export existing customers to a CSV file

You can export a CSV file of all your store's customers and their details, or a filtered list of customers and their details.
Exported CSV files can be opened in a spreadsheet application like Excel, Numbers, or Google Sheets, or used to connect your Shopify store with a third-party CRM system.


Shopify recommends opening your CSV files in Google Sheets for best results.
To export customers:
  1. From your Shopify admin, click Customers.
  2. Click Export:
    Export customers highlight
  3. Click one of the following export options:
    • Current page to export the customers showing in your store admin
    • All customers to export all your store's customers
    • Selected customer to export customers you have selected
    • Current Search to export a filtered list of customers.
  4. Select which file format you want to export:
    • Select CSV for Excel, Numbers, and other spreadsheet programs if you plan to use a spreadsheet program with your customer CSV.
    • Select Plain CSV file if you plan to use a plain-text editor with your customer CSV.
  5. Click Export customers to download your customer CSV:
    Export customers group


If you export more than 30 customers or if you choose to export all of your customers, then an email will be sent to you containing a secure download link. Click the link in the email to download your CSV file.

Format your customer CSV file

The first line of your customer CSV must include all the headers listed below, which are included in the customer CSV template.


When formatting your customer CSV, Shopify recommends importing your CSV to Google Sheets to view a formatted version of it.


CSV file headers are case sensitive—their capitalization must match the examples that appear in the following table.


The Total Spent and Total Orders fields will not be imported with customer details.
First NameThe first name of the customer.
Last NameThe last name of the customer.
EmailThe email address of the customer.
CompanyThe name of the company that customer uses if applicable.
Address1The first line of the customer's address.
Address2The second line of the customer's address, if necessary.
CityThe city the customer lives in.
ProvinceThe province or state the customer lives in. You must also enter the Province Code if this field is completed.
Province CodeThe province or state ISO code. Shopify uses ISO alpha 2 codes.
CountryThe country the customer lives in.
Country CodeThe country ISO code.Shopify uses ISO alpha 2 codes.
ZipThe postal or zip code for the customer's address.
PhoneThe customer's phone number.
Accepts MarketingSets whether or not the customer agrees to subscribe to email marketing, such as a newsletter. Valid entries are yes or no.
Total SpentThe customer's total amount spent. Valid entries must not have a currency symbol included. This field will not be imported with customer details.
Total OrdersThe customer's total number of orders. This field will not be imported with customer details.
TagsA comma-separated list of tags used to tag the customer (for example, tag1,tag2,tag3).
NoteAdditional information about the customer.
Tax ExemptIndicates if the customer is tax exempt.


You can import only the above fields using a CSV file. Order information cannot be imported with a customer CSV file.
When importing customer information, your CSV file must be in UTF-8 format. Most spreadsheet applications have the ability to save CSV files in UTF-8 format with the Save As... or Export command, depending on the program.

Use a text editor to edit your customer CSV file

If you don't have a spreadsheet program, you can edit CSV files using a text editor.


You should only use a text editor as a last resort, for example, if there are formatting errors in your CSV file and you cannot open it in a spreadsheet program.
Most computers have text editors that can open CSV files. You can also use a program like Atom or Sublime Text to edit and debug your CSV file.


A CSV file with UTF-8 encoding is the only file format that can be used to import to or export from Shopify.
To format your customer CSV file in a text editor:
  • Column headers must be separated by commas (for example, First Name,Last Name,Email,Company,Address1).
  • The list of tags must be wrapped in quotation marks (for example, "tag1,tag2,tag3").
  • Different customer records must be separated by line breaks.

Want to discuss this page?

No comments:

Post a Comment

Post your comments: