Entity reference
Every entity Migrato can move, the key it matches on, and what its sheet contains.-
Migrato works with seventeen Shopify entities. Each one has its own import and export sheet, with column headers named after the Shopify fields they write to. Pick an entity below to see what its sheet contains and which key it matches on.
Download the template from Import → Templates inside the app. An export of the same entity comes back in the same format, so an export can be edited and uploaded straight back as an update.
-
Catalogue
4 entities in this group
| Entity | Matched on | What the sheet contains |
|---|---|---|
| Products | Handle |
Products, their variants, options, prices, images and inventory quantity. |
| Smart collections | Handle |
Rule-based collections, including the conditions that decide membership. |
| Custom collections | Handle |
Manually curated collections and the products that belong to them. |
| Metaobjects | Handle |
Custom structured content defined under Settings → Custom data. |
-
Customers
2 entities in this group
| Entity | Matched on | What the sheet contains |
|---|---|---|
| Customers | Email |
Customer records, addresses, tags and notes. |
| Companies | Company name |
B2B company accounts, their locations and assigned contacts. |
-
Sales
4 entities in this group
| Entity | Matched on | What the sheet contains |
|---|---|---|
| Orders | Order name |
Live and historical orders with line items, totals, taxes and fulfilment status. |
| Draft orders | Draft name |
Draft orders and their line items, before they become orders. |
| Discounts | Code |
Discount codes and automatic discounts, with their conditions. |
| Payouts | Payout ID |
Shopify Payments payouts and their transactions. Export only. |
-
Content
5 entities in this group
| Entity | Matched on | What the sheet contains |
|---|---|---|
| Pages | Handle |
Store pages and their HTML body, SEO fields and visibility. |
| Blog posts | Handle |
Blogs and their articles, including author, tags and publish state. |
| Menus | Handle |
Navigation menus and the items inside them. |
| Files | File name |
Media library files and their alt text. |
| Redirects | Path |
URL redirects - the old path and where it now points. |
-
Store
2 entities in this group
| Entity | Matched on | What the sheet contains |
|---|---|---|
| Activity | Job ID |
The record of every job run in Migrato, with its result. Export only. |
| Shop | - |
Store-level settings and details as a single record. Export only. |
Operations available on every entity
After you upload a sheet, and before the job starts, you choose what it should do. The same four options are available for every entity that supports importing.
Payouts, Activity and Shop can be exported but not imported - Shopify does not allow apps to write them.
Next steps
- Importing data - how the sheet, the operation options and the result log fit together
- Field reference - the columns for the most-used entities
- Quick start - run a ten-row test import end to end