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

Import / Export Smart Collections

Migrato allows you to import and export Shopify Smart Collections using CSV or XLSX files. You can select the required Smart Collection fields, export existing Smart Collection data, prepare data for import, and use filters to export only the Smart Collections that match specific conditions.

You can use Smart Collection import/export to transfer, manage, update, or migrate Smart Collection data in bulk instead of processing Smart Collections individually through Shopify Admin.

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

Smart Collections Import Video Demonstration
Smart Collections Import Video Demonstration
i

Before importing or exporting Smart Collections: We recommend reviewing the Smart Collection Template Documentation and downloading the Smart Collection Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.

How to Import and Export Shopify Smart Collections

Import Smart Collections

Migrato allows you to bulk import Shopify Smart Collection data using CSV or XLSX files.

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

Step 1: Open Smart Collection Import

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Import section.
  3. Add the Smart Collection file you want to import.
Migrato – Smart Collection Import
Migrato – Smart Collection Import

Step 2: Upload or Provide the Smart Collection File

Migrato provides two ways to provide the Smart Collection file.

Option 1: Upload a File

You can upload or drag and drop your Smart Collection file into the upload area.

Migrato supports:

  • CSV
  • XLSX
Migrato – Upload Smart Collection File
Migrato – Upload Smart Collection File

Option 2: Import from a Public URL

Instead of uploading the file manually, you can provide the full publicly accessible URL of the Smart Collection file.

For example:

https://example.com/smart-collections.csv

Enter the URL and select Upload from URL.

Migrato – Import Smart Collections from URL
Migrato – Import Smart Collections from URL
i

Note: The file URL must be accessible to Migrato. Make sure the file can be accessed 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
Migrato – Smart Collection Import Details
Migrato – Smart Collection Import Details

Review the displayed information before continuing with the import.

Step 4: Review the Smart Collection Sheet

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

Review the detected Smart Collection sheet before selecting the import operation.

Migrato – Smart Collection Import Sheet
Migrato – Smart Collection Import Sheet

Step 5: Select an Import Operation

Migrato allows you to select the operation to perform on the Smart Collection data.

Depending on the supported Smart Collection operations, the available options may include:

  • Merge – Update existing Smart Collections and create new Smart Collections.
  • Create only – Create new Smart Collections and skip records that already exist.
  • Update only – Update existing Smart Collections and skip records that cannot be matched.
  • Replace – Replace an existing matching Smart Collection with the imported data.
  • Delete – Delete the matching Smart Collection if it exists.
Migrato – Smart Collection Import Operations
Migrato – Smart Collection Import Operations

The selected operation determines how Migrato handles existing and new Smart Collection records.

i

Important: Carefully select the operation before starting a Smart Collection import, particularly when using Replace or Delete.

Step 6: Configure Import Options

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

Depending on the Migrato Smart Collection import configuration, this section may include options such as scheduling and result-file settings.

Migrato – Smart Collection Import Options
Migrato – Smart Collection Import Options

Step 7: Schedule the Smart Collection Import

Migrato can schedule an import job when scheduling is enabled for the operation.

You can configure:

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

This is useful when Smart Collection data needs to be imported repeatedly from an external source.

Migrato – Schedule Smart Collection Import
Migrato – Schedule Smart Collection Import

Step 8: Start the Smart Collection 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.
Migrato – Import Smart Collections Button
Migrato – Import Smart Collections Button

Migrato will begin processing the Smart Collection import.

Step 9: Monitor the Import

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

Migrato – Smart Collection Import in Progress
Migrato – Smart Collection Import in Progress

You can use the job information to track the progress of the import.

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
Migrato – Smart Collection Import Results
Migrato – Smart Collection Import Results

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

Export Smart Collections

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

This can be useful for:

  • Smart Collection reporting
  • Data analysis
  • Backup
  • Store migration
  • Data processing
  • External system integration
  • Record keeping

Step 1: Open Smart Collection Export

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Export section.
  3. Select Smart Collections.
Migrato – Select Smart Collections for Export
Migrato – Select Smart Collections for Export

Step 2: Select Smart Collection Fields

Select the Smart Collection fields you want to include in the export.

Migrato organizes the available Smart Collection fields into the following groups:

  • Basic Columns
  • Rules
  • Linked Products
  • Products Count
  • Metafields
Migrato – Smart Collection Export Fields
Migrato – Smart Collection Export Fields

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

Step 3: Apply Smart Collection Filters

If you only need specific Smart Collections, use the Filters section to narrow down the export.

You can filter Smart Collections using the supported fields:

  • ID
  • Handle
  • Title
  • Products Count
  • Updated At
  • Published At
Migrato – Smart Collection Export Filters
Migrato – Smart Collection Export Filters

For complete information about available Smart Collection filters and their conditions, see Filter Smart Collections.

Step 4: Start the Export

After selecting the required fields and filters, start the export.

Migrato processes the selected Smart Collection data and creates the export file.

Step 4: Start the Export
Migrato – Start Smart Collection Export

Step 5: Review the Export Result

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

The result page can display information such as:

  • Export status
  • Exported file name
  • File format
  • Number of records exported
  • Processing duration
  • Selected Smart Collection fields
  • Applied filters
Migrato – Smart Collection Export Completed
Migrato – Smart Collection Export Completed

You can download the generated export file from the completed export screen.

Supported Smart Collection Data

Migrato’s Smart Collection import/export functionality supports Smart Collection information organized into the following template groups:

Group Columns
Basic Columns 16
Rules 4
Linked Products 3
Products Count 1
Metafields 1
Total 25

The supported Smart Collection data includes information such as:

  • Smart Collection identification
  • Handle and title
  • Collection description
  • Product sorting information
  • Template information
  • Publication information
  • Collection image information
  • Smart Collection rules
  • Linked product information
  • Product count
  • Metafields

Shopify Smart Collections use rules to determine which products belong to the collection. A rule contains a product column, relation, and condition, while the collection’s matching behavior determines whether products must satisfy all rules or one or more rules.

i

Note: The exact fields available for import and export depend on the current Migrato Smart Collection Template. Refer to Template Documentation for the complete field reference.

Important Notes for Smart Collection Import/Export

  • Always review the Smart Collection Template Documentation before preparing an import file.
  • Make sure the file follows the required Migrato Smart Collection structure.
  • Use a test file with a small number of records before processing a large Smart Collection dataset.
  • Carefully review the selected operation before importing.
  • Take extra care when using Replace or Delete operations.
  • When importing from a URL, make sure the file is publicly accessible.
  • Review the import results and error information after processing.
  • When exporting Smart Collections, select only the fields required for the intended use of the exported file.
  • Review the selected filters before starting the export to ensure that the required Smart Collections are included.

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