Every export from this tool has the same columns, in the same order, one row per variant. This reference explains what each one contains, where it comes from in Shopify, and the quirks worth knowing before you build a report on it. For the background on why rows are per variant, see variants, SKUs and options.
Column reference
| Column | What it contains |
|---|---|
product_id | Shopify's numeric ID for the product. The same on every variant row of that product, so it is the key for grouping rows back into products. |
title | The product name as shown on the store. |
url | Link to the product page, built from the store's domain and the product handle. |
image | The variant's own image if it has one (often the colour shot), otherwise the product's first image. |
vendor | The brand or supplier the merchant assigned. Many single-brand stores put their own name here on every product. |
product_type | The merchant's category label, such as "Sneakers" or "Rings". Free text, so spelling varies between stores. |
variant_title | The variant's display name, usually its option values joined with slashes, e.g. "Navy / 9". "Default Title" means the product has no options. |
option1, option2, option3 | The values for each option axis, in order. The axis names are in the options column. |
sku | The merchant's own stock-keeping unit code. Can be blank: SKUs are optional in Shopify. |
variant_id | Shopify's numeric ID for this exact variant. Unique and stable, which makes it the best key for comparing snapshots over time. |
price | Current selling price in the store's default currency. |
compare_at_price | The "was" price shown crossed out, if the merchant set one. Often blank, and sometimes left equal to the price. |
discount_pct | Percentage off, calculated as (compare_at_price − price) ÷ compare_at_price. Only filled when the compare-at price is genuinely higher than the price. |
available | true if this variant can be bought right now, false if it is sold out. Not a stock count. |
grams | Shipping weight in grams as entered by the merchant. Frequently 0 when not configured. |
requires_shipping | false for digital goods, gift cards and services. |
taxable | Whether tax is charged on this variant. |
position | The variant's order within the product, starting at 1. |
options | The names of the product's option axes, e.g. "Color / Size". Matches option1, option2 and option3 in order. |
tags | The merchant's tags, comma-separated. Technical tags added by apps (those containing "::") are removed to keep this readable. |
handle | The URL slug of the product, unique within the store. |
image_count | How many images the product has. Useful for spotting listings with no photos. |
published_at | When the product was made visible on the online store. |
created_at | When the product was first created in the store's admin. |
updated_at | When anything on the product last changed, including price or stock. |
variant_updated_at | When this specific variant last changed. |
description | The product description converted from HTML to plain text. May be omitted for very large catalogues to keep responses within size limits. |
Quirks worth knowing
Blank is not the same as zero
An empty compare_at_price means no “was” price was set. An empty sku means the merchant never entered one. Neither is an error in the export. When you calculate averages, make sure your spreadsheet treats blanks as missing rather than as 0.
Discounts the store did not mean
Plenty of stores leave the compare-at price equal to the price, or even below it, after a sale ends. Showing those as “0% off” or a negative discount would be misleading, so discount_pct is only filled when there is a real reduction.
Dates are in ISO 8601
Timestamps look like 2026-03-14T09:30:00-04:00, including the store’s time zone offset. Google Sheets and Excel recognise the date part; if you need it as a true date, take the first ten characters with LEFT(cell, 10) and convert with DATEVALUE.
Prices are in one currency
All prices are in the store’s default currency, shown above the results table. If you compare stores that sell in different currencies, convert before comparing.
IDs are long numbers
product_id and variant_id are 13 or 14 digits long. Import them as text so your spreadsheet does not round them or switch to scientific notation. The CSV export guide shows how.
Choosing a key
To join two exports, for instance last month’s and this month’s, use variant_id. It never changes for the life of the variant, whereas SKUs can be blank, duplicated or renamed by the merchant. To roll variants up to products, group on product_id.