StriveFormats
CSV Fixer
WooCommerceStructureImport blockerAuto-fixable

Unrecognised value

A status-type column has a value WooCommerce does not recognise.

What is this issue?

A status-type column has a value WooCommerce does not recognise.

Affected field:Unrecognised value
Import blocker: your file will fail to import until this is resolved.

This issue is fixed automatically — upload your CSV to fix it now.

Fix now

Why WooCommerce rejects this

WooCommerce only accepts specific values for Published, In stock?, Backorders allowed?, and Tax status; others are ignored or rejected.

Fix in StriveFormats

This issue is auto-fixable. Upload your CSV and click Fix Issues to apply all safe corrections at once.

Auto-fixable: this issue is corrected automatically when you click Fix Issues.
Open CSV FixerView templateWooCommerce Fixer guide

Fix in Excel

  1. 1Review the Unrecognised value column for incorrect values.
  2. 2Fix any cells that do not match the expected format.
  3. 3Save as CSV (Comma delimited).

Fix in Google Sheets

  1. 1Review the Unrecognised value column for incorrect values.
  2. 2Correct any cells that do not match the expected format.
  3. 3Go to File > Download > Comma Separated Values (.csv).

Prevent it next time

  1. ✓Start from the official platform template to avoid structural issues.
  2. ✓Run your file through StriveFormats before every import.
  3. ✓Test with a small sample file first to catch errors before they affect your full catalog.

How StriveFormats detects this

StriveFormats parses every row of your CSV and applies WooCommerce-specific validation rules to the Unrecognised value field. Any row that violates the rule is flagged with the row number and the specific value that caused the issue.

►Technical detail
WooCommerce's importer validates the Unrecognised value field against its official import specification. Values that do not meet the expected format are flagged to prevent silent data corruption -- an invalid value that slips through import might appear as a blank field, a zero, or incorrect text in your storefront without any error message after the fact.