The Complete Guide to Shopify CSV Imports for Agencies

If you manage Shopify stores for multiple clients, you're probably importing product catalogs from supplier spreadsheets regularly. This guide covers everything you need to know about Shopify's CSV format, the most common import errors, and how to go from a messy supplier file to a clean import in the shortest possible time.

Shopify's CSV format requirements — Shopify expects a specific set of column names. The most important ones are Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Variant SKU, Variant Price, Variant Inventory Qty, and Image Src. Every product must have a Handle — a URL-friendly unique identifier derived from the product title or SKU.

Variant structure — Shopify's CSV uses a multi-row structure for products with variants. The first row contains all product-level information. Subsequent rows with the same Handle contain only variant-level information and are treated as variants of the first row. Supplier files almost never arrive in this structure — converting between formats is where most manual work happens.

The most common import errors — Missing required columns cause the import to fail entirely. Invalid image URLs import without error but result in products with no images. Price formatting issues (currency symbols, commas as decimal separators) cause prices to import as zero or fail silently.

The fastest workflow for agencies — Run the supplier file through a normalization step first. Map the supplier's column names to Shopify's expected names, check for duplicates and price anomalies, then generate the formatted CSV. This catches the majority of import errors before they reach Shopify and takes minutes instead of hours of manual reformatting.