Shopify 'Field must be true or false' error
This means a cell needs a yes/no answer. In these Shopify columns, TRUE means yes and FALSE means no.
What to change
| Your answer | Use |
|---|---|
| yes or 1 | TRUE |
| no or 0 | FALSE |
| maybe or n/a | Choose the correct answer yourself |
| blank | Don't fill it in without checking what the column needs |
Lowercase true and false aren't necessarily wrong. Changing them to uppercase is a formatting change.
Find the right column first
These answers appear in columns such as:
Published— Is the product published in your online store?Gift Card— Is it a gift card?Variant Requires Shipping— Does this item need shipping?Variant Taxable— Should tax apply to this item?Included / [market name]— Is it included in that market?
Some Shopify templates use newer names for these columns. Compare yours with Shopify's column guide if you're unsure.
Fix it in your spreadsheet
- Save a backup.
- Find the column named in the error.
- Change the affected cells to TRUE or FALSE, based on what you want.
- Save as CSV and try again.
Don't replace every yes or no in the whole file. Those words could also be in product descriptions. Only edit the yes/no column you mean to change.
What CSV Spruce does
We can change true, yes, and 1 to TRUE, and false, no, and 0 to FALSE in the columns we support. Capital letters don't matter. Blank cells stay blank.
If the answer isn't clear, we ask you to check it. We don't change custom fields added by other apps.
Product Status is different: words such as draft belong in the Status column, not in a TRUE/FALSE column.
All import errors · Missing Title column · Quotation-mark errors · Sizes, colors, and product rows
More help from Shopify
Your report is free. Pay $3.99 only if you choose a corrected download.