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.
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. |
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 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. |
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:
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
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.