- query
- The store or collection link you submitted, repeated on every row that came from it - so a run across several shops still reconciles against your input list.
- id
- The store’s product id. It is product-level, so it repeats across every variant of the same product - which makes it the column to group on when you want products rather than rows.
- title
- The product title. Product-level, and therefore repeated across that product’s variants.
- handle
- The product’s URL slug - the last part of its product page address, and a stable key that survives a title being reworded.
- body_html
- The product description as the store publishes it, markup and all.
- published_at
- When the product was published to the storefront, as an ISO 8601 timestamp with a UTC offset.
- created_at
- When the product record was created, in the same ISO 8601 form.
- updated_at
- When it was last changed, in the same ISO 8601 form. The column to sort on when you want to know what a shop has been touching.
- vendor
- The vendor the store files the product under - often the shop’s own brand rather than a third party.
- product_type
- The product type as the store classifies it.
- tags
- The product’s tags, as one comma-separated string rather than as a list.
- variants
- The full variant structure for the product, carried through as JSON in a single cell. Parse it if you need the other variants; the row you are on is already one of them.
- images
- The product’s image records, likewise carried through as JSON in one cell.
- options
- The option definitions - what the store calls its size, colour or material axes and the values each one allows - again as JSON.
- price
- The price of this variant, as text with two decimals and no currency symbol. Cast it before you compare or total.
- compare_at_price
- The was-price, where the store sets one. Its presence is what marks a variant as being on offer.
- currency
- The currency the price is quoted in.
- sku
- The store’s stock code for this exact variant. It is the closest thing the export has to a per-row key.
- available
- Whether this variant can be bought, as the lowercase word
yes or no. - variant
- The variant itself, as the store labels it - the option values joined together, like a colour and a size.
- url
- A link to the product page. Product-level, so it repeats across the product’s variants.
- image
- A link to the product image, and the last column in the file.