Shopify Products CSV Validator

🥦

Validate Complete

Validation Report Format
valid rows

Check your Shopify products CSV export for missing columns and data format issues.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Download Clean Sample

Valid Shopify products export (no errors)

Clean Template

Download Error Sample

Sample with validation errors for testing

Error Example

Validation Questions Answered

Why does my file have multiple rows per product?

Shopify exports one row per variant. A t-shirt with 3 sizes will have 3 rows with the same Handle.

What columns are required?

Required columns are Handle, Title, Vendor, and Variant Price.

Is this tool free?

First transactions are free to preview. Full conversions use credits based on transaction count.

How Validation Works

1

Export from Shopify

Products → All Products → Export → Export CSV

2

Upload CSV

Upload your Products Export export file

3

Review Validation Results

Check your Shopify data for errors and warnings

Issues are flagged inline with clear fix suggestions — review and correct before you import.

Why Validate Product Data?

Product Import Errors

Shopify product imports fail when required columns are missing or variants are malformed. Handle, Title, and Vendor must be present and properly formatted.

What This Tool Checks

We validate your Shopify products export: - Required columns present (Handle, Title, Vendor, Variant Price) - Variant structure is consistent - Price formats are valid currency values

Your Data Stays Private During Validation

Every Row Checked

Each record is validated against format rules. Catch errors before they reach your platform.

Runs in Your Browser

Validation happens locally. Your data never leaves your browser.

GDPR Compliant

No files uploaded, no data retained. Full EU privacy compliance.

Why Validate Before Importing?

Column Validation

Checks for required columns: Handle, Title, Vendor, and Variant Price.

Variant Structure

Understands Shopify's one-row-per-variant export format.

Price Validation

Validates currency formats for Variant Price and Compare At Price.

Inventory Checking

Validates Variant Inventory Qty and inventory policy fields.

Browser-Based

Files processed locally. Your data never leaves your computer.

Instant Results

Get validation results in seconds, even for large files.

Common Target Import Errors

Issues you might encounter when importing Source data to Target - and how we solve them

Missing Product Handle

The 'Handle' column is required to identify products

(blank or missing Handle column)
blue-widget-large

Handle is Shopify's URL-safe product identifier

Re-export products ensuring Handle column is included

Missing Product Title

Product rows without a Title cannot be properly identified

(blank Title column)
Blue Widget - Large Size

Every product should have a human-readable title

Add titles to any products missing them in Shopify

Invalid Variant Price

Variant price contains non-numeric or negative values

TBD or -5.00
29.99

Prices must be positive numbers

Check for placeholder prices or data entry errors

Invalid Inventory Quantity

Inventory quantity is not a valid integer

many or 10.5
10

Inventory quantities must be whole numbers

Review inventory tracking settings in Shopify

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

// PRICING //

Choose the plan that fits your needs

5,381 reviews, Excellent
Pay as you go

Just start processing on any tool page

$1/credit

Tools processing starts from 5 credits. Then 1 credit = 1k rows. No sign-up needed.

OR

Credit Bundles

$ /Credit

One-time purchase

  • No monthly commitment
  • Credits valid for one year
  • Access to all tools
  • Full file downloads

Monthly Bundles Pro

$ /Credit

Best for professionals and content creators

Annual Discount
Per month, billed annually:
Save 20% more
  • Credits refresh monthly
  • Priority processing

Purchase Credits

  • Full CSV & Excel export
  • Google Sheets export
  • Instant browser download
for credits

Visa Mastercard PayPal Apple Pay Google Pay
256-bit SSL encryption
14-day money-back guarantee
PCI DSS compliant
Powered by Paddle

Do unused credits expire?

One-time credit bundles are valid for one year. Subscription credits refresh monthly. You can use credits across any tool, anytime.

Is my data secure?

Files process entirely in your browser. We're GDPR compliant with TLS encryption.

Can I get a refund?

Yes! Full refund within 14 days if no credits used. Partial refund for unused credits anytime. Contact sup@spreadsheetbroccoli.com.

Powered by Paddle

Terms of service applies. VAT included where applicable.

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
Shopify exports one row per variant. A t-shirt with 3 sizes will have 3 rows with the same Handle.
Required columns are Handle, Title, Vendor, and Variant Price.
First transactions are free to preview. Full conversions use credits based on transaction count.
Save your CSV file as UTF-8 encoding and replace curly quotes with straight quotes. Open the file in a text editor and search/replace smart quotes if created in Excel.
Image URLs must start with http:// or https:// and link directly to the image. Images must be 5000 x 5000 px or smaller. Check that the URL is publicly accessible.
Your CSV file cannot exceed 15 MB. If larger, split it into multiple files under 15 MB each and upload separately.
This error occurs when a product has two variants with identical option values. Each variant must have unique option combinations to import successfully.
Column header names are case-sensitive and must match Shopify's template exactly. Check that headers like 'Title', 'Handle', and 'Variant SKU' are spelled correctly.
If tracking inventory with the Variant Inventory Tracker, you must provide a quantity. Leave the tracker field blank to skip inventory tracking.
Create one product in Shopify manually, export it as CSV, then use it as a formatting template. This shows correct headers and required field structure.

After Validation: Convert Your Products Export

Once your Shopify export passes validation, convert it to your accounting format

Shopify Products Export Your validated export
Bigcommerce Product Import Products for BigCommerce import
TitleProduct Name Variant SKUProduct Code/SKU Body (HTML)Product Description
Product catalog import to BigCommerce
Shopify Products Export Your validated export
Magento Product Import Import products, configurable products, and attributes to Magento 2
Titlename Handleurl_key Variant SKUsku
Enterprise product catalog migration, bulk product updates
Shopify Products Export Your validated export
Opencart Products Import Product catalog import via extension
Handlemodel Titlename Body (HTML)description
Store migration, catalog import
Shopify Products Export Your validated export
Prestashop Products Import Product catalog import via native CSV import
HandleRewritten URL TitleName Body (HTML)Description
Store migration, catalog import
Shopify Products Export Your validated export
Quickbooks Online Products and Services Import Product and service items for invoicing and sales
TitleName Variant SKUSKU Variant PriceSales Price/Rate
Product catalog migration, inventory setup
Shopify Products Export Your validated export
Shift4Shop Products Import Product catalog import via native CSV import
Handleurl Variant SKUid Titlename
Store migration, catalog import
Shopify Products Export Your validated export
Squarespace Products Import Import products with variants and images
TitleProduct Name Variant SKUSKU Body (HTML)Product Description
Product catalog import to Squarespace
Shopify Products Export Your validated export
Wix Products Import Import products with multi-row structure (Product + Variant rows)
HandlehandleId Titlename Body (HTML)description
Product catalog import to Wix Stores
Shopify Products Export Your validated export
Woocommerce Product Import Import products, variations, and attributes to WooCommerce store
HandleSKU TitleName Body (HTML)Description
Product catalog migration, bulk product updates
Shopify Products Export Your validated export
Xero Inventory Item Products and services for inventory tracking
Variant SKU / HandleItemCode Title + Option ValuesItemName Body (HTML)Description
Product catalog sync, inventory management