Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Introduction to Migrato
Getting Started

Introduction to Migrato

Everything you need to import, export, update and migrate Shopify store data with CSV and Excel files – start here.
10 min read Updated 9 October 2026 Applies to Migrato on all plans

Migrato is a Shopify bulk data management app that lets you import, export, update, delete, replace, merge and migrate Shopify store data using CSV and Excel (.xlsx) files.

You can manage Products and Variants, Customers, Orders, Draft Orders, Smart Collections, Custom Collections, Discounts, Inventory, Metaobject Definitions, Metaobjects, Metafield Definitions, Metafields, Locations, Pages, Blogs, Navigation Menus, Redirects, Files, Companies, Shop Data, Activity and Payouts. Migrato also supports FTP and SFTP connections, so you can work with files on external servers and automate recurring imports and exports with scheduled jobs.

Before you begin

Make sure you have the following in place before you use Migrato.

  • An active Shopify store
  • Migrato installed on your Shopify store
  • The required Shopify permissions to access and manage the data you want to process
  • A CSV or XLSX file, if you are planning to import data
  • FTP or SFTP server details, if you are planning to use a remote file server
★
Start with a small test file

If you are using Migrato for the first time, we recommend starting with a small test file before processing a large amount of data.

The Migrato workflow

Every job follows the same path. Depending on whether you are importing or exporting, some steps and options may vary.

  1. Select data. Choose the Shopify resource you want to manage.
  2. Choose operation. Import or export, then create, update, delete, replace or merge.
  3. Upload or configure data. Upload your file, or set filters and the file format for an export.
  4. Validate. Check the data for errors before it is processed.
  5. Process. Migrato runs the job and shows its progress and status.
  6. Review results. Check processed, successful and failed records in the job results.

Step 1: Open Migrato

After installing Migrato:

  1. Log in to your Shopify Admin.
  2. Go to Apps.
  3. Open Migrato.
  4. You are redirected to the Migrato dashboard, where you can reach the data management features and begin a new import or export job.

Step 2: Select the Shopify data

Choose the Shopify resource you want to manage: Products & Variants, Customers, Orders, Draft Orders, Smart Collections, Custom Collections, Discounts, Inventory, Metaobject Definitions, Metaobjects, Metafield Definitions, Metafields, Locations, Pages, Blogs, Navigation Menus, Redirects, Files, Companies, Shop, Activity or Payouts.

The available operations and fields may vary depending on the selected resource.

i
Each resource has its own documentation

Refer to the individual resource documentation for detailed information about supported fields, templates, filters and operations.

Import Shopify data

Use Import when you want to create or modify Shopify data using a CSV or XLSX file. Migrato handles bulk operations such as creating new records, updating existing records, deleting supported records, replacing or merging supported data, and migrating data.

Step 3: Select Import

From the Migrato dashboard:

  1. Select Import.
  2. Select the Shopify resource you want to import.
  3. Choose the appropriate operation – Create, Update, Delete, Replace or Merge, depending on the resource.

Step 4: Prepare your import file

Prepare your CSV or XLSX file according to the template and field requirements for the selected resource.

For example, when importing products your file may contain the information below. The exact fields depend on the resource and the data structure Migrato supports.
  • Product title, handle and description
  • Vendor, product type, tags and status
  • Variant information, SKU, price and inventory
  • Images, SEO information and metafields
Run through this list before uploading your file.
  • Column headers are correct and required fields are included
  • Data values are verified and there are no duplicate records
  • IDs, handles, SKUs or other identifiers are verified where applicable
  • Date and number formats are checked
  • Unnecessary rows and columns are removed
  • The file is saved in a supported format
Use the relevant Migrato demo or template file as a starting point when preparing your import data.
  • Download the demo CSV for your resource from the Demo CSV files page
  • Read the matching template documentation for each column
  • Add your data under the header row

Step 5: Upload the import file

Upload your prepared CSV or XLSX file to Migrato. After the file is uploaded, Migrato reads it and prepares the data for processing. Review the imported data and the available configuration options before continuing.

Upload the CSV or XLSX file prepared for the selected resource.
Upload the CSV or XLSX file prepared for the selected resource.

Step 6: Review and validate your data

Before starting the import, carefully review the data. Validation helps identify potential issues before the data is processed. Check for:

  • Missing required fields
  • Invalid values and incorrect formatting
  • Duplicate records and invalid identifiers
  • Unsupported data and resource-specific errors
!
Resolve validation errors first

If errors are identified, correct the source file and upload it again before proceeding. We recommend resolving validation errors before running a large import.

Step 7: Select the import operation

Select the operation that matches the purpose of your import.

Create
Use Create when you want to add new records to your Shopify store.
Update
Use Update when you want to modify existing Shopify records.
Delete
Use Delete when you want to remove supported records.
Replace
Use Replace when you want to replace supported existing data with the information provided in your import file.
Merge
Use Merge when you want to combine supported incoming data with existing Shopify data.
✕
Delete operations can permanently remove data

Always review your file carefully before proceeding.

i
Operations depend on the resource

The available operations depend on the selected Shopify resource.

Step 8: Start the import

After reviewing your file and settings, start the import process. Migrato processes the data and displays the progress and status of the job. For large datasets, processing time may vary depending on the amount of data and Shopify’s API processing requirements.

Step 9: Review import results

After the import is completed, review the job results. You can use the job information to check:

  • Overall job status
  • Number of records processed
  • Successfully processed and failed records
  • Error details and processing information

Export Shopify data

Use Export when you want to retrieve Shopify data and save it as a CSV or XLSX file. Exported data can be used for data backup, bulk editing, reporting, data analysis, store migration, data transfer and external system processing.

Step 10: Select Export

From the Migrato dashboard:

  1. Select Export.
  2. Select the Shopify resource you want to export.
  3. Configure the available export options and apply filters if required.
  4. Select the output file format and start the export.

Step 11: Apply export filters

For supported resources, you can use filters to export only the data you need – particularly useful for large Shopify stores. Depending on the resource, you can filter by IDs, status, created date, updated date and resource-specific fields, narrowing the export to a specific group of records instead of your entire dataset.

★
Filters keep large exports manageable

Using filters can make large export jobs easier to manage and reduce unnecessary data processing.

Step 12: Select the file format

CSV .csv
Useful for large datasets, data migration, system integrations and automated processing.
Excel .xlsx
Useful when you need to review data in Microsoft Excel, make bulk edits, analyse data or prepare data for another import.

Step 13: Start the export

After configuring the export:

  1. Review your selected resource.
  2. Review the filters.
  3. Confirm the output format.
  4. Press Start export. Migrato processes the requested data and generates the export file.

Step 14: Download and review the export

Once the export is completed, download the generated CSV or XLSX file and verify that the exported information is correct. You can then:

  • Use it as a backup
  • Edit it and import it again
  • Use it for migration
  • Share it with another system
  • Use it for reporting or analysis

Import and export using FTP/SFTP

Migrato supports connecting to third-party FTP and SFTP servers. This is useful when Shopify data needs to be exchanged regularly with an external system. For example, you may receive product or inventory files from:

  • Suppliers
  • ERP systems
  • Warehouses
  • Internal systems and external data providers

Schedule import and export jobs

If you need to perform the same import or export regularly, Migrato lets you schedule supported jobs. Scheduled jobs are useful for:

  • Daily inventory updates
  • Recurring product imports
  • Supplier data synchronisation
  • Scheduled order exports and regular data backups
  • External system data exchange
i
A typical automated workflow

FTP/SFTP file → Scheduled job → Migrato → Shopify, or Shopify → Scheduled export → FTP/SFTP server. For more information, see Scheduling import/export.

Monitor your jobs

Migrato provides job tracking and history so you can review previous import and export activities. Use the job history to monitor:

  • Job status and processing results
  • Successful and failed records
  • Error information
  • Previous import/export activities

If this is your first time using Migrato, we recommend following this workflow.

  1. Export existing data. Start by exporting a small amount of existing Shopify data.
  2. Review the export file. Open the CSV or XLSX file and understand the data structure.
  3. Download a demo or template file. Compare your exported file with the relevant Migrato template.
  4. Prepare a small test file. Create a file containing a small number of records.
  5. Run the import. Import the test file using the appropriate operation.
  6. Review the results. Check the Migrato job history and error information.
  7. Verify Shopify data. Open Shopify Admin and confirm that the imported or updated data is correct.
  8. Process the full dataset. Once the test is successful, proceed with the larger dataset.

Best practices

4 habits that keep every Migrato job safe.

Always test before a large importDo not immediately upload thousands of records when using Migrato for the first time. Test with a small dataset first.
Keep a backupBefore major Update, Delete, Replace or Merge operations, export the relevant Shopify data so you have a backup.
Use the correct templateUse the appropriate Migrato template for the resource you are importing.
Check your identifiersWhen updating records, make sure the identifiers in the import file match the Shopify records you want to modify.

Where to go next

If this is your first time with the app, follow these in order.

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