Import / Export Customers Data
How to import and export customers in bulk with CSV and XLSX files.Migrato allows you to import and export Shopify customers data using CSV or XLSX files. You can select the customers fields you need, export existing customers information, prepare customers data for import, and use filters to export only the customers that match specific conditions.
You can use customers import/export to bulk manage, update, migrate, and maintain customers data without having to process customers individually through Shopify Admin.
Migrato also supports importing customers data from a publicly accessible file URL, making it possible to work with customers files hosted on external systems.
We recommend reviewing the Customers Template Documentation and downloading the Customers Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.
Import Customers
Migrato allows you to bulk import Shopify customer data using CSV or XLSX files.
You can upload a customer file directly to Migrato or provide a publicly accessible URL to the file.
Step 1: Open Customer Import
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Import section.
- Select Customers as the entity you want to import.
- Add the customer file you want to import.
Step 2: Upload or Provide the Customer File
Migrato provides two ways to provide the customer file.
Option 1: Upload a File
Upload or drag and drop your prepared customer file into the upload area.
Migrato supports:
-
CSV
-
XLSX
Option 2: Import from a Public URL
Instead of uploading the file manually, you can provide the full publicly accessible URL of the customer file.
For example:
https://example.com/customers.csv
Enter the URL and select Upload from URL.
The file URL must be accessible to Migrato. Make sure the file does not require authentication or a login to access it.
Step 3: Review the Import Details
After the file is uploaded or retrieved from the provided URL, Migrato creates an import job and displays the available import details.
The import details can include:
-
Import ID
-
Import state
-
File format
-
Selected entity
-
Uploaded file
-
Import information
Review the displayed information before continuing.
Step 4: Review the Customer Sheet
Migrato identifies the customer data contained in the uploaded file and displays it under the Sheets section.
Review the detected customer sheet before selecting the import operation.
Step 5: Select an Import Operation
Migrato allows you to select the operation to perform on the customer data.
Depending on the supported customer operations, the available options can include:
-
Merge – Updates matching customers and creates new customers.
-
Create only – Creates new customers and skips customers that already exist.
-
Update only – Updates existing customers and skips records that cannot be matched.
-
Replace – Replaces the matching customer data with the imported data.
-
Delete – Deletes matching customer records where supported.
The selected operation determines how Migrato handles existing and new customer records.
Carefully review the selected operation before starting an import, particularly when using Replace or Delete.
Step 6: Configure Import Options
Open the Options section to configure the additional settings available for the customer import.
Depending on the Migrato customer import configuration, available options may include scheduling and result-file settings.
Step 7: Schedule the Customer Import
Migrato can schedule an import job when scheduling is enabled.
You can configure options such as:
-
Schedule date
-
Schedule time
-
Repeat interval
-
Number of repetitions or run until cancelled
Scheduled imports can be useful when customer information needs to be repeatedly synchronized from an external source.
Step 8: Start the Customer Import
After reviewing the file and selecting the required operation:
- Review the import details.
- Confirm the selected operation.
- Review the available options.
- Click Import.
Migrato will begin processing the customer import.
Step 9: Monitor the Import
Migrato processes the customer import as a job and displays its current processing status.
Use the job information to monitor the import while it is being processed.
Step 10: Review Import Results
After processing is completed, review the import results.
The result information can include:
-
Import status
-
Total records
-
Successfully processed records
-
Failed records
-
Skipped records
-
Processing duration
-
Error information
If any customer records fail, review the reported errors, correct the source file where required, and run the import again.
Export Customers
Migrato allows you to export Shopify customer data into a CSV or XLSX file.
Customer exports can be useful for:
-
Customer data analysis
-
Reporting
-
Data backup
-
Store migration
-
Customer data management
-
External system integration
-
Record keeping
Step 1: Open Customer Export
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Export section.
- Select Customers.
Step 2: Select Customer Fields
Select the customer fields you want to include in the export.
Customer information is organized into different field groups, including:
-
Basic Columns
-
First and Last Order
-
Addresses
-
Activation URLs
-
Metafields
Select only the fields required for your export to keep the resulting file focused and easier to manage.
Step 3: Apply Customer Filters
If you need to export only specific customers, use the Filters section to narrow down the export.
Migrato supports filters based on fields such as:
-
Customer ID
-
Email
-
Created At
-
Updated At
-
Tags
-
Address: Country
-
Email Marketing: Status
-
Tax Exempt
For complete information about available filters and conditions, see 7.3 Filter Customers.
Step 4: Start the Export
After selecting the required customer fields and filters:
- Review the selected fields.
- Review the applied filters.
- Confirm the export settings.
- Start the export.
Migrato processes the selected customer data and creates the export file.
Step 5: Review the Export Result
After the export is completed, Migrato displays the export result.
The result may include information such as:
-
Export status
-
Exported file name
-
File format
-
Number of records exported
-
Processing duration
-
Selected customer fields
-
Applied filters
You can download the generated CSV/XLSX file from the completed export screen.
Supported Customer Data
Migrato's Customer import/export functionality supports the following customer data groups and fields.
| Group | Number of Columns | Description |
|---|---|---|
| Basic Columns | 24 | Contains the primary customer information, marketing preferences, account information, tags, order totals, and other customer attributes. |
| First and Last Order | 8 | Contains information about the customer's first and last orders. These fields are available for export. |
| Addresses | 16 | Contains customer address information, including name, company, address, country, province, ZIP code, and default address status. |
| Activation URLs | 1 | Contains the customer account activation URL. |
| Metafields | 1 | Contains supported customer metafield information. |
| Total | 50 | Total supported Customer template columns. |