TRUE/FALSE columns in a Shopify product CSV

A handful of Shopify product columns are boolean. They represent true or false. Shopify’s current reference uses lowercase true/false examples; CSV Spruce standardises supported spellings to TRUE/FALSE. A case-only change does not prove an original value was invalid. Product Status is separate from online-store publication.

The boolean columns

Published — whether the product is published to your online store.
Gift Card — whether the product is a gift card.
Variant Requires Shipping — physical vs digital variants.
Variant Taxable — whether tax is charged.
Included / <market> — market availability columns.

Where the values come from

Spreadsheets are helpful in unhelpful ways. Excel and Google Sheets happily store yes, Y, 1, WAAR (a localised TRUE), or a checkbox that exports as TRUE(). Migration tools from other platforms write their own conventions.

What is safe to convert automatically

Only spellings with exactly one meaning: true, yes, 1 and false, no, 0, in any letter case. CSV Spruce rewrites these to TRUE and FALSE and shows you real examples from your own file.

What is not safe

draft, -, n/a, 2 and localised words are ambiguous. Guessing here can publish products you meant to keep hidden. We flag them and change nothing.

Blank cells

A blank boolean cell is left blank. On variant continuation rows a blank is normal and expected; on the first row of a product it means Shopify applies its own default. We do not fill it in for you.

Check the field before changing the value

Input	Result in a supported boolean column
yes / 1	TRUE
no / 0	FALSE
maybe	Blocked: you decide
Blank	Preserved

Avoid global find-and-replace: descriptions, SKUs and option values can contain the same words. Arbitrary boolean metafields are outside this tool’s repair scope.

Header troubleshooting · Variant rows

Official documentation

Shopify Help Center: product CSV column reference

Upload a file to see exactly which boolean values we would convert.