Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Import and Migrate products via CSV and XLSX Files
Migration

Import and Migrate products via CSV and XLSX Files

Migrate product data into Shopify from a CSV or XLSX file built on the Migrato Product Template.
7 min read Updated 13 October 2026 Applies to Migrato on all plans

Migrato provides migration features that help you transfer Shopify data from external files, FTP/SFTP sources, or another Shopify store. You can use migration workflows to import product data in bulk, transfer product files from external systems, migrate data between Shopify stores, and move supported Shopify content from one store to another.

Migration can be useful when setting up a new Shopify store, moving data from an existing platform, transferring products between Shopify stores, updating large product catalogs, or moving supported store content in bulk.

★
Before starting a migration

Review the relevant Migrato template documentation, prepare a backup of the source data where appropriate, and test the migration with a small dataset before processing the complete dataset.

What you can migrate

Migrato allows you to import and migrate Shopify product data using CSV and XLSX files.

This method is useful when product information is already available in a spreadsheet, when migrating products from another platform, or when product data needs to be prepared and reviewed before being imported into Shopify.

You can use a product file to migrate information such as:

  • Product details
  • Product handles
  • Product descriptions
  • Vendors
  • Product types
  • Tags
  • Variants
  • SKUs
  • Prices
  • Inventory information
  • Product images
  • Collections
  • Metafields
  • Other supported product fields
i
Available fields

The fields available for migration depend on the current Migrato Product Template and the Shopify data supported by Migrato.

Step 1: Prepare the product file

Prepare your product data in a supported file format: CSV or XLSX.

Use the Migrato Product Template as the reference for column names and expected values.

The Migrato Product Template.
The Migrato Product Template.

Make sure that:

  1. The required columns are included.
  2. Column names follow the Migrato template.
  3. Product and variant information is structured correctly.
  4. Values are entered in the expected format.
  5. Image URLs are accessible if products contain external images.
  6. Existing product identifiers are retained where required for updates.

Step 2: Open product import

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Import section.
  3. Select Products.
  4. Upload the prepared product file.
Select Products in the Import section.
Select Products in the Import section.

Step 3: Upload the CSV or XLSX file

Migrato supports importing product information from a CSV or XLSX file. You can upload the file through the import interface.

After the file is uploaded, Migrato reads the available sheets and product data.

Upload the prepared product file.
Upload the prepared product file.

Step 4: Review the product data

Review the imported product sheet before starting the migration.

Check:

  • Product rows
  • Product identifiers
  • Handles
  • Variant information
  • Image URLs
  • Prices
  • Inventory
  • Collections
  • Metafields
  • Other supported product fields

Correct the source file if any required information is missing or incorrectly formatted.

Preview the product data before migrating.
Preview the product data before migrating.

Step 5: Select the migration operation

Select the appropriate operation based on how you want Migrato to handle the product records.

Depending on the supported configuration, operations may include:

Operation Purpose
Merge Updates existing products and creates new products.
Create only Creates new products and does not update existing products.
Update only Updates matching products without creating new products.
Replace Replaces matching existing product records with the imported data.
Delete Deletes matching product records.
Choose how Migrato handles the product records.
Choose how Migrato handles the product records.
!
Check the operation before you start

Carefully review the selected operation before starting a migration. Extra care should be taken when using Replace or Delete.

Step 6: Configure import options

Open the Options section to configure additional settings available for the product migration.

Depending on the Migrato configuration, options may include scheduling and result-file settings.

Scheduling and result-file options.
Scheduling and result-file options.

Step 7: Start the product migration

After reviewing the product data and selected operation:

  1. Review the imported file.
  2. Confirm the selected operation.
  3. Review the available options.
  4. Click Import.

Migrato will process the product migration.

Step 8: Monitor the migration

Migrato processes the migration as a job. You can monitor the job status and processing information from the All Jobs section.

The migration job in All Jobs.
The migration job in All Jobs.

Step 9: Review migration results

After the migration is completed, review the import results.

The results can include:

  • Total records
  • Successfully imported records
  • Failed records
  • Skipped records
  • Processing duration
  • Error information
  • Result file

If errors are reported, correct the source data and run the migration again.

Review the results of the migration.
Review the results of the migration.

Example: Product migration using XLSX

A typical product migration workflow can be:

  1. Prepare the product XLSX file.
  2. Review the Product Template Documentation.
  3. Upload the XLSX file to Migrato.
  4. Review the product data.
  5. Select Merge to update existing products and create new products.
  6. Start the import.
  7. Monitor the migration job.
  8. Review the migration results.

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