Import Customers Into Shopify From a CSV on FTP

5 min setup
No coding required
Runs automatically

Customer lists from another platform, an event, or an offline channel usually arrive as a CSV file. This workflow watches a customer CSV on your FTP server and creates a Shopify customer for each new row, with name, phone, address, tags, and notes, after checking the email is not already in your store.

ftp icon
FTP Fetch CSV File Row Created (Trigger)
Shopify Search Customer by Email
Filter
Shopify logo icon
Shopify Create Customer

How it works

5 steps to turn every new row in a customer CSV on FTP into a Shopify customer

ftp icon

FTP Fetch CSV File Row Created (Trigger)

App connector: FTP • Time to complete: 1 minute

Check the customer CSV on the FTP server on a recurring interval and run once for each new row. Expect columns such as Email, First Name, Last Name, Phone, Address, City, Tags, and Note.

Filter

App connector: Filter • Time to complete: 1 minute

Continue only if the row has an email address.

Shopify Search Customer by Email

App connector: Shopify • Time to complete: 1 minute

Look up the row's email in Shopify.

Filter

App connector: Filter • Time to complete: 1 minute

Continue only if no existing customer was found, so the import never creates duplicates.

Shopify logo icon

Shopify Create Customer

App connector: Shopify • Time to complete: 1 minute

Create the customer with the row's email, first and last name, phone, default address, tags, and note, so imported customers are easy to segment later.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to turn every new row in a customer CSV on FTP into a Shopify customer

Get setup in 5 minutes.

Use this template →

FAQs

Can I import customer passwords?

No. Shopify does not accept imported passwords. Imported customers set their own password through Shopify's account invite or reset flow.

What happens if a customer is already in Shopify?

The workflow looks up the email first and stops for that row if a customer already exists, so no duplicate is created.

Can it update existing customers instead?

Yes. Add a path for rows where the customer was found and use Update Customer or Customer Add Tag to bring their record up to date.

Personalize this template

Customize this workflow even further:

Tag by source
Add a tag such as imported-from-csv or the event name so you can build a Shopify segment for the imported customers.
Send account invites
Add Create Customer Send Invite after the customer is created so imported customers can activate their account.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

turn every new row in a customer CSV on FTP into a Shopify customer

5 min setup • Fully supported if you need help