Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Import / Export Products
Product Import/Export

Import / Export Products

Product Import/Export (with Variants, Inventory, Images, Metadata, etc.)

Migrato allows you to import and export Shopify products in bulk using CSV or Excel (XLSX) files.

You can manage product information including products, variants, inventory, prices, images, SEO data, metafields, and other supported product information from a single import or export process.

This guide explains how to import and export products using Migrato.

Products Import Video Demonstration
Products Import Video Demonstration

Export Products

You can use Migrato to export your Shopify product data to a CSV or XLSX file.

Step 1: Select Products

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Export section.
  3. Select file Format as Excel or CSV.
  4. Select Products as the data type.
Migrato Export – Select Products
Migrato Export – Select Products

Step 2: Select Export Fields

After selecting Products & choose the product fields you want to include in the export.

You can export the available product information, including supported: Product IDs, Handles, Variants, SKU, Price, Compare-at price, Inventory, Images, Product status, Tags, Vendor, Product type, SEO information, Metafields, Other supported product data.

Migrato Product Export – Select Fields
Migrato Product Export – Select Fields

You can select the fields required for your export instead of exporting every available field.

i

The available fields depend on the product data supported by Migrato and Shopify.

For a complete list of product fields, see Product Template Documentation.

Step 3: Apply Product Filters

Migrato allows you to apply filters when exporting products so you can export only the products that match your requirements.

For example, you can use the available filters to select specific products based on supported product information.

Migrato Product Export – Filters
Migrato Product Export – Filters

Filters are especially useful when working with large product catalogs and when you do not need to export the entire catalog.

 

For more information, see Filter Products.

 

Step 4: Select the File Format

Choose the required export format: CSV or XLSX

Migrato Product Export – File Format
Migrato Product Export – File Format

CSV is useful for data migration and system-based processing, while XLSX can be useful when you want to review or edit the exported product data using Microsoft Excel.

Step 5: Export Products

After configuring the export:

  1. Review the selected product fields.
  2. Review the applied filters.
  3. Select the required file format.
  4. Click Export.
Migrato – Export Products Button
Migrato – Export Products Button

Migrato will start processing the product export.

You can monitor the progress of the export job from the application.

Step 6: Download the Exported File

Once the export is completed, the job status will be updated accordingly.

You can then download the generated CSV or XLSX file.

Migrato – Completed Product Export
Migrato – Completed Product Export

The exported file can be used for:

  • Backup
  • Bulk editing
  • Reporting
  • Store migration
  • Updating products
  • Importing products into another Shopify store

Import Products

Migrato allows you to bulk import Shopify products using CSV or XLSX files. You can also import a product file directly from a publicly accessible URL.

Depending on your requirements, you can use Migrato to create new products, update existing products, merge existing and new products, replace existing products, or delete products in bulk.

The product import process also supports product-related data such as variants, inventory, images, collections, pricing, custom information, multi-location inventory, and metafields, based on the fields supported by the selected product template.

i

Before importing: We recommend downloading the Product Demo CSV/XLSX or reviewing the Product Template Documentation to understand the supported fields and required data structure.

Step 1: Upload or Provide the Product File

From your Shopify Admin:

  1. Go to Apps → Migrato.
  2. Open the Import section.
  3. Add your product file by clicking Add files, or drag and drop the file into the upload area.
  4. Migrato supports: CSV (.csv), Excel (.xlsx), Excel (.xls)
  5. Alternatively, you can provide the publicly accessible URL of a product file and upload the file directly from the URL.
Migrato Import – Upload Product File
Migrato Import – Upload Product File

Import Using a File Upload

You can upload a product file directly from your computer by clicking Add files or dragging and dropping the file into the upload area.

For example:

  • products.csv
  • products.xlsx
  • products.xls

Import Using a File URL

If your product file is hosted on a third-party server, you can provide its publicly accessible URL instead of downloading the file to your computer.

For example:

https://example.com/products.csv

Select Server URL, enter the complete file URL, and click Upload from URL.

i

Note: The file URL must be publicly accessible to Migrato. Make sure the URL points directly to the file and that the file is available for download.

Step 2: Review the Imported File

After the file is uploaded or retrieved from the provided URL, Migrato creates an import job and displays the Import Details page.

The Import Details section provides information such as:

  • Import ID
  • Import State
  • File Format
  • Selected Operation
  • Uploaded File
  • File Size
Migrato – Import Details
Migrato – Import Details

For example, the import page may display:

  • State: Ready to import
  • Format: CSV
  • Operation: Merge
  • Uploaded file: products.csv

The uploaded file is also displayed under the Sheets section.

Step 3: Review the Product Sheet

Under Sheets, Migrato displays the entity detected from the uploaded file.

For a product import, the sheet is displayed as Products.

The sheet section provides information about the imported data and its current processing status.

Migrato – Products Sheet
Migrato – Products Sheet

The sheet may display information such as:

  • Entity name
  • Source file name
  • Processing status
  • Total records
i

Note: Migrato identifies the entity type from the uploaded file and prepares the corresponding import workflow.

Step 4: Select the Import Operation

Migrato allows you to select how the product data should be applied to your Shopify store.

Under Operations, select the appropriate operation from the available options.

Migrato – Product Import Operations
Migrato – Product Import Operations

The available operations are:

Merge – Update Existing, Create New

The Merge operation updates existing products and creates new products that do not already exist.

Use this option when you want to synchronize your product file with your Shopify store.

For example:

  • Existing product → Updated
  • New product → Created
i

Recommended: Merge is useful for regular product updates where the same file may contain both existing and new products.

Create Only – Skip if Handle Exists

The Create only operation creates new products and skips products whose handle already exists in the Shopify store.

Use this option when you only want to add new products without modifying existing products.

For example:

  • Existing product → Skipped
  • New product → Created

Update Only – Skip if Handle Missing

The Update only operation updates existing products and skips products that cannot be matched to an existing Shopify product.

Use this option when you want to update an existing catalog without creating new products.

For example:

  • Existing product → Updated
  • Product not found → Skipped

Replace – Delete Existing, Then Create from File

The Replace operation deletes the existing product and then creates the product again using the information provided in the import file.

Use this operation carefully, particularly when working with a live store.

For example:

  • Existing product → Deleted
  • Product from import file → Created
i

Warning: Replace can modify or remove existing product data. We recommend testing the operation with a small dataset before processing a large product catalog.

Delete – Delete if Exists

The Delete operation deletes products that exist in your Shopify store and match the records in the import file.

Use this operation when you need to remove products in bulk.

For example:

  • Existing product → Deleted
  • Product not found → No product is deleted
i

Warning: Deleting products can be destructive. Always verify your import file and selected operation before starting the job.

Step 5: Configure Import Options

After selecting the required operation, expand the Options section to configure additional settings for the import job.

Migrato – Import Options
Migrato – Import Options

Depending on the available configuration, the Options section can include settings for:

  • Scheduling
  • Results File

Scheduling

Migrato allows you to schedule an import instead of running it immediately.

You can configure:

  • Schedule on – Select the date and time when the import should start.
  • Repeat every – Configure the interval at which the import should repeat.
  • Run until – Specify how long or how many times the scheduled job should run.
Migrato – Import Scheduling Options
Migrato – Import Scheduling Options

Scheduled imports are useful when product data needs to be updated regularly from an external source.

For example, you can use scheduled imports for:

  • Supplier product feeds
  • Regular catalog updates
  • Inventory updates
  • Recurring product data synchronization
i

Note: Scheduling options may depend on your Migrato plan and the available app configuration.

Results File

Migrato can generate a results file after processing the import.

The Results File section allows you to configure how the result file should be generated and stored.

Depending on the available options, you can configure:

  • Custom file name
  • File name time source
  • File type
  • ZIP CSV file
  • Upload destination
Migrato – Results File Options
Migrato – Results File Options

You can also use Dynamic placeholders when creating a custom results-file name.

This can help you identify the results of individual import jobs, particularly when imports are scheduled or repeated.

Step 6: Start the Product Import

After reviewing the file and selecting the required operation:

  1. Review the Import Details.
  2. Verify the uploaded product file.
  3. Review the Products sheet.
  4. Confirm the selected Operation.
  5. Review the Options.
  6. If required, configure the import schedule.
  7. Click Import.

The Import button is available at the top-right and bottom-right of the import page.

Migrato – Import Products Button
Migrato – Import Products Button

Migrato will begin processing the product import according to the selected operation and configuration.

Step 7: Monitor the Import Job

After starting the import, Migrato processes the product records and updates the import job status.

You can monitor the job from the import details page and review the processing information for the Products sheet.

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