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.
Run your first import in under five minutes, using a ten-row test file.
Start hereImport options, create versus update, validation rules and images.
Read the guideFilters, custom columns, formats and scheduled delivery.
Read the guideWooCommerce, Magento, BigCommerce, Wix, Etsy and Squarespace.
Read the guideEvery supported column, what it does, and whether it is required.
Look up a fieldCommon errors, what causes them, and exactly how to fix each one.
Find a fixWhat 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.
Core concepts
Four terms come up throughout these docs. Getting them straight now will make everything else read faster.
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.
- Upload the sheet. Upload your file, or point a scheduled job at a file URL it should fetch.
- Choose the operation. Add new records, update existing ones, do both, or delete the records listed in the sheet.
- Run the job. Migrato applies the sheet inside Shopify’s rate limits, in the order the rows appear.
- 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 | - |
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.
- Install Migrato and understand the permissions it requests
- Run a ten-row test import to see the whole flow end to end
- Read the importing guide before you run a real file
- Check the plan limits against the size of your catalogue