# The Catalog Rescue Demonstration — README

This folder contains the fictional demonstration referenced on the
**Process & Proof** page of the Catalog Rescue website. It exists so anyone
can inspect the repair process end to end: the file that went in, the file
that came out, and the report that explains every difference.

**All data is fictional.** The products, the supplier, the prices and the
image addresses were invented for this test. No real brand, business or
client data is used.

## Files

| File | What it is |
|---|---|
| `demo-before.csv` | The defective input: a supplier-style spreadsheet with the failure types that break real imports. |
| `demo-after.csv` | The repaired output: the same catalog as a Shopify-format CSV. |
| `demo-qc-report.md` | The QC report and change log for the repair, including the exceptions list. |

## How the test was counted

- The file contains **21 products**.
- The **88** figure is the total number of **SKU entries** across all
  variants of those 21 products — one entry per variant row.
- In the source, 87 of the 88 entries carry a SKU value and one is blank
  (a missing SKU, listed as an exception). The count of entries is
  88 in and 88 out.

## The definitions used in the result

- **Validation errors** — structural or technical defects in the file itself:
  wrong headers, broken encoding, malformed prices, variant rows detached
  from their products, unusable references. The demonstration's result is
  **zero unresolved validation errors**: none remain.
- **Exceptions** — missing or ambiguous source facts (a SKU the source never
  states, a price that cannot be read with confidence). Exceptions are
  documented for the catalog owner's decision and are never silently filled,
  so they are not counted as validation errors — the file is not defective;
  the fact is simply absent.
- **Approved unresolved items** — changes deliberately left undone because
  they wait for the owner's approval. In this test, the SKU that appears on
  two different products was flagged on both and changed on neither.

## The defects planted in the input

Supplier headers instead of Shopify headers · a duplicate SKU across two
different products · a missing SKU · a price written as words ("about
twenty") · a decimal-comma price · variant rows separated from their product
· a broken image URL scheme · an image reference pointing at a local file
path · double-encoded (mojibake) text.

How each one was handled — repaired, or flagged and left alone — is itemised
in `demo-qc-report.md`.