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

Field reference

Every supported column for the main data types - what it does, whether it is required, and the format Shopify expects.
  • This page lists the most-used columns for each data type. Download the full template from inside the app for the complete set, including every metafield variant.

i
Only include what you need

Columns you leave out are never touched. A file with four columns is safer than a file with sixty, so build narrow files for narrow jobs.

Products and variants

Column Required Description and example
Handle REQUIRED Unique URL identifier, lowercase with hyphens. blue-cotton-tshirt
Title REQUIRED* Product name. Required when creating; optional when updating. Blue Cotton T-Shirt
Body (HTML) optional Description. HTML allowed. Shortcodes from other platforms will not render.
Vendor optional Acme Apparel. Created automatically if new.
Type optional Product type. T-Shirts
Tags optional Comma-separated. summer, cotton, sale
Published optional TRUE or FALSE
Status optional active, draft or archived
Option1 Name optional Size. Up to three options per product.
Option1 Value optional Medium. Must be unique per variant combination.
Variant SKU optional Stock keeping unit. Also usable as the match key.
Variant Price REQUIRED* Required when creating. 29.99 - no currency symbol, dot decimal.
Variant Compare At Price optional The struck-through "was" price. 39.99
Variant Inventory Qty optional Stock level. Per-location columns are supported.
Variant Barcode optional ISBN, UPC, GTIN or EAN.
Variant Weight optional Numeric. Pair with Variant Weight Unit.
Variant Requires Shipping optional TRUE / FALSE. Set false for digital goods.
Variant Taxable optional TRUE / FALSE
Image Src optional Public image URL. Semicolon-separate for several.
Image Position optional Integer starting at 1.
Image Alt Text optional Accessibility and SEO text.
SEO Title optional Search listing title, 70 characters or fewer.
SEO Description optional Search listing description, 320 characters or fewer.
Command optional UPDATE (default), REPLACE or DELETE.
i
Compatible with Shopify's own CSV

Migrato's product columns are a superset of Shopify's built-in product CSV format. Any file that works with Shopify's native importer works here too - you simply get more columns available.

Customers

Column Required Description
Email REQUIRED Match key. One customer per email address.
First Name / Last Name optional Name fields.
Phone optional E.164 format recommended. +441632960123
Tags optional Comma-separated customer tags.
Tags optional Comma-separated.
Note optional Internal note visible to staff.
Address1, City, Zip, Country Code optional Default address. Use two-letter country codes.
Tax Exempt optional TRUE / FALSE
✕
Customer data is a legal matter, not just a column

Customer records you import are personal data. Import only what you are entitled to hold, and remember that you remain the data controller for everything in your store.

Orders

Column Required Description
Name REQUIRED Order name including the hash. #1001
Email optional Links the order to a customer profile.
Created At optional ISO date. 2026-07-14T10:32:00Z
Financial Status optional paid, pending, refunded, voided
Fulfillment Status optional fulfilled, partial, or blank
Lineitem SKU optional One row per line item, repeating Name.
Lineitem Quantity optional Integer.
Lineitem Price optional Unit price at the time of sale.
Shipping, Taxes, Total optional Order-level money fields, on the first row of the order.
Tags, Note optional Updatable on existing orders.

Inventory

Column Required Description
Variant SKU REQUIRED Identifies the variant.
Location REQUIRED Location name exactly as it appears in your admin.
Available optional Absolute quantity. Sets the level rather than adjusting it.
Adjust optional Relative change. -3 reduces stock by three.
!
Available sets, Adjust changes

Use one or the other, never both in the same file. Available overwrites whatever is there; Adjust applies a delta to it. Mixing them in one job produces results nobody can predict.

Collections

Column Required Description
Handle REQUIRED Collection URL identifier.
Title REQUIRED* Required when creating.
Body (HTML) optional Collection description.
Collection Type optional custom or smart
Rule: Column/Relation/Condition optional Smart collection rules, one set per row.
Product Handle optional For custom collections, one product per row.
Sort Order optional best-selling, alpha-asc, price-desc and others.

Metafield columns carry namespace, key and type in the header itself:

Header format
Metafield: namespace.key [type]
Type Value format
single_line_text_field Plain text
multi_line_text_field Plain text, newlines preserved
number_integer 10
number_decimal 10.5 - dot decimal only
boolean true or false, lowercase
date 2026-08-18
date_time 2026-08-18T09:00:00Z
json Valid JSON, quoted correctly for the file format
list.* JSON array. ["Cotton","Linen"]
product_reference gid://shopify/Product/1234567890
file_reference gid://shopify/MediaImage/1234567890

The Command column

UPDATE
Default. Creates the record if it does not exist, updates it if it does. Only columns present in the file are changed.
REPLACE
Replaces the whole record with what is in the file. Fields absent from the file are cleared. Use with care.
DELETE
Removes the record permanently. Only the match key column is needed.
IGNORE
Skips the row entirely. Useful for keeping notes or draft rows in a working file.
✕
REPLACE and DELETE are not reversible

There is no recycle bin in Shopify. Run either command on a ten-row slice first, confirm the outcome in your admin, and keep a pre-change export before you run the full file.

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