The reference desk for online sellers
Codes

Shopify Product CSV Template: Column-by-Column Reference

Merchants assume the product CSV template is one fixed grid of columns, but the accessibility and browser data around ecommerce publishing shows the real risk sits in what gets typed into those columns, not in the columns themselves.

Reference · October 13, 2026 · 5 min read · AI-drafted from sourced data

Most merchants treat the Shopify product CSV template as a fixed spreadsheet with a fixed set of boxes to fill, and worry about getting the column order right. The column order rarely breaks anything, because Shopify’s importer matches by header name, not position. What actually causes problems downstream is what gets typed into fields like Body (HTML) and Image Alt Text, because that content becomes the actual markup on the live product page, and markup quality is exactly what accessibility audits and browser compatibility checks measure.

The template’s columns describe data, not the page a customer sees

A Shopify product CSV template carries columns such as Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name, Option1 Value, Option2 Name, Option2 Value, Variant SKU, Variant Grams, Variant Inventory Tracker, Variant Inventory Qty, Variant Price, Variant Compare At Price, Image Src, Image Position, and Image Alt Text. Rows share a Handle when they represent variants of the same product, so a shirt with three sizes needs three rows under one Handle value. The template itself does not enforce contrast ratios, does not enforce alt text length, and does not check that a form label exists on any custom field a theme adds. Those checks happen, if they happen at all, in whatever renders the theme, and that is a separate layer from the CSV.

Filled-in fields inherit the same accessibility gaps found across the wider web

The WebAIM Million check of one million home pages found that 83.9% of pages carry low contrast text, and that 53.1% are missing alternative text on images. A merchant pasting product descriptions with inline styling into Body (HTML), or leaving Image Alt Text blank across a bulk import of hundreds of rows, is reproducing the same pattern found across the broader web rather than something unique to Shopify. Missing form input labels sit at 51% in the same dataset, which matters less for the product CSV itself and more for any custom variant picker or quantity field a theme builds around the imported data. WCAG conformance across the checked pages sits at 95.9%, up from 94.8%, and the total number of detected errors rose 10.1% over the same comparison period, so the trend line is mixed: conformance rates edge up while raw error counts also climb, likely because pages carry more elements overall.

A column being present does not mean it gets used correctly

CSV columnWhat it controlsCommon gap found in wider accessibility checks
Image Alt TextAlt attribute on the product image tag53.1% of pages checked are missing alt text on images
Body (HTML)Main product description markup, including any inline stylingLow contrast text appears on 83.9% of pages checked
Option1/2/3 Name and ValueVariant selector labelsMissing form input labels found on 51% of pages checked

The table above lines up specific CSV columns against the failure rates found across the WebAIM Million dataset, not because the CSV causes the failure, but because the column is the point where a merchant’s choices become permanent markup. A blank Image Alt Text field produces an image with no alt attribute the same way a hand-coded page with no alt attribute does. The measurement gap is upstream of Shopify’s importer entirely.

Browser coverage is a separate check from column correctness

Once a CSV import publishes a product page, that page has to render somewhere, and it does not render only in the two most common engines. Browser usage tracking puts Samsung Internet at 0.614% of usage and groups a further 0.467% under an unlisted Other category. Neither figure is large on its own, but together they represent visits that a theme’s CSS or JavaScript, if written narrowly, might not handle the same way. This is not a CSV problem, since the CSV supplies text and numbers, not code, but it is a reason to preview an imported product on more than one browser before treating a bulk upload as finished.

The figures above come from two sources read independently on September 9, 2026: the WebAIM Million accessibility analysis of one million home pages, and the Can I Use browser usage frequency table for the same date. Neither source measures Shopify’s CSV importer directly; both describe the broader web that a CSV-built page ends up living on.

Share of checked pages with each accessibility issue0255075100Low contrast text83.9Missing alt text53.1Missing form labels51Method: WebAIM Million accessibility analysis of one million home pages, read September 9, 2026

What to do with a CSV before importing it

Fill Image Alt Text on every row that has an Image Src, since a blank field there reproduces the exact gap found on 53.1% of pages checked elsewhere. Preview the finished product page in more than one browser before calling the import finished, since Samsung Internet and other minor browsers together account for a small but nonzero share of real traffic.

Frequently asked questions

What columns does a Shopify product CSV template actually require?

The template ships with columns for Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name, Option1 Value, Variant SKU, Variant Price, and Image Src, among others. Handle is the one field every row needs because it groups variant rows under a single product. The facts available here do not cover Shopify's own field validation rules, so no claim is made about which columns are strictly mandatory versus optional in the current importer.

Does the CSV template have a column for alt text on images?

Yes, the template includes an Image Alt Text column tied to Image Src. Whether that column gets filled in is a separate question from whether it exists, and the WebAIM Million data shows 53.1% of pages checked are missing alternative text for images, which suggests the column is frequently left blank across the wider web rather than that the field is unavailable.

Will a CSV-built product page work the same in every browser?

The rendering depends on the theme, not the CSV, since the CSV only supplies data and the theme supplies markup. Browser usage data puts Samsung Internet at 0.614% and groups a further 0.467% under an unlisted Other category, so a small but real share of visits happen outside Chrome and Safari, and that share should factor into how a theme is tested before a bulk import goes live.

Why do accessibility numbers matter for a CSV import guide?

Because the columns in the CSV map directly onto elements that accessibility audits flag. Low contrast text appears on 83.9% of pages in the WebAIM Million check, missing form input labels on 51%, and the number of detected errors overall rose 10.1% year over year. None of that is caused by the CSV format itself, but a merchant filling in Body (HTML) with custom markup can just as easily introduce those same problems as any hand-coded page.

Is WCAG conformance improving across ecommerce sites generally?

The WebAIM Million dataset shows conformance at 95.9%, up from a prior figure of 94.8%. That is a market-wide number across a million home pages, not a Shopify-specific figure, so it should be read as background context on how markup quality is trending rather than a claim about CSV imports specifically.

Sources & data

  1. WebAIM Million accessibility analysis of one million home pages (checked September 9, 2026)
  2. Can I Use browser usage frequency table (checked September 9, 2026)
  3. WebAIM Million accessibility analysis, year-over-year error comparison (checked September 9, 2026)
Cite this report: Ecom Almanac Research Desk (2026). “Shopify Product CSV Template: Column-by-Column Reference.” Ecom Almanac. https://ecomalmanac.com/codes/shopify-product-csv-template-column-by-column-reference/
Figures on this page are our own measurements. You may quote them and reproduce a single table or chart, provided you include a visible, followable link to this page. Full terms: Reuse & citation.