Import / Export Shop Data
How to import and export shop data in bulk with CSV and XLSX files.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.
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:
- Go to Apps → Migrato.
- Open the Import section.
- Select Shop as the entity to import.
- Add the Shop file you want to 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
Option 2: Import from a Public URL
You can also provide the full publicly accessible URL of the Shop file.
For example:
https://example.com/shop.csv
Enter the URL and select Upload from URL.
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
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.
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.
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.
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.
Step 8: Start the Shop 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 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
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:
- Go to Apps → Migrato.
- Open the Export section.
- Select Shop.
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
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.
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
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.
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.