Synthetic demo. Both reports below are generated by the real engine from two small made-up files. No customer data appears here.

Example reports

The first file can be corrected, so it would offer a $3.99 download. The second cannot, so it would show no pay button at all.

1. A file we can correct

What we found — demo-products.csv

We can safely apply 10 fixes to this file. The corrected file was re-parsed and re-checked before we offered it.

Rows checked

Safe fixes

Warnings

Blockers

12 columns detected · 11 recognised · 1 kept as-is(technical detail)

Columns detected: 12
Recognised Shopify columns: 11
Unknown columns kept as-is: 1
Rule version: spruce-rules-1.1.0

We checked our own work

The corrected file was written, read back in full, and re-checked against every rule your original passed.

Verification detail

Output re-parsed after writing: yes
Row and cell structure matches the original: yes (6 rows)
No value changed except the fixes listed above: yes
All checks re-run on the output: yes
SHA-256 6d92c4a6444559d61908bfd1ac6e875003133adbd8340b71f6452bcce59d3284

Safe fixHeaders2 occurrences

Stray whitespace or byte-order marks in header names

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: Stray whitespace or byte-order marks in header names
Row	Column	Before	After
1	Title	Title	Title
1	Published	Published	Published

Showing up to 3 real examples from your file for this category (12 across the whole report).

WarningHeaders1 occurrence

1 column we do not recognise

We keep unknown columns exactly as they are: "Internal Notes". Shopify may ignore or reject them — we cannot verify that for you.

Safe fixTrue / false values8 occurrences

Yes/no style values rewritten to TRUE / FALSE

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 style values rewritten to TRUE / FALSE
Row	Column	Before	After
2	Published	yes	TRUE
5	Published	no	FALSE
2	Variant Requires Shipping	YES	TRUE

Showing up to 3 real examples from your file for this category (12 across the whole report).

2. A file we refuse to sell

What we found — demo-blocked.csv

We found problems we will not repair automatically, so there is nothing to buy. The details below show exactly what to fix.

Rows checked

Safe fixes

Warnings

Blockers

5 columns detected · 5 recognised · 0 kept as-is(technical detail)

Columns detected: 5
Recognised Shopify columns: 5
Unknown columns kept as-is: 0
Rule version: spruce-rules-1.1.0

BlockerRequired data1 occurrence

First row of a product has no Title

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: First row of a product has no Title
Row	Column	Before	After
2	Title	(empty) — handle "linen-apron"	unchanged

Showing up to 3 real examples from your file for this category (12 across the whole report).

BlockerTrue / false values1 occurrence

Values in a true/false column we will not guess at

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: Values in a true/false column we will not guess at
Row	Column	Before	After
4	Published	maybe	unchanged

Showing up to 3 real examples from your file for this category (12 across the whole report).

Safe fixTrue / false values2 occurrences

Yes/no style values rewritten to TRUE / FALSE

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 style values rewritten to TRUE / FALSE
Row	Column	Before	After
2	Published	yes	TRUE
3	Published	yes	TRUE

Showing up to 3 real examples from your file for this category (12 across the whole report).

Check my own CSV