Shopify Catalogue Scraper

Guide

Every column in a Shopify catalogue export, explained

6 min read, published 16 November 2026

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

ColumnWhat it contains
product_idShopify'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.
titleThe product name as shown on the store.
urlLink to the product page, built from the store's domain and the product handle.
imageThe variant's own image if it has one (often the colour shot), otherwise the product's first image.
vendorThe brand or supplier the merchant assigned. Many single-brand stores put their own name here on every product.
product_typeThe merchant's category label, such as "Sneakers" or "Rings". Free text, so spelling varies between stores.
variant_titleThe 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, option3The values for each option axis, in order. The axis names are in the options column.
skuThe merchant's own stock-keeping unit code. Can be blank: SKUs are optional in Shopify.
variant_idShopify's numeric ID for this exact variant. Unique and stable, which makes it the best key for comparing snapshots over time.
priceCurrent selling price in the store's default currency.
compare_at_priceThe "was" price shown crossed out, if the merchant set one. Often blank, and sometimes left equal to the price.
discount_pctPercentage off, calculated as (compare_at_price − price) ÷ compare_at_price. Only filled when the compare-at price is genuinely higher than the price.
availabletrue if this variant can be bought right now, false if it is sold out. Not a stock count.
gramsShipping weight in grams as entered by the merchant. Frequently 0 when not configured.
requires_shippingfalse for digital goods, gift cards and services.
taxableWhether tax is charged on this variant.
positionThe variant's order within the product, starting at 1.
optionsThe names of the product's option axes, e.g. "Color / Size". Matches option1, option2 and option3 in order.
tagsThe merchant's tags, comma-separated. Technical tags added by apps (those containing "::") are removed to keep this readable.
handleThe URL slug of the product, unique within the store.
image_countHow many images the product has. Useful for spotting listings with no photos.
published_atWhen the product was made visible on the online store.
created_atWhen the product was first created in the store's admin.
updated_atWhen anything on the product last changed, including price or stock.
variant_updated_atWhen this specific variant last changed.
descriptionThe 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.