Customers > Importing Customers
User GuideCustomersImporting Customers

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:

  1. In the Customers section, select Import.

    The Available Headers section displays the columns supported during import.

    HeaderRequired/OptionalDescriptionExample
    emailRequiredThe email address of the customeraarmstrong1@example.com
    nameOptionalFull name of the customerJimmy Smith
    accepts_marketingOptionalWhether the customer has consented to receive marketing emailstrue / false
    verified_emailOptionalWhether the customer's email address has been confirmedtrue / false
    is_disposable_emailOptionalWhether the customer's email address appears suspicioustrue / false
    tax_exemptOptionalMarks the customer as tax-exempt; no sales or consumption taxes are chargedtrue / false
    groupOptionalName of the customer group the customer belongs toVIP Shoppers
    s_nameRequiredThe recipient name (shipping address)David Fernandez
    s_address1RequiredStreet address (shipping address)8912 Porter Trail
    s_address2OptionalAdditional address line (shipping address)Suite 2331
    s_cityRequiredCity (shipping address)Nashville
    s_companyOptionalCompany name (shipping address)Widgets Express Inc.
    s_phoneOptionalPhone number (shipping address)1-(334)601-9994
    s_countryRequiredTwo-letter country code (shipping address)US
    s_provinceRequiredTwo-letter province or state code (shipping address)TX
    s_zipRequiredZip or postal code (shipping address)90210
    b_nameOptionalThe recipient name (billing address)David Fernandez
    b_address1OptionalStreet address (billing address)8912 Porter Trail
    b_address2OptionalAdditional address line (billing address)Suite 2331
    b_cityOptionalCity (billing address)Nashville
    b_companyOptionalCompany name (billing address)Widgets Express Inc.
    b_phoneOptionalPhone number (billing address)1-(334)601-9994
    b_countryOptionalTwo-letter country code (billing address)US
    b_provinceOptionalTwo-letter province or state code (billing address)TX
    b_zipOptionalZip or postal code (billing address)90210

    Note: To download an import file template, select Download file template.

  2. 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.
  3. To copy and paste customer data instead, select Copy and paste to display the text field.

  4. 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.
  5. Configure the Override Existing Data settings:

    • Override existing customers — replaces existing customer records if a matching email address is found.
  6. Select Next.

  7. 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.

  8. Select Next to start the data upload. After the upload completes, data processing begins.

  9. Select Go to customers or Done to close the Import Customers window.

The Customers page now displays all recently imported customers.

PREVIOUS
Customer Groups
NEXT
Exporting Customers