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.
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:
- Go to Apps → Migrato.
- Open the Import section.
- Add the Smart Collection file you want to 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
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.
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
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.
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.
The selected operation determines how Migrato handles existing and new Smart Collection records.
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.
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.
Step 8: Start the Smart Collection 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 Smart Collection import.
Step 9: Monitor the Import
Migrato processes the Smart Collection import as a job and displays the current processing status.
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
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:
- Go to Apps → Migrato.
- Open the Export section.
- Select Smart Collections.
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
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
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 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
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.
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.