Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Import / Export Shop Data
Shop Import/Export

Import / Export Shop Data

How to import and export shop data in bulk with CSV and XLSX files.
5 min read Updated 14 October 2026 Applies to Migrato on all plans

Migrato allows you to import and export Shopify Shop data using CSV or XLSX files. You can select the required Shop fields, export existing Shop information, prepare Shop data for import, and manage supported store-level information in bulk.

You can use Shop import/export to transfer, manage, update, or migrate supported Shopify store information instead of manually reviewing individual settings through Shopify Admin.

Migrato also supports importing Shop data from a publicly accessible file URL, making it possible to work with files hosted on external systems.

Shop Import Video Demonstration
Shop Import Video Demonstration
★
Before importing or exporting Shop data

We recommend reviewing the Shop Template Documentation and downloading the Shop Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.

Import Shop Data

Migrato allows you to import supported Shopify Shop data using CSV or XLSX files.

You can upload a prepared Shop file directly to Migrato or provide a publicly accessible URL to the file.

Step 1: Open Shop Import

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Import section.
  3. Select Shop as the entity to import.
  4. Add the Shop file you want to import.
Shop Import
Shop Import

Step 2: Upload or Provide the Shop File

Migrato provides two ways to provide the Shop file.

Option 1: Upload a File

Upload or drag and drop your Shop file into the upload area.

Migrato supports:

  • CSV
  • XLSX
Upload Shop File
Upload Shop File

Option 2: Import from a Public URL

You can also provide the full publicly accessible URL of the Shop file.

For example:

Example
https://example.com/shop.csv

Enter the URL and select Upload from URL.

Import Shop from URL
Import Shop from URL
i
Note

The file URL must be accessible to Migrato without authentication or a login requirement.

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

The import details can include:

  • Import ID
  • Import state
  • File format
  • Operation
  • Uploaded file
  • Import start information
Shop Import Details
Shop Import Details

Review the displayed information before continuing.

Step 4: Review the Shop Sheet

Migrato identifies the Shop data contained in the uploaded file and displays it under the Sheets section.

Review the detected Shop sheet before selecting the import operation.

Shop Import Sheet
Shop Import Sheet

Step 5: Select an Import Operation

Migrato allows you to select the operation to perform on the Shop data.

Depending on the supported Shop operations, available options can include:

  • Merge – Update supported existing Shop data and create supported new data.
  • Create only – Create supported records and skip records that already exist.
  • Update only – Update supported existing records.
  • Replace – Replace supported existing data using the imported data.
  • Delete – Delete matching supported data where the operation is supported.
Shop Import Operations
Shop Import Operations
!
Important

The available operations and their behavior may vary depending on the Shop data being imported and the current Migrato implementation. Review the selected operation carefully before processing the file.

Step 6: Configure Import Options

Open the Options section to configure any additional settings available for the Shop import.

Depending on the Migrato configuration, this may include scheduling and result-file settings.

Shop Import Options
Shop Import Options

Step 7: Schedule the Shop Import

When scheduling is available, you can configure:

  • Schedule date
  • Schedule time
  • Repeat interval
  • Number of repetitions or run until cancelled

This can be useful when supported Shop information needs to be imported repeatedly from an external source.

Schedule Shop Import
Schedule Shop Import

Step 8: Start the Shop Import

After reviewing the file and selecting the required operation:

  1. Review the import details.
  2. Confirm the selected operation.
  3. Review the available options.
  4. Click Import.
Import Shop Button
Import Shop Button

Migrato will begin processing the Shop import.

Step 9: Monitor the Import

Migrato processes the Shop import as a job and displays the current processing status.

You can use the job information to monitor the processing status.

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
Shop Import Results
Shop Import Results

If any records fail, review the reported errors, correct the source file where required, and run the import again.

Export Shop Data

Migrato also allows you to export Shopify Shop data into a downloadable CSV or XLSX file.

Shop exports can be useful for:

  • Store information reporting
  • Data analysis
  • Backup
  • Store migration
  • External system integration
  • Record keeping

Step 1: Open Shop Export

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Export section.
  3. Select Shop.
Select Shop for Export
Select Shop for Export

Step 2: Select Shop Fields

Select the Shop fields you want to include in the export.

Migrato organizes Shop information into the following groups:

  • Basic Columns
  • Other Details
  • Metafields
Shop Export Fields
Shop Export Fields

Select only the fields required for your export to keep the resulting file focused and easier to work with.

Step 3: Start the Export

After selecting the required fields, start the export.

Start Shop Export
Start Shop Export

Migrato processes the selected Shop data and creates the export file.

Step 4: Review the Export Result

After the export is completed, Migrato displays the export result.

The result can include information such as:

  • Export status
  • Exported file name
  • File format
  • Number of records exported
  • Processing duration
  • Selected Shop fields
Shop Export Completed
Shop Export Completed

You can download the generated CSV/XLSX file from the completed export screen.

Supported Shop Data

Migrato's Shop template contains the following field groups:

Group Number of Columns
Basic Columns 4
Other Details 28
Metafields 1
Total 33

The supported Shop data includes store identification, contact information, address information, localization, currency, tax settings, money formats, Shopify plan information, and other supported store-level details.

i
Note

The exact fields available for import and export depend on the current Migrato Shop Template. Refer to 16.2 Template Documentation for the complete field reference.

Important Notes for Shop Import/Export

  • Review the Shop Template Documentation before preparing an import file.
  • Keep the supported column names unchanged.
  • Use a test file before processing Shop data in bulk.
  • Carefully review the selected operation before starting an import.
  • Take extra care when using operations that modify or delete existing data.
  • When importing from a URL, make sure the file is publicly accessible.
  • Review the import results and error information after processing.
  • For exports, select only the Shop fields required for your intended use.

Ready to run this on your own store?

Migrato's free plan handles 25 items per job - enough to follow any page in these docs end to end before you pay anything.

Free plan forever No credit card 2-minute setup Uninstall anytime