Importing Customers
You can add customers to your store in bulk through the import process. An import file must be in .csv or .txt format.
To import customers, follow these steps:
-
In the Customers section, select Import.
The Available Headers section displays the columns supported during import.
Header Required/Optional Description Example email Required The email address of the customer aarmstrong1@example.com name Optional Full name of the customer Jimmy Smith accepts_marketing Optional Whether the customer has consented to receive marketing emails true / false verified_email Optional Whether the customer's email address has been confirmed true / false is_disposable_email Optional Whether the customer's email address appears suspicious true / false tax_exempt Optional Marks the customer as tax-exempt; no sales or consumption taxes are charged true / false group Optional Name of the customer group the customer belongs to VIP Shoppers s_name Required The recipient name (shipping address) David Fernandez s_address1 Required Street address (shipping address) 8912 Porter Trail s_address2 Optional Additional address line (shipping address) Suite 2331 s_city Required City (shipping address) Nashville s_company Optional Company name (shipping address) Widgets Express Inc. s_phone Optional Phone number (shipping address) 1-(334)601-9994 s_country Required Two-letter country code (shipping address) US s_province Required Two-letter province or state code (shipping address) TX s_zip Required Zip or postal code (shipping address) 90210 b_name Optional The recipient name (billing address) David Fernandez b_address1 Optional Street address (billing address) 8912 Porter Trail b_address2 Optional Additional address line (billing address) Suite 2331 b_city Optional City (billing address) Nashville b_company Optional Company name (billing address) Widgets Express Inc. b_phone Optional Phone number (billing address) 1-(334)601-9994 b_country Optional Two-letter country code (billing address) US b_province Optional Two-letter province or state code (billing address) TX b_zip Optional Zip or postal code (billing address) 90210 Note: To download an import file template, select Download file template.
-
If an import file is available, do one of the following:
- Drag and drop the file onto the upload area.
- Select the upload area to browse for the import file.
-
To copy and paste customer data instead, select Copy and paste to display the text field.
-
Select Next after uploading a file or pasting data.
Configure the Visibility settings:
- Draft — saves customer records as drafts.
- Publish Now — activates customer accounts immediately after import.
-
Configure the Override Existing Data settings:
- Override existing customers — replaces existing customer records if a matching email address is found.
-
Select Next.
-
Review each column mapping and update as needed. Scroll down to see which columns will be imported and any invalid columns that will be skipped.
Note: If a column is marked invalid, check its status for any errors to fix.
-
Select Next to start the data upload. After the upload completes, data processing begins.
-
Select Go to customers or Done to close the Import Customers window.
The Customers page now displays all recently imported customers.