FormattingError Code Solution
How to Fix Shopify CSV Error: Invalid Boolean For Published Field
Shopify expects uppercase "TRUE" or "FALSE" strings for boolean fields.
Exact Shopify Importer Exception:
Validation failed: Published must be TRUE or FALSE
Root Cause Analysis
Values like "yes", "no", "1", "0", "true", "false", or "published" fail validation.
Manual Resolution Steps
- 1Convert all boolean values in Published, Variant Requires Shipping, Variant Taxable to "TRUE" or "FALSE".
Example Broken Payload Triggering This Error:
{
"Handle": "beanie-hat",
"Published": "yes",
"Variant Taxable": "1"
}Automate This Fix in Your Browser
Shopify CSV Doctor automatically detects and repairs Invalid Boolean For Published Field line items client-side without manual spreadsheet editing.