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 spreadsheets - start here.
  • Migrato is a Shopify app by Appifyo that moves store data in bulk using Excel (.xlsx) and CSV files. It works with seventeen Shopify entities: Products, Smart Collections, Custom Collections, Orders, Draft Orders, Customers, Companies, Discounts, Pages, Menus, Blog Posts, Metaobjects, Files, Redirects, Activity, Payouts and Shop.

    If you can use a spreadsheet, you can use Migrato. There is no API to learn, no developer required, and nothing to install on your computer - the app runs inside your Shopify admin.

What Migrato does

Three principles shape how the app behaves. They are worth knowing before you run anything, because they explain most of the design decisions you will encounter.

You choose what each job doesBefore a job runs you select the operation: add, update, add and update, or delete. The job does only what you selected.
Every job leaves a result logWhen a job finishes you get a log of every row - applied, updated or skipped - with the reason for each.
One sheet format per entityEvery entity has one documented sheet format. Download the template, add your values to the matching columns, and upload it - the column headers are the configuration.
Your store data stays yoursOfficial Shopify OAuth, encryption in transit and at rest, and your files removed when you uninstall - with the retention of job history under your control while the app is installed.
Migrato in three minutes A full import from file to finished job, narrated

Core concepts

Four terms come up throughout these docs. Getting them straight now will make everything else read faster.

Job
One run of an import or export. Jobs have an ID, a status, a result file and a full log. Everything you do in Migrato produces a job.
Data type
The kind of record you are moving - products, orders, customers and so on. One job handles one data type.
Item
A single row of data. Plan limits are counted in items per job, not per month, so you can run as many jobs as you like.
Import sheet
The CSV or Excel file you upload. Each entity has its own template, and the column headers must match it - they are named after the Shopify fields they write to.
i
Limits are per job, not per month

A Basic plan at 6,000 items will import a 6,000-row file, and and the next job can start as soon as it finishes. If a file is larger than your limit, split it into chunks or move up a plan for the month you need it. See Plans & limits.

  • The shape of every job

    Imports and exports follow the same four steps. Once you have done one, you have effectively done all of them.

    1. Upload the sheet. Upload your file, or point a scheduled job at a file URL it should fetch.
    2. Choose the operation. Add new records, update existing ones, do both, or delete the records listed in the sheet.
    3. Run the job. Migrato applies the sheet inside Shopify’s rate limits, in the order the rows appear.
    4. Read the result log. Every row is accounted for, with a reason for anything skipped. Download it, or have it emailed when the job finishes.
  • The seventeen entities

    Migrato works with the seventeen entities below. What each sheet contains is in the entity reference, and the column lists for the most-used ones are in the field reference.

Entity Import Export Matched on
Products Yes Yes Handle
Smart collections Yes Yes Handle
Custom collections Yes Yes Handle
Orders Yes Yes Order name
Draft orders Yes Yes Draft name
Customers Yes Yes Email
Companies Yes Yes Company name
Discounts Yes Yes Code
Pages Yes Yes Handle
Menus Yes Yes Handle
Blog posts Yes Yes Handle
Metaobjects Yes Yes Handle
Files Yes Yes File name
Redirects Yes Yes Path
Activity - Yes Job ID
Payouts - Yes Payout ID
Shop - Yes -
!
Some entities are export-only

Activity, Payouts and Shop can be exported but not imported - Shopify does not allow apps to write them. Orders can be imported, but Shopify limits what may be changed on an order that has already been paid.

Where to go next

If this is your first time with the app, follow these in order. Each page builds on the previous one and takes a few minutes.

  1. Install Migrato and understand the permissions it requests
  2. Run a ten-row test import to see the whole flow end to end
  3. Read the importing guide before you run a real file
  4. Check the plan limits against the size of your catalogue

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