Invalid boolean value
Boolean fields like Published, In stock?, and Is featured? expect 1/0 or true/false values.
What is this issue?
Boolean fields like Published, In stock?, and Is featured? expect 1/0 or true/false values.
Invalid boolean valueWhy WooCommerce rejects this
WooCommerce's importer may interpret unexpected values incorrectly, causing products to be hidden or misconfigured.
WooCommerce-specific note
WooCommerce Product CSV supports 1 and 0 as well as yes and no for boolean fields. The StriveFormats fixer normalizes these to the correct format automatically.
Valid values / expected format
- ✓1 (true)
- ✓0 (false)
- ✓(the fixer normalizes common variants like yes/no)
Examples
| Bad value | Good value | Note |
|---|---|---|
yes | TRUE | Must be uppercase |
1 | TRUE | |
No | FALSE | |
0 | FALSE | |
True | TRUE | Mixed case not accepted |
Fix in StriveFormats
Auto-fix normalizes common boolean variants (yes/no, 1/0, True/False) to the platform's exact required format. Upload your CSV and click Fix Issues.
Fix in Excel
- 1In Excel, click the column letter for the Invalid boolean value column to select the entire column.
- 2Press Ctrl+H to open Find & Replace.
- 3In 'Find what', type: yes -- in 'Replace with', type: TRUE -- check 'Match entire cell contents' -- click Replace All.
- 4Repeat: no -> FALSE, 1 -> TRUE, 0 -> FALSE.
- 5Also replace: True -> TRUE, False -> FALSE.
- 6Scan the column to confirm only TRUE and FALSE remain (and blanks if allowed).
- 7Save as CSV (Comma delimited).
Fix in Google Sheets
- 1In Google Sheets, click the column letter for the Invalid boolean value column to select the whole column.
- 2Press Ctrl+H to open Find & Replace.
- 3Set Find: yes -- Replace with: TRUE -- check 'Match entire cell contents' -- Replace All.
- 4Repeat: no -> FALSE, 1 -> TRUE, 0 -> FALSE, True -> TRUE, False -> FALSE.
- 5Verify only TRUE and FALSE remain in the column.
- 6Go to File > Download > Comma Separated Values (.csv).
Prevent it next time
- --Always type TRUE or FALSE (all caps) -- do not use spreadsheet checkboxes; export them as text instead.
- --If you export data from the platform's own admin panel, do not modify boolean columns in Excel -- autocorrect can silently change the values.
- --Set the cell format to Text in Excel before pasting boolean values to prevent automatic conversion.
- --Use StriveFormats auto-fix as a final pass before every import.
How StriveFormats detects this
StriveFormats reads every cell in the Invalid boolean value column and checks it against WooCommerce's accepted boolean values. Any value that does not match exactly -- including mixed-case variants like "True" or "Yes" -- is flagged as an error.