Importing contact lists from Mailchimp manually

This guide explains how you can import your contacts from Mailchimp to Shopify manually.

Export contact lists from Mailchimp

Before you can import your contacts to Shopify, you first need to export them from Mailchimp.

Clean up the file

After you've exported your contacts from Mailchimp, you'll have a ZIP file saved to your computer. This ZIP file contains a CSV file with subscribed members list. If there were any unsubscribed members in your contacts, then you'll have another CSV file with unsubscribed members list. You need to unzip the ZIP file, and then clean up each CSV file to make it ready for import.

Steps:

  1. Upload the CSV file to Google Sheets.
  2. In your spreadsheet, keep only the following column headers, and delete the others.
    • Email Address
    • First Name
    • Last Name
    • Phone Number
    • Company
  3. Rename the following column headers, and make sure to leave no spaces on either side of text:
    • From Email Address to Email
    • From Phone Number to Phone
  4. Add a new column header named Accepts Email Marketing, and enter values in this column for each customer according to the following criteria:
    • If your file name begins with subscribed_members, then type yes for all customers.
    • If your file name begins with nonsubscribed_members, then type no for all customers.
  5. Add a new column header named Accepts SMS Marketing, and enter yes or no values for each customer.
  6. Export the file to your computer in CSV format.

Import the file into Shopify

After you have cleaned up your CSV files, you need to import each of these files to your Shopify store to complete your import.

Troubleshoot errors

Error found in CSV header

If you encounter the error Error found in CSV header when you import your CSV file to Shopify, then that means that the column header names don't match. Verify whether the column header names in your CSV file match the required names.

Can’t find the answers you’re looking for? We’re here to help.