Keep the purchasing history.
Own the record.
A searchable purchasing book built from a supplied CSV. Every accepted line points back to its source. Nothing is written to a store.
All purchases below are invented test data. This uses Toledo’s documented demonstration schema. Real Stocky export compatibility has not been tested. It does not recover absent data or restore historical purchase orders in Shopify.
Ordered line value
Sum of ordered quantity × unit cost for accepted lines, separately by currency. These are not actual spend, payments, received value, tax, freight or inventory valuation. Totals cover all accepted lines and do not change with search.
Find the original purchase
4 of 4 accepted lines shown.
| PO | Date | Supplier | SKU | Currency | Ordered | Received | Receipt state | Unit cost | Ordered value | Source record |
|---|---|---|---|---|---|---|---|---|---|---|
| PO-100 | 2026-08-15 | North Bolt | 00123 | USD | 10 | 6 | Partial | 2.50 | 25.00 | fixture.csv: record 1 (ends at line 2) |
| PO-100 | 2026-08-15 | North Bolt | 00124 | USD | 5 | Unknown | Unknown | 4.00 | 20.00 | fixture.csv: record 2 (ends at line 3) |
| PO-200 | 2026-08-19 | North Bolt | 00123 | EUR | 4 | 4 | Received | 3.00 | 12.00 | fixture.csv: record 3 (ends at line 4) |
| PO-300 | 2026-08-27 | Harbor Supply | 00999 | USD | 2 | 0 | Not received | 25.00 | 50.00 | fixture.csv: record 4 (ends at line 5) |
No accepted lines match. Clear the search or select another currency.
1 accepted line has no received quantity recorded. Unknown stays unknown; it is never converted to zero.
Supplier totals
Ordered line value, grouped by supplier and currency.
| Supplier | Currency | Ordered value |
|---|---|---|
| Harbor Supply | USD | 50.00 |
| North Bolt | EUR | 12.00 |
| North Bolt | USD | 45.00 |
Source and coverage
fixture.csv
SHA-256
ec5a9792d71912cb2c2ffa5726aaff4a515876bb6817673feb80a4530790c939
Accepted + rejected + duplicate records = 8 input records. This reconciles the supplied file only; it cannot establish whether it contains every historical purchase.
No live API, inferred missing fields, currency conversion or accounting claims. The accompanying report.json contains machine-readable records and rejection details.
Rejected and duplicate records
Excluded records remain accounted for. Exact duplicate exclusion is a proof policy; legitimate identical source lines require review against a real export’s identifiers.
| Source | Reason |
|---|---|
| fixture.csv: record 6 (ends at line 7) | ordered_quantity: expected a non-negative decimal, up to 6 decimal places |
| fixture.csv: record 7 (ends at line 8) | received_quantity: expected a non-negative decimal, up to 6 decimal places |
| fixture.csv: record 8 (ends at line 9) | unit_cost: expected a non-negative decimal, up to 6 decimal places |
| fixture.csv: record 5 (ends at line 6) | Exact duplicate row; excluded from totals |