Product CSV Validator

How This Tool Works

The validator reads your CSV file using the browser’s FileReader API and parses it into rows and columns. It first checks the header row for Shopify’s expected column names, reporting any missing required columns. Then it processes each data row, checking for empty required fields, proper price formatting, valid URL patterns for images, and handle uniqueness.

For variant products, the validator checks that all rows sharing the same handle have consistent option names and that each variant has a price and SKU. It also identifies orphan variant rows (rows with option values but no parent product row) and duplicate variant combinations. The results are presented as a summary with totals plus a detailed issue list showing exactly which rows need attention.

The parser handles edge cases that trip up simpler CSV readers, including quoted fields containing commas, escaped quotation marks, multi-line descriptions within quoted cells, and mixed line endings (Windows CRLF vs Unix LF). This means it processes real-world Shopify CSVs accurately, even those exported from Excel or Google Sheets with complex formatting.

Step-by-Step Guide to Validating Your CSV

1. Export or prepare your CSV file. If you are updating existing products, start by exporting your current catalog from Shopify Admin (Products > Export). If building a new catalog, use Shopify’s CSV template or generate one with our Product CSV Generator.
2. Upload the file to this validator. Click the file upload button and select your CSV. The file is processed entirely in your browser, so even files with sensitive product data or unreleased pricing remain private.
3. Review the summary statistics. The validator reports total rows, unique products (handles), total variant rows, detected columns, and missing expected columns. This gives you an immediate sense of the file’s scope and structure.
4. Address errors first, then warnings. Errors (red) indicate issues that will cause import failures, such as missing prices, empty handles, or invalid URLs. Warnings (orange) flag potential problems like missing SKUs or zero-dollar prices that may be intentional but should be verified.
5. Fix issues in your spreadsheet. Use the row numbers from the issue report to locate and fix problems in your CSV editor. Each issue includes the specific field and a description of what is wrong and how to fix it.
6. Re-validate after fixing. Upload the corrected file and run validation again. Repeat until you see zero errors. A clean validation result gives you confidence the import will succeed on the first attempt.
7. Import into Shopify. Go to Shopify Admin > Products > Import, upload the validated CSV, and preview the import. Shopify will show a summary of products to be created or updated before committing the changes.

Why This Matters for Your Shopify Store

A failed CSV import wastes time and can leave your store in a messy state. Partial imports are particularly problematic because some products get created while others fail, making it difficult to know what succeeded and what needs to be re-imported. Duplicate handles can overwrite existing products, incorrect prices can cause undercharging or overcharging, and missing images leave products looking unprofessional.

For stores migrating from another platform or managing large catalogs through CSV files, validation is an essential step in the workflow. Catching errors before import is dramatically faster than finding and fixing them after products are already in your Shopify admin. This tool gives you confidence that your CSV will import cleanly on the first attempt.

The financial impact of CSV errors extends beyond wasted time. A pricing error that goes live can result in orders at incorrect prices that you are legally required to honor in many jurisdictions. A duplicate handle that overwrites a best-selling product can take down a page that generates hundreds of dollars per day. Validation is cheap insurance against these costly mistakes.

Real-World Examples

Example 1: Fashion Store Migration (2,400 products)

A fashion retailer migrating from WooCommerce exported their catalog and converted it to Shopify format. The initial validation revealed critical issues:

After fixing these issues and re-validating with zero errors, the import completed successfully with all 2,400 products correctly structured.

Example 2: Supplement Store Bulk Update (800 products)

A supplement store needed to update prices across their entire catalog for a new pricing tier. Their CSV update revealed issues that would have caused customer-facing problems:

Example 3: Handmade Jewelry Store (150 products, 600 variants)

A jewelry maker with multi-variant products (size and material options) had variant structuring issues:

CSV Validator vs. Other Validation Methods

This tool provides the fastest, most private way to validate a Shopify CSV before import. Unlike Shopify’s own import preview, which only shows a summary and catches structural issues, this validator checks every row for data quality issues like invalid prices, inconsistent option names, and Compare At Price logic errors.

Common Mistakes to Avoid

1. Setting Title on every variant row. Only the first row for each handle should have the Title, Body, Vendor, and other product-level fields filled in. If you set Title on subsequent variant rows, Shopify may interpret them as separate products or overwrite data unpredictably.
2. Using inconsistent handle formatting. Handles must be lowercase with hyphens. Spaces, uppercase letters, and special characters cause import issues. “Men’s Blue T-Shirt” should become “mens-blue-t-shirt” in the Handle column.
3. Including currency symbols in price fields. Variant Price and Compare At Price columns must contain plain numbers (e.g., 29.99), not formatted currency (e.g., $29.99 or 29,99 EUR). Shopify uses your store’s currency setting automatically.
4. Forgetting the default variant for simple products. Products without variants still need Option1 Name set to “Title” and Option1 Value set to “Default Title”. Omitting these fields can cause import errors or create products without purchasable variants.
5. Saving CSV with wrong encoding. Excel’s default “CSV (Comma delimited)” format uses ANSI encoding, which corrupts special characters. Always choose “CSV UTF-8 (Comma delimited)” when saving from Excel. Google Sheets exports as UTF-8 by default.
6. Leaving Compare At Price lower than Variant Price. When Compare At Price is set, it must be higher than Variant Price. Otherwise, no strikethrough “was” price appears, and the sale formatting breaks. This tool flags these inverted price pairs.
7. Using the same handle for different products. If two genuinely different products share a handle, the import treats them as variants of the same product. This merges unrelated products into a single listing. Always use unique handles for distinct products.

When to Use This Tool

Tips and Best Practices

• Start with Shopify’s CSV template. Export a sample product from your Shopify admin as a CSV to get the correct column format. Use this as your template when building import files.
• Use consistent handle formatting. Handles should be lowercase, use hyphens instead of spaces, and contain only alphanumeric characters. Example: “mens-blue-cotton-tshirt” instead of “Men’s Blue Cotton T-Shirt”.
• Leave variant rows partially empty. For multi-variant products, only the first row needs the full product details (Title, Body, Vendor, etc.). Subsequent variant rows only need the Handle, Option values, Variant Price, Variant SKU, and Image Src.
• Check your image URLs are accessible. Shopify will attempt to download images from the URLs in your CSV during import. Make sure the URLs are publicly accessible and point to actual image files. Broken URLs result in products without images.
• Save as UTF-8 CSV. If your product data contains special characters, accents, or non-Latin scripts, ensure your CSV is saved with UTF-8 encoding. Incorrect encoding causes garbled text in product titles and descriptions.
• Always backup before bulk updates. Before importing a CSV that updates existing products, export your current catalog as a backup. If something goes wrong, you can re-import the backup to restore your products to their previous state.
• Validate incrementally for large catalogs. For files with 5,000+ products, consider splitting into smaller batches and validating each one. This makes it easier to track down and fix issues without being overwhelmed by a massive error list.

Related Tools

• Product CSV Generator – Build a perfectly formatted Shopify product CSV from scratch without touching a spreadsheet.
• WooCommerce to Shopify Converter – Convert WooCommerce product exports into Shopify-compatible CSV format automatically.
• Bulk Price Editor – Apply percentage or fixed-amount price changes across your entire product catalog.