Import / Export Files Data
How to import and export files in bulk with CSV and XLSX files.Migrato allows you to import and export Shopify Files using CSV or XLSX files. You can export existing files, prepare file data for import, manage file-related information in bulk, and review file properties without having to manage individual records manually in Shopify Admin.
Files can include information such as file names, links, file types, MIME types, dimensions, duration, status, and file size. This can be useful when managing media assets, reviewing uploaded files, maintaining file records, or migrating supported file data.
Migrato also supports importing file data from a publicly accessible file URL, making it possible to work with files hosted on external systems.
We recommend reviewing the File Template Documentation and downloading the File Demo CSV/XLSX file, if available, to understand the supported fields and expected data structure.
Import Files
Migrato allows you to bulk import supported Shopify file data using CSV or XLSX files.
You can upload a prepared file directly to Migrato or provide a publicly accessible URL to the file.
Step 1: Open File Import
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Import section.
- Select Files as the entity to import.
- Add the file you want to import.
Step 2: Upload or Provide the File
Migrato provides two ways to provide the import file.
Option 1: Upload a File
Upload or drag and drop your prepared file into the upload area.
Migrato supports:
-
CSV
-
XLSX
Option 2: Import from a Public URL
You can also provide the full publicly accessible URL of the file.
For example:
https://example.com/files.csv
Enter the URL and select Upload from URL.
The file URL must be accessible to Migrato. Make sure the URL does not require authentication or a login.
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 displayed information may include:
-
Import ID
-
Import state
-
File format
-
Operation
-
Uploaded file
-
Import information
Review the displayed information before continuing.
Step 4: Review the File Sheet
Migrato identifies the data contained in the uploaded file and displays it under the Sheets section.
Review the detected sheet before selecting the import operation.
Make sure your import file follows the supported Migrato File Template structure.
Step 5: Select an Import Operation
Migrato allows you to select the operation to perform on the file data.
Depending on the supported File operations, the available options may include:
-
Merge – Update matching records and create new records.
-
Create only – Create new records and skip existing records.
-
Update only – Update existing records that can be matched.
-
Replace – Replace matching records with the imported data.
-
Delete – Delete matching records.
The selected operation determines how Migrato handles existing and new file 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 any additional settings available for the File import.
Depending on the current Migrato configuration, available options may include scheduling and result-file settings.
Step 7: Schedule the File Import
If scheduling is available, you can configure the File import to run at a specified time or repeatedly.
You may be able to configure:
-
Schedule date
-
Schedule time
-
Repeat interval
-
Number of repetitions or run until cancelled
This can be useful when file information is maintained on an external system and needs to be synchronized regularly.
Step 8: Start the File 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 File import.
Step 9: Monitor the Import
Migrato processes the File import as a job and displays the current processing status.
You can use the job information to monitor the progress of the import.
Step 10: Review Import Results
After processing is completed, review the import results.
The result information may 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 Files
Migrato also allows you to export Shopify Files data into a downloadable CSV or XLSX file.
File exports can be useful for:
-
File inventory management
-
Media asset audits
-
Data analysis
-
Store migration
-
Backup and record keeping
-
External system processing
-
Reviewing file status and properties
Step 1: Open File Export
From your Shopify Admin:
- Go to Apps → Migrato.
- Open the Export section.
- Select Files.
Step 2: Select File Fields
Select the File fields you want to include in the export.
The current Migrato File template provides two field groups:
-
Basic Columns
-
Size
You can select the fields required for your export.
Step 3: Apply File Filters
If you only need specific files, use the Filters section to narrow down the export.
Migrato currently provides the following File filters:
-
File Name
-
Type
-
Size MB
-
Status
-
Created At
For complete information about the available filters and conditions, see 14.3 Filter Files.
Step 4: Start the Export
After selecting the required fields and filters, start the export.
Migrato processes the selected File data and creates the export file.
Step 5: Review the Export Result
After the export is completed, Migrato displays the export result.
The result information may include:
-
Export status
-
Exported file name
-
File format
-
Number of records exported
-
Processing duration
-
Selected fields
-
Applied filters
You can download the generated CSV/XLSX export file from the completed export screen.
Supported File Data
Migrato's current File template provides 15 columns divided into two groups.
| Group | Columns |
|---|---|
| Basic Columns | 12 |
| Size | 3 |
| Total | 15 |
Basic Columns
The Basic Columns group contains the primary information associated with a Shopify File.
| Column | Description | Allowed Values / Examples |
|---|---|---|
| ID | Unique Shopify identifier of the file. | Number / Shopify File ID |
| File Name | Name of the file. | Text — product-banner.jpg |
| Created At | Date and time when the file was created. | Date/time |
| Link | URL associated with the file. | URL |
| Alt Text | Alternative text associated with the file. | Text |
| Type | Type of the file. | Supported Shopify file type |
| Mime Type | MIME type associated with the file. | image/jpeg, image/png |
| Width | Width of the file or image where applicable. | Numeric value |
| Height | Height of the file or image where applicable. | Numeric value |
| Duration | Duration of the file where applicable, such as for supported video or audio files. | Numeric value |
| Status | Current processing or availability status of the file. | Supported Shopify file status |
| Errors | Error information associated with the file, where applicable. | Text / Error details |
Size
The Size group contains file-size information.
| Column | Description | Allowed Values / Examples |
|---|---|---|
| Size | File size information. | Numeric value |
| Size MB | File size expressed in megabytes. | Numeric value — 2.45 |
| Size Bytes | File size expressed in bytes. | Numeric value — 2569012 |
File Import Example
A File import file can be structured using the supported Migrato columns.
| Column | Example value |
|---|---|
| ID | – |
| File Name | product-banner.jpg |
| Created At | 2026-01-15 10:30:00 |
| Link | https://cdn.example.com/product-banner.jpg |
| Alt Text | Product banner |
| Type | IMAGE |
| Mime Type | image/jpeg |
| Width | 1200 |
| Height | 800 |
| Duration | – |
| Status | READY |
| Errors | – |
| Size | 2.45 MB |
| Size MB | 2.45 |
| Size Bytes | 2569012 |
The example above demonstrates the template structure. The actual values and supported operations depend on the current Migrato implementation and Shopify's supported File functionality.
Important Notes for File Import/Export
-
Review the File Template Documentation before preparing an import file.
-
Keep the supported Migrato column names unchanged unless the import workflow supports field mapping.
-
Use CSV or XLSX format.
-
When importing from a URL, make sure the file is publicly accessible.
-
Test a small dataset before processing a large File import.
-
Carefully review the selected operation before starting the import.
-
Take extra care when using Replace or Delete operations.
-
Review the import results and error information after processing.
-
File properties such as Width, Height, Duration, Size, Size MB, Size Bytes, Status, and Errors may be system-generated or read-only depending on the current Migrato implementation.
-
The exact import behavior and supported writable fields may vary based on Shopify's current File API capabilities.
For the safest workflow, use a Migrato-generated File export as a reference when preparing data for a subsequent import.