Fixture
name,price,sku
"Blue Shirt,19.99,SKU-001
Red Shirt,24.50,SKU-002What the parser sees
The first data row begins a quoted field at "Blue Shirt but never closes it. Once a quoted field is open, a comma or newline can legally be part of that field. The parser therefore cannot safely assume that the next physical line starts a new record.
Why a column error may appear too
Because the quote changes record boundaries, the parsed row can also have fewer fields than the three-column header. That width mismatch is useful evidence, but adding a missing comma would treat the symptom rather than the cause.
The report should include a quote parser error and structural side effects.
Determine whether the quote was accidental or whether the field was supposed to contain punctuation or a line break.
Balance or escape the quotation mark using the original data as the reference.
Confirm the quote error and any row-width error disappear together.
Measured worker results
Executed 2026-10-11 using the CSVFixLab worker handler and the downloadable fixture bytes. These are controlled synthetic tests. No customer file or live Shopify import was used.
Manual structural example: close the quote after Blue Shirt. These are synthetic fixture values, not recovered customer data.
Worker mode: repair. The table records the worker's serialization decision. Diagnosis-only tool pages do not offer a repair download button.
On a small screen, scroll the table horizontally to read every column.
| Run | Data records | Columns | Worker permits serialization | Reported issues |
|---|---|---|---|---|
| Original fixture · utf-8 | 1 | 3 | No | column-count (record 2): Expected 3 columns but found 1. / MissingQuotes (record 2): Quoted field unterminated |
| Corrected example · rechecked with Auto | 2 | 3 | Yes | No issues detected by these checks |
Corrected fixture
name,price,sku
"Blue Shirt",19.99,SKU-001
Red Shirt,24.50,SKU-002Download corrected example · Download complete measured reports
Fixture identity and test scope
Original SHA-256: e32eaebd557ed2d961fdf6b4f3c3c2b0484430037041a16b68af87c7f355f203
Corrected SHA-256: d4fa729fb5de9a7f28ec46addf4c876c0b8e145de7abe871f738c1091d5cd199
Node v24.19.0; actual worker handler with File-compatible byte input; no Shopify live import. Record numbers refer to parsed CSV records, including the header, rather than physical lines. The test checks reported errors and, for automatic conversions, equality of the parsed field values. It does not establish compatibility with every importer.