The standard variant-rows export includes a dedicated sku column for every single variant - handy for reconciling against a warehouse system, checking for duplicate or missing SKUs across a catalog, or feeding a barcode-generation workflow.

Because it’s one row per variant, a product with five color options shows five SKUs, not one - exactly the granularity most inventory tools expect.

Some products may have no SKU set at all in the store; those cells simply come through empty rather than as the text "null", so you can filter for them directly in a spreadsheet.

This is also a fast way to spot a data-quality problem before it causes trouble elsewhere: filter the sku column for blanks, and you’ve got a ready-made list of exactly which variants are missing one, across the whole catalog at once rather than checking product pages one by one.

SKUs are set by the merchant, not generated by Shopify, so their format varies a lot from store to store - some use a clean internal system, others reuse a supplier’s original code, and some skip them entirely on smaller catalogs. This export doesn’t normalize or validate the format in any way; it simply reports exactly what each store has on file.