Shopify product CSV: a short field guide

Formats this checker covers

Choose an English product CSV saved as comma-separated UTF-8, up to 15 MB. Put Shopify product headings on the first row. For new products, Shopify requires a Title column; add URL handle when there are variants. For updates, include both columns. If an update includes variant fields such as SKU or Price, include Option1 name and Option1 value too. Shopify product CSV format · Shopify import and size guidance

The checker recognizes current product headings, common older headings (with a warning), market headings such as Price / Europe, and product metafield headings. Shopify documents older heading compatibility, market columns, and product metafields; variant metafields are outside product CSV import/export. Shopify heading and metafield guidance

For a product with variants, use its first row for product details, then keep the same handle on later variant rows and leave the later titles blank. Shopify also describes extra image rows with the same handle. See the multi-variant sample CSV; its example image URLs are placeholders and have not been tested for reachability. Shopify row layout

Try the retained files

• Good product CSV and multi-variant CSV: the checker reports no findings in new-product mode. They are checker fixtures, not verified Shopify imports.
• Bad product CSV: row 2 has a handle with a space and a currency-marked price; row 4 repeats row 3’s Size option; row 6 has an unclosed quote. Its unknown heading is on row 1. Shopify handle and price rules · Shopify option and quote issues
• Invalid import CSV: row 2 has a fixed market compare-at price without its fixed market price, an invalid Status, a nonnumeric inventory quantity, and incomplete packed size. Row 3 repeats a variant option. Shopify field dependencies · Shopify duplicate-option issue
• Retained new-product CSV and retained update CSV: each has zero checker findings in its matching mode. No Shopify store import has been performed with these files. In an overwrite, an included blank non-required column can clear existing data; an omitted column leaves it unchanged. Back up product data and review the import details before importing. Shopify import and overwrite guidance

What a clear report cannot tell you

This checker tests CSV structure and selected product fields. It does not inspect your store, existing products or variants, market setup, metafield definitions or values, or whether an image URL is reachable. Shopify requires external image URLs to be publicly accessible and documents import failures from invalid product references; those need store or network context. Shopify image guidance · Shopify reference errors

A blank price or tracked quantity may get a warning: Shopify’s format guide describes defaults, while its troubleshooting guide also lists related blank-value errors. The checker cannot settle that difference for a particular import. Back up, review the import details, and inspect the imported products afterward. Shopify field defaults · Shopify blank-value errors · Shopify import steps

← Back to the checker