Illustrative deliverable / fictional data
Supplier catalog comparison
August → September · Demo stationery supplier
Prepared 6 September 2026. All products, prices and source files in this example are fictional. This is a worked example, not client work.
01 / Full comparison
Every SKU accounted for.
The two inputs contain 10 and 12 rows. The comparison contains 4 changed, 1 new, 1 missing, 4 held and 1 unchanged SKU. Duplicate input rows remain visible in the source files; the blank identifier is reported separately.
| SKU | Product & finding | Status | Unit cost | Source rows |
|---|---|---|---|---|
| 001001 | Desk Tray unit_cost; supplier_stock_qty | Changed | 12.50 → 13.25 USD · 6.00% | previous.csv:2 / current.csv:2 |
| 001002 | Cable Organizer unit_cost; supplier_stock_qty | Changed | 8.00 → 7.20 USD · -10.00% | previous.csv:3 / current.csv:3 |
| 001003 | Cotton Tote missing from current input | Missing from file | 4.25 → — USD · Not compared | previous.csv:4 |
| 001004 | Linen Notebook supplier_stock_qty | Changed | 9.50 → 9.50 USD · 0.00% | previous.csv:5 / current.csv:4 |
| 001005 | Steel Bottle currency differs | Held for review | 18.00 → 18.00 USD -> EUR · Not compared | previous.csv:6 / current.csv:5 |
| 001006 | Refill Pack pack_qty differs | Held for review | 12.00 → 12.00 USD · Not compared | previous.csv:7 / current.csv:6 |
| 001007 | Pen Set duplicate current SKU with conflicting unit_cost; supplier_stock_qty: 75 -> 70 in both current rows; confirm source | Held for review | 6.00 → 6.25 | 6.75 USD · Not compared | previous.csv:8 / current.csv:7; current.csv:8 |
| 001008 | Desk Mat none | Unchanged | 22.00 → 22.00 USD · 0.00% | previous.csv:9 / current.csv:9 |
| 001009 | Gift Box missing current unit_cost; supplier_stock_qty: 200 -> 180 | Held for review | 3.00 → — USD · Not compared | previous.csv:10 / current.csv:10 |
| 001010 | Weekly Planner A5 product_name: Weekly Planner -> Weekly Planner A5 | Changed | 11.00 → 11.00 USD · 0.00% | previous.csv:11 / current.csv:11 |
| 001011 | Cork Coaster new SKU in current input | New in file | — → 5.50 USD · Not compared | current.csv:12 |
Unit costs are supplier costs, not retail selling prices. Price comparisons require the same currency and pack quantity. Percent changes use the previous unit cost as the denominator. The CSV contains the full stock and pack fields.
02 / Review queue
Keep uncertainty visible.
| Item | SKU | Finding | Decision needed |
|---|---|---|---|
| R01 | 001003 | missing from file | Confirm current file completeness and supplier status; missing does not mean discontinued previous.csv:4 |
| R02 | 001005 | currency conflict | Confirm USD versus EUR before any monetary comparison previous.csv:6; current.csv:5 |
| R03 | 001006 | pack size conflict | Confirm whether cost is per pack or per item before comparison previous.csv:7; current.csv:6 |
| R04 | 001007 | duplicate sku | Select the authoritative row with the supplier; both conflicting rows retained current.csv:7; current.csv:8 |
| R05 | 001009 | missing cost | Obtain current unit cost; blank is not zero current.csv:10 |
| R06 | (blank) | missing sku | Obtain a stable supplier SKU; row excluded from the SKU comparison current.csv:13 |
03 / Traceability
Check the original rows.
A reference such as current.csv:7 points to physical line 7 in the supplied CSV. The header is line 1. Leading zeros in SKUs are preserved in the Excel workbook.
When opening CSVs in a spreadsheet application, import the SKU column as Text. The workbook already stores it as text.
04 / What this establishes
A clear review handoff.
The sample demonstrates the proposed output and its handling of ambiguity. It does not measure performance on a real supplier feed, establish purchasing demand or certify a store import.