Product CSV Generator

How This Tool Works

Enter your product details in the form above, including the handle (which becomes the URL slug), title, description, vendor, product type, and tags. Then fill in at least one variant row with pricing, SKU, and inventory details. Click “Add Variant” if your product comes in multiple sizes, colors, or other options.

When you click Generate CSV, the tool builds a file that matches Shopify’s exact product CSV specification. The first variant row includes all product-level information (title, description, vendor, tags, image), while subsequent variant rows only include variant-specific fields. This is exactly how Shopify expects multi-variant products to be structured.

The preview table shows you every row before you download. Check that your handles, prices, and SKUs look correct, then click the download button to save the CSV file. You can import it directly through Shopify Admin under Products, then Import.

Step-by-Step Guide to Creating Your Product CSV

1. Plan your product structure first. Before filling in the form, decide on your option names (e.g., Size, Color) and list all values (e.g., S/M/L/XL, Black/White/Blue). Also prepare your SKU naming convention, prices for each variant, and initial inventory quantities.
2. Enter the product handle. The handle becomes the URL slug for your product page. Use lowercase letters, numbers, and hyphens only. For example, “Classic Cotton T-Shirt” should have the handle “classic-cotton-tshirt”. Keep it short and descriptive.
3. Fill in product details. Enter the title exactly as you want it displayed on your store. Write an HTML description with paragraph tags, bullet lists, and formatting. Set the vendor (your brand name), product type (for filtering), and tags (for collections and search).
4. Add your first variant. Set Option1 Name (e.g., “Size”) and Option1 Value (e.g., “Small”). If your product has a second option like color, fill in Option2 Name and Value as well. Enter the price, compare-at price (for sale items), SKU, and inventory quantity.
5. Add remaining variants. Click “+ Add Variant” for each additional size/color combination. Keep option names consistent across all variants. Each variant needs its own unique SKU and can have a different price and inventory quantity.
6. Generate and review. Click “Generate CSV” to see a preview table of all rows. Verify that option values, prices, and SKUs are correct. Check that the first row has all product data and subsequent rows have only variant data.
7. Download and import. Click “Download CSV” to save the file. Go to your Shopify Admin, navigate to Products > Import, upload the file, and review the import preview before confirming.

Why This Matters for Your Shopify Store

Manually editing CSV files in Excel or Google Sheets is the most common source of import errors on Shopify. Missing quote marks around HTML descriptions, incorrect column ordering, or extra whitespace in handles can cause entire imports to fail or create broken product listings. This tool eliminates those formatting issues by generating the CSV programmatically.

Speed matters when you are building or expanding your catalog. Instead of referencing Shopify’s CSV documentation and carefully positioning data in the right columns, you fill in a simple form and get a perfectly formatted file in seconds. For stores with dozens of products and hundreds of variants, this can save hours of tedious spreadsheet work.

Accuracy matters even more. A single misplaced comma in a CSV can corrupt an entire row. A missing quote around an HTML description that contains commas splits the description across multiple columns, creating gibberish in your product data. These errors are difficult to diagnose because the CSV looks fine in a spreadsheet but fails on import. This generator produces syntactically perfect CSV output every time.

Real-World Examples

Example 1: T-Shirt with Size and Color Variants (12 variants)

A clothing brand launching a new t-shirt in 3 colors (Black, White, Navy) and 4 sizes (S, M, L, XL) needs 12 variant rows in their CSV:

Only row 1 contains the Title, Body, Vendor, Tags, and Image. Rows 2-12 share the handle but leave product-level fields empty. This is exactly what this generator produces.

Example 2: Simple Product with No Variants (1 row)

A single-option product like a branded mug needs just one row with the default variant convention:

When generating a simple product, set Option1 Name to “Title” and Option1 Value to “Default Title” to follow Shopify’s convention.

Example 3: Product with Three Options (24 variants)

A shoe store needs products with Size, Color, and Width options. This creates larger variant matrices:

Remember that Shopify limits products to 3 options and 100 variants. Plan your option structure to stay within these limits. For products that need more combinations, consider splitting into separate product listings.

Product CSV Generator vs. Other Methods

Common Mistakes to Avoid

1. Using spaces or uppercase in handles. Handles must be lowercase with hyphens. “My Product” should be “my-product”. Spaces, underscores, and special characters will cause import issues or result in ugly URLs on your store.
2. Inconsistent option names across variants. If your first variant uses “Size” as Option1 Name, every variant must use exactly “Size” (not “Sizes”, “size”, or “SIZE”). Inconsistent names cause Shopify to create separate option groups, breaking your variant selector.
3. Forgetting to set Published status. If you want products visible on your store immediately, set Published to “true”. Products imported as “false” appear as drafts and are invisible to customers until you manually publish them.
4. Including currency symbols in prices. Enter prices as plain numbers (29.99), not formatted values ($29.99). Shopify uses your store’s currency setting automatically. Including symbols causes the price field to be interpreted as text, resulting in import errors.
5. Leaving image URLs empty for variant rows. Only the first row needs the main product image. However, if you want variant-specific images (e.g., showing each color), add the Image Src on the corresponding variant row. Use our Variant Image Checker to verify image assignments after import.
6. Exceeding the 100-variant limit. Shopify allows a maximum of 100 variants per product. A product with 4 sizes, 5 colors, and 6 materials would need 120 variants, which exceeds the limit. Restructure by splitting into separate products or reducing option values.

When to Use This Tool

Tips and Best Practices

• Use lowercase, hyphenated handles. Shopify generates handles from titles automatically, but setting them yourself gives you control over your URLs. Keep them short, descriptive, and lowercase with hyphens (e.g., classic-cotton-tshirt, not Classic_Cotton_T-Shirt).
• Include HTML in your body field. Shopify accepts HTML in the Body (HTML) column. Use paragraph tags, bullet lists, and bold text to create well-formatted product descriptions that render correctly on your store.
• Keep Option Names consistent. If you use “Size” for one product, use “Size” for all products (not “Sizes” or “size”). Consistent option names enable Shopify’s filtering and variant selectors to work properly across your catalog.
• Set Compare at Price for sale items. The Compare at Price creates the strikethrough “was” price on your product page. Only fill this in if the product is currently on sale; leave it blank otherwise.
• Use unique SKUs for every variant. Each variant should have a distinct SKU that includes identifiers for the product, color, and size. This makes inventory tracking, order fulfillment, and returns processing much easier. Use our SKU Generator to create a consistent naming system.
• Validate before importing. After generating your CSV, run it through our CSV Validator to catch any remaining issues. This two-step process, generate then validate, virtually eliminates import failures.
• Use tags strategically for collections. Tags in your CSV drive automated collections in Shopify. Plan your tagging strategy before importing. Use tags like “summer-2025”, “cotton”, “mens” to enable smart collections that automatically include matching products.

Related Tools

• CSV Validator – Validate your generated CSV before importing to catch any remaining issues.
• SKU Generator – Create structured, consistent SKU codes for all your product variants.
• Bulk Price Editor – Apply percentage or fixed-amount price changes across your product catalog.