StriveFormats
ShopifycomplianceImport blockerAuto-fixable

Invalid Published value

Published on online store has a non-boolean value.

What is this issue?

Published on online store has a non-boolean value.

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

Why Shopify rejects this

Shopify expects TRUE/FALSE (or blank). Invalid values can block import.

Shopify-specific note

Shopify requires TRUE or FALSE in all caps. A blank cell is treated as FALSE for most boolean fields. Do not use Yes, No, 1, or 0 -- Shopify's importer will reject them.

Valid values / expected format

  • ✓TRUE
  • ✓FALSE
  • ✓(blank -- treated as FALSE for most boolean fields)

Examples

Bad valueGood valueNote
yesTRUEMust be uppercase
1TRUE
NoFALSE
0FALSE
TrueTRUEMixed 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.

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

Fix in Excel

  1. 1In Excel, click the column letter for the Published column to select the entire column.
  2. 2Press Ctrl+H to open Find & Replace.
  3. 3In 'Find what', type: yes -- in 'Replace with', type: TRUE -- check 'Match entire cell contents' -- click Replace All.
  4. 4Repeat: no -> FALSE, 1 -> TRUE, 0 -> FALSE.
  5. 5Also replace: True -> TRUE, False -> FALSE.
  6. 6Scan the column to confirm only TRUE and FALSE remain (and blanks if allowed).
  7. 7Save as CSV (Comma delimited).

Fix in Google Sheets

  1. 1In Google Sheets, click the column letter for the Published column to select the whole column.
  2. 2Press Ctrl+H to open Find & Replace.
  3. 3Set Find: yes -- Replace with: TRUE -- check 'Match entire cell contents' -- Replace All.
  4. 4Repeat: no -> FALSE, 1 -> TRUE, 0 -> FALSE, True -> TRUE, False -> FALSE.
  5. 5Verify only TRUE and FALSE remain in the column.
  6. 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 Published column and checks it against Shopify's accepted boolean values. Any value that does not match exactly -- including mixed-case variants like "True" or "Yes" -- is flagged as an error.

►Technical detail
Shopify's importer performs an exact, case-sensitive match on boolean fields. Only the uppercase strings TRUE and FALSE are accepted. Spreadsheet applications commonly produce alternative representations: Excel exports checkbox cells as TRUE/FALSE (which works), but "true" (lowercase), "Yes", "1", or "checked" will all fail. The blank value is treated as FALSE for most boolean fields, so leaving optional boolean fields empty is safe.