Our first app, Migrato, is live on the Shopify App Store - free plan, no credit card. Take a look
Home / Documentation / Entity reference
Reference

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.

i
One template per entity

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.

Add new records only
Rows matching an existing record are skipped. Nothing that already exists can be changed.
Update existing records only
Rows without a match are skipped. Nothing new is created.
Add and update
Create what is missing and update what already exists.
Delete records in the sheet
Permanently removes the matched records. There is no recycle bin in Shopify.
!
Export-only entities

Payouts, Activity and Shop can be exported but not imported - Shopify does not allow apps to write them.

Next steps

  1. Importing data - how the sheet, the operation options and the result log fit together
  2. Field reference - the columns for the most-used entities
  3. Quick start - run a ten-row test import end to end

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