Import / Export Custom Collections
How to import and export custom collections in bulk with CSV and XLSX files.Migrato allows you to import and export Shopify Custom Collections using CSV or XLSX files. You can select the required Custom Collection fields, export existing Custom Collection data, prepare data for import, and use filters to export only the Custom Collections that match specific conditions.
You can use Custom Collection import/export to transfer, manage, update, or migrate Custom Collection data in bulk instead of processing Custom Collections individually through Shopify Admin.
Migrato also supports importing Custom Collection data from a publicly accessible file URL, making it possible to work with files hosted on external systems.
We recommend reviewing the Custom Collection Template Documentation and downloading the Custom Collection Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.
How to Import and Export Shopify Custom Collections
Migrato allows you to import and export Shopify Custom Collections using CSV or XLSX files. You can select the required Custom Collection fields, export existing collection data, prepare data for import, and use filters to export only the Custom Collections that match specific conditions.
You can use Custom Collection import/export to transfer, manage, update, or migrate collection data in bulk instead of processing collections individually through Shopify Admin.
Migrato also supports importing Custom Collection data from a publicly accessible file URL, making it possible to work with files hosted on external systems.
We recommend reviewing the Custom Collection Template Documentation and downloading the Custom Collection Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.
Shopify uses collections to organize products for browsing and merchandising. Custom Collections are collections where products are manually selected rather than automatically included through collection rules. Shopify's current Collection resource supports information such as the collection ID, handle, title, description, image, product relationships, product count, publication information, sort order, template suffix, and metafields.
Import Custom Collections
Migrato allows you to bulk import Custom Collection data using CSV or XLSX files.
You can upload a prepared Custom Collection file directly to Migrato or provide a publicly accessible URL to the file.
Step 1: Open Custom Collection Import
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Import section.
- Add the Custom Collection file you want to import.
Step 2: Upload or Provide the Custom Collection File
Migrato provides two ways to provide the Custom Collection file.
Option 1: Upload a File
You can upload or drag and drop your Custom 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 Custom Collection file.
For example:
https://example.com/custom-collections.csv
Enter the URL and select Upload from URL.
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 Custom Collection Sheet
Migrato identifies the Custom Collection data contained in the uploaded file and displays it under the Sheets section.
Review the detected Custom Collection sheet before selecting the import operation.
Step 5: Select an Import Operation
Migrato allows you to select the operation to perform on the Custom Collection data.
Depending on the supported Custom Collection operations, the available options may include:
-
Merge – Update existing Custom Collections and create new collections.
-
Create only – Create new Custom Collections and skip records that already exist.
-
Update only – Update existing Custom Collections and skip records that cannot be matched.
-
Replace – Replace an existing matching Custom Collection with the imported data.
-
Delete – Delete the matching Custom Collection if it exists.
The selected operation determines how Migrato handles existing and new Custom Collection records.
Carefully select the operation before starting a Custom 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 Custom Collection import configuration, this section may include options such as scheduling and result-file settings.
Step 7: Schedule the Custom 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 Custom Collection data needs to be imported repeatedly from an external source.
Step 8: Start the Custom 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 Custom Collection import.
Step 9: Monitor the Import
Migrato processes the Custom 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 Custom Collections
Migrato also allows you to export Shopify Custom Collection data into a downloadable CSV or XLSX file.
This can be useful for:
-
Collection reporting
-
Data analysis
-
Backup
-
Store migration
-
Data processing
-
External system integration
-
Record keeping
Step 1: Open Custom Collection Export
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Export section.
- Select Custom Collections.
Step 2: Select Custom Collection Fields
Select the Custom Collection fields you want to include in the export.
The available information can include collection details, product relationships, publication information, images, sorting information, and metafields.
Select only the fields required for your export to keep the resulting file focused and easier to work with.
Step 3: Apply Custom Collection Filters
If you only need specific Custom Collections, use the Filters section to narrow down the export.
You can use supported Custom Collection fields such as:
-
ID
-
Handle
-
Title
-
Products Count
-
Updated At
-
Published At
For complete information about available filters and conditions, see 6.3 Filter Custom Collections.
Step 4: Start the Export
After selecting the required fields and filters, start the export.
Migrato processes the selected Custom 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 Custom Collection fields
-
Applied filters
You can download the generated export file from the completed export screen.
Supported Custom Collection Data
Migrato's Custom Collection import/export functionality is designed to work with supported Shopify Collection information.
The supported data can include:
-
Collection identification
-
Handle
-
Title
-
Description
-
Sort order
-
Template suffix
-
Publication information
-
Collection image
-
Linked products
-
Product count
-
Metafields
-
Other supported collection fields
Shopify’s Collection resource supports product relationships and product counts, publication information, sorting, images, template suffixes, and metafields. Custom Collections can be identified through Shopify’s collection type filtering.
The exact fields available for import and export depend on the current Migrato Custom Collection Template. Refer to 6.2 Template Documentation for the complete field reference.
Important Notes for Custom Collection Import/Export
-
Always review the Custom Collection Template Documentation before preparing an import file.
-
Make sure the file follows the required Migrato Custom Collection structure.
-
Use a test file with a small number of collections before processing a large 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 Custom Collections, select only the fields required for the intended use of the exported file.
-
Review the selected filters before starting the export.