CSV Sanity Check for WooCommerce

Description

CSV Sanity Check for WooCommerce checks a product CSV file for common mistakes before you run the WooCommerce product importer, so a broken batch stops at review instead of halfway through an import.

Everything runs locally in your browser: the file is never uploaded, stored or sent anywhere, and the plugin never writes to your store, never imports products and never changes any data.

What the free checker does

  • Parses your CSV in the browser (quoted fields, multiline values, escaped quotes, CRLF and BOM handled).
  • Flags duplicated header columns and files that cannot be parsed.
  • Checks a batch of new products for: missing Type/SKU/Name (strict policy), duplicate SKUs (including case-only collisions), non-decimal prices, invalid status or boolean values, unsupported product types, existing IDs (update imports are out of scope), attribute rows without values, variations without a parent in the same batch, duplicate variation attribute combinations and sale price above regular price (warning).
  • Shows a clear BLOCKED / CHECKS PASSED summary with a row-by-row issue table.
  • Explains its own scope and limitations on every run.

What it deliberately does not do

  • It does not import products and does not guarantee that WooCommerce will accept your file.
  • It does not check anything in your live store: existing SKUs, global attributes, IDs, plugins, server limits or permissions.
  • It does not fix or edit your data.
  • Update imports (rows with IDs), existing-store parent references and wildcard variations are outside its scope by design.

The strict requirements (explicit Type, SKU and Name; parents referenced by SKU inside the same batch; no wildcards) are this checker’s gate policies, not universal WooCommerce requirements.

Support

Support covers defects in the plugin itself (it fails to run, or reports something incorrectly). Help preparing or correcting your own CSV data is outside the support scope.

Installation

  1. Upload the plugin folder to /wp-content/plugins/ or install it from the WordPress plugin screen.
  2. Activate the plugin.
  3. Open WooCommerce > CSV Sanity Check (or Tools > CSV Sanity Check when WooCommerce is not active), choose your CSV and run the check before importing.

FAQ

Does the plugin send my catalog anywhere?

No. The CSV is read by your own browser with the FileReader API and never leaves your device. There are no external requests, no analytics and no tracking.

Does it modify or import products?

Never. It is read-only. It produces a report and nothing else.

A batch passed all checks. Will the import succeed?

Not guaranteed. This checker covers file-level and batch-internal issues only. Store-side conditions (existing SKUs, global attributes, server limits, permissions) are outside its scope. Always test imports on a staging copy with a backup first.

Which files does it support?

UTF-8 CSV with comma separators and a header row matching the WooCommerce product CSV column names, up to 5 MB and 5000 records.

Reviews

There are no reviews for this plugin.

Contributors & Developers

“CSV Sanity Check for WooCommerce” is open source software. The following people have contributed to this plugin.

Contributors

Changelog

0.1.0

  • First release: browser-local CSV parsing, strict new-product preflight checks, BLOCKED / CHECKS PASSED report.