Some names in the top row have extra spaces or a hidden mark. We can clean them up without changing your product details.
More details
Shopify matches header names exactly. Leading or trailing spaces and a hidden byte-order mark make it treat the column as unknown. We removed only that whitespace and kept your spelling — current or legacy — exactly as written.
Examples from your file for: Extra spaces in column names
Row
Column
In your file
Suggested change
1
Title
Title
Title
1
Published
Published
Published
These are a few examples. The totals include all the problems we found.
Please reviewColumn names1 found
1 column to check
We left these columns unchanged. Shopify may not use them. Compare their names with Shopify's product template.
More details
We keep unknown columns exactly as they are: "Internal Notes". Shopify may ignore or reject them — we cannot verify that for you.
Formatting fixTrue / false values8 found
Yes/no answers can be formatted for Shopify
In Shopify's yes/no columns, we change yes or 1 to TRUE, and no or 0 to FALSE. Changing lowercase true to uppercase TRUE is only a formatting change; it doesn't mean the original was wrong.
More details
Shopify expects TRUE or FALSE in these columns. We only rewrite spellings with exactly one meaning: true/yes/1 and false/no/0, in any letter case.
Examples from your file for: Yes/no answers can be formatted for Shopify
Row
Column
In your file
Suggested change
2
Published
yes
TRUE
5
Published
no
FALSE
2
Variant Requires Shipping
YES
TRUE
These are a few examples. The totals include all the problems we found.
2. Changes you need to make
What we found — demo-blocked.csv
This file needs changes we can't make for you. Read the details below, then check it again for free.
3
Rows checked
2
Formatting fixes
0
Things to review
2
Needs your attention
About your file(more details)
Columns found
5
Shopify columns we know
5
Other columns left unchanged
0
Rule version
spruce-rules-1.1.0
Needs your attentionMissing information1 found
A product is missing its name
Add a name in the Title column on the product's first row. Later rows for its other sizes, colors, or images can have blank titles.
More details
Shopify takes the product title from the first row of each handle. Blank titles on later variant or image rows are correct and expected — these are first rows.
Examples from your file for: A product is missing its name
Row
Column
In your file
Suggested change
2
Title
(empty) — handle "linen-apron"
You need to change this
These are a few examples. The totals include all the problems we found.
Needs your attentionTrue / false values1 found
Choose yes or no for these cells
We can't tell which answer you mean. Enter TRUE for yes or FALSE for no in the cells shown, then check your file again.
More details
These are not an unambiguous yes or no, so we will not rewrite them — and we will not sell you a file that still contains them. Set them to TRUE or FALSE and upload again.
Examples from your file for: Choose yes or no for these cells
Row
Column
In your file
Suggested change
4
Published
maybe
You need to change this
These are a few examples. The totals include all the problems we found.
Formatting fixTrue / false values2 found
Yes/no answers can be formatted for Shopify
In Shopify's yes/no columns, we change yes or 1 to TRUE, and no or 0 to FALSE. Changing lowercase true to uppercase TRUE is only a formatting change; it doesn't mean the original was wrong.
More details
Shopify expects TRUE or FALSE in these columns. We only rewrite spellings with exactly one meaning: true/yes/1 and false/no/0, in any letter case.
Examples from your file for: Yes/no answers can be formatted for Shopify
Row
Column
In your file
Suggested change
2
Published
yes
TRUE
3
Published
yes
TRUE
These are a few examples. The totals include all the problems we found.