← back to Ticket System
Prepare vendor cost evidence requests without treating joins as costs
1f313f391bca89af6513834f1abb3d8864131ba6 · 2026-09-16 15:18:42 -0700 · Steve Abrams
Files touched
A verification/yoloforever-yf2139.YF57g8/column-manifest/README.mdA verification/yoloforever-yf2139.YF57g8/column-manifest/generate.pyA verification/yoloforever-yf2139.YF57g8/column-manifest/input-snapshot.jsonA verification/yoloforever-yf2139.YF57g8/column-manifest/manifest.jsonA verification/yoloforever-yf2139.YF57g8/column-manifest/verification/e2e-proof.jsonA verification/yoloforever-yf2139.YF57g8/column-manifest/verify.pyA verification/yoloforever-yf2139.YF57g8/column-parent-proof.jsonA verification/yoloforever-yf2139.YF57g8/increment6-dtd.json
Diff
commit 1f313f391bca89af6513834f1abb3d8864131ba6
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Wed Sep 16 15:18:42 2026 -0700
Prepare vendor cost evidence requests without treating joins as costs
---
.../column-manifest/README.md | 54 +
.../column-manifest/generate.py | 98 +
.../column-manifest/input-snapshot.json | 2750 ++++++++++++++++++++
.../column-manifest/manifest.json | 1464 +++++++++++
.../column-manifest/verification/e2e-proof.json | 67 +
.../column-manifest/verify.py | 38 +
.../column-parent-proof.json | 30 +
.../yoloforever-yf2139.YF57g8/increment6-dtd.json | 19 +
8 files changed, 4520 insertions(+)
diff --git a/verification/yoloforever-yf2139.YF57g8/column-manifest/README.md b/verification/yoloforever-yf2139.YF57g8/column-manifest/README.md
new file mode 100644
index 00000000..6375c53e
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-manifest/README.md
@@ -0,0 +1,54 @@
+# TK-11860 evidence requests
+
+Offline preparation for the actual 26 STRONG_CANDIDATE rows. Historical totals: 12,852 active products and 10,704 product-SKU key matches. None establishes priced-row reachability or verified acquisition cost.
+
+Source timestamp: 2026-09-16T21:22:26.640Z
+SHA-256: `fe1406dd96ec286e291373d363b0929a65d54bd5c0ff9542017e31a7b997151a`
+
+| Vendor | Active | Key matches | Candidate tables | Explicit flags |
+|---|---:|---:|---|---|
+| Hollywood Wallcoverings | 3561 | 2039 | hollywood_catalog, hollywood_price_audit_log | All cost semantics UNPROVEN |
+| Jeffrey Stevens | 2654 | 2652 | jeffrey_stevens_catalog | All cost semantics UNPROVEN |
+| Mind the Gap | 1019 | 830 | mindthegap_catalog | All cost semantics UNPROVEN |
+| Anna French | 790 | 651 | anna_french_catalog | All cost semantics UNPROVEN |
+| Sandberg | 743 | 557 | sandberg_catalog, sandberg_catalog_prebackfill_bak_20260901172725 | All cost semantics UNPROVEN |
+| Knoll | 622 | 622 | knoll_catalog, knoll_price_backup_20260806 | All cost semantics UNPROVEN |
+| Tres Tintas | 601 | 601 | tres_tintas_catalog | All cost semantics UNPROVEN |
+| 1838 Wallcoverings | 456 | 451 | w1838_catalog | All cost semantics UNPROVEN |
+| Scalamandre | 418 | 418 | scalamandre_pillows, scalamandre_catalog, scalamandre_catalog_prebackfill_bak_20260901172726 | All cost semantics UNPROVEN |
+| Graham & Brown | 405 | 403 | graham_brown_catalog, graham_brown_murals | All cost semantics UNPROVEN |
+| Fabricut | 276 | 274 | fabricut_catalog | All cost semantics UNPROVEN |
+| Newwall | 251 | 251 | newwall_catalog | All cost semantics UNPROVEN |
+| Innovations USA | 202 | 160 | innovations_catalog | price_source: METADATA_SHAPED_NOT_COST_PROOF |
+| Stout Textiles | 180 | 180 | stout_catalog | All cost semantics UNPROVEN |
+| Brand McKenzie | 155 | 118 | brand_mckenzie_catalog, brand_mckenzie_products | All cost semantics UNPROVEN |
+| Donghia | 125 | 124 | donghia_catalog | All cost semantics UNPROVEN |
+| Newmor Wallcoverings | 116 | 116 | newmor_sku_reconcile | live_price: LIVE_PRICE_UNPROVEN_AS_ACQUISITION_COST |
+| Marburg | 112 | 96 | marburg_catalog | All cost semantics UNPROVEN |
+| Lincrusta | 47 | 45 | lincrusta_catalog | All cost semantics UNPROVEN |
+| Sancar | 42 | 42 | sancar_catalog | All cost semantics UNPROVEN |
+| Cloth and Paper | 41 | 40 | quadrille_house_catalog | All cost semantics UNPROVEN |
+| Franquemont London | 26 | 26 | franquemont_catalog | All cost semantics UNPROVEN |
+| Andrew Martin | 5 | 3 | andrew_martin_catalog | All cost semantics UNPROVEN |
+| Kravet Design | 2 | 2 | kravet_catalog, kravet_map_authoritative, kravet_dwkk_variant_map | price_effective_date: METADATA_SHAPED_NOT_COST_PROOF |
+| Kravet Couture | 2 | 2 | kravet_catalog, kravet_dwkk_variant_map, kravet_master_price | price_effective_date: METADATA_SHAPED_NOT_COST_PROOF |
+| Dedar | 1 | 1 | dedar_catalog | All cost semantics UNPROVEN |
+
+Every candidate table, join key, key-match count and populated-column count is retained separately in manifest.json under original_row. Every vendor has concrete evidence requirements for SKU identity, purchase units, currency, effective date, net/list basis, discount provenance, table identity and joined priced-row/cardinality proof. These are research requirements, not sent messages.
+
+- Key-match counts do not require a populated price on the joined row; column population counts are separate measures.
+- Candidate selection includes registry/name heuristics; table identity and cost meaning require evidence.
+- The source generator swallows query errors; this report does not prove query success or exhaustive identity resolution.
+- Metadata-shaped column names and existing discount stamps are not price/net-cost proof.
+- No external evidence was fetched or sent; no current costs, coverage lift or adoption are established.
+
+Obtain vendor-external cost evidence and identity/cardinality proof; any adoption into the cost map remains gated.
+
+Replay:
+
+```sh
+python3 generate.py input-snapshot.json --output replay.json
+python3 verify.py
+```
+
+The verifier checks the retained snapshot hash, compares all original candidate data, and retains fresh mktemp fixtures for malformed and summary-mismatch rejection. Source ticket remains unresolved.
diff --git a/verification/yoloforever-yf2139.YF57g8/column-manifest/generate.py b/verification/yoloforever-yf2139.YF57g8/column-manifest/generate.py
new file mode 100644
index 00000000..665e5ad0
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-manifest/generate.py
@@ -0,0 +1,98 @@
+#!/usr/bin/env python3
+"""Offline evidence requirements; no cost authority or live measurement."""
+import argparse
+import hashlib
+import json
+from datetime import datetime, timezone
+from pathlib import Path
+
+STATE = 'STRONG_CANDIDATE'
+EXPECTED = (26, 12852, 10704)
+
+def require(ok, reason):
+ if not ok:
+ raise ValueError(reason)
+
+def number(value):
+ require(type(value) is int and value >= 0, 'count must be a nonnegative integer')
+ return value
+
+def build(path):
+ raw = path.read_bytes()
+ source = json.loads(raw)
+ require(isinstance(source, dict), 'root must be an object')
+ report, summary = source.get('report'), source.get('summary')
+ require(isinstance(report, list) and isinstance(summary, dict), 'missing report/summary')
+ require(all(isinstance(r, dict) for r in report), 'invalid report row')
+ rows = [r for r in report if r.get('state') == STATE]
+ totals = (len(rows), sum(number(r.get('active')) for r in rows), sum(number(r.get('reachable')) for r in rows))
+ require(totals == EXPECTED, 'historical snapshot totals mismatch')
+ buckets = summary.get('buckets')
+ require(isinstance(buckets, list) and all(isinstance(b, dict) for b in buckets), 'invalid buckets')
+ declared = [b for b in buckets if b.get('state') == STATE]
+ require(len(declared) == 1, 'expected one strong-candidate summary bucket')
+ require(tuple(number(declared[0].get(k)) for k in ['vendors', 'active_products', 'reachable_products']) == totals, 'summary mismatch')
+ generated = summary.get('generated_at')
+ require(isinstance(generated, str) and datetime.fromisoformat(generated.replace('Z', '+00:00')).tzinfo is not None, 'invalid source timestamp')
+ names = [r.get('vendor') for r in rows]
+ require(all(isinstance(n, str) and n for n in names) and len(set(names)) == 26, 'missing/duplicate vendor')
+ entries = []
+ for row in rows:
+ candidates = row.get('candidates')
+ require(isinstance(candidates, list) and candidates, 'missing candidate tables')
+ flags = []
+ for candidate in candidates:
+ require(isinstance(candidate, dict) and isinstance(candidate.get('table'), str), 'invalid table')
+ join = candidate.get('best_join')
+ require(isinstance(join, dict) and (join.get('key') is None or isinstance(join.get('key'), str)), 'invalid join')
+ number(join.get('matched'))
+ cols = candidate.get('cost_columns')
+ require(isinstance(cols, list) and cols, 'missing columns')
+ for col in cols:
+ require(isinstance(col, dict) and isinstance(col.get('col'), str), 'invalid column')
+ number(col.get('populated'))
+ if col['col'] in ('price_source', 'price_effective_date'):
+ flags.append({'table': candidate['table'], 'column': col['col'], 'flag': 'METADATA_SHAPED_NOT_COST_PROOF'})
+ if row['vendor'] == 'Newmor Wallcoverings' and col['col'] == 'live_price':
+ flags.append({'table': candidate['table'], 'column': col['col'], 'flag': 'LIVE_PRICE_UNPROVEN_AS_ACQUISITION_COST'})
+ require(candidates[0]['best_join']['matched'] == row['reachable'], 'top join/reachable mismatch')
+ requirements = {
+ 'sku': 'Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.',
+ 'unit': 'Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.',
+ 'currency': 'Explicit acquisition-cost currency and documented conversion basis if needed.',
+ 'effective_date': 'Document date, price effective date and any expiry/supersession evidence.',
+ 'basis': 'Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.',
+ 'discount_proof': 'If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.',
+ 'table_identity': 'Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.',
+ 'population': 'For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors.',
+ }
+ entries.append({'vendor': row['vendor'], 'cost_semantics': 'UNPROVEN', 'external_evidence_status': 'NOT_VERIFIED_IN_THIS_PASS',
+ 'active_products_reported': row['active'], 'distinct_product_sku_key_matches_reported': row['reachable'],
+ 'column_population_is_separate_from_join_counts': True, 'flags': flags,
+ 'evidence_requirements': requirements, 'acquired_external_evidence': None, 'original_row': row})
+ return {'schema_version': 1, 'ticket': 'TK-11860', 'correlation_id': 'yf2139-i6-execute',
+ 'kind': 'OFFLINE_EVIDENCE_REQUEST_MANIFEST', 'created_at': datetime.now(timezone.utc).isoformat(),
+ 'source': {'path': str(path.resolve()), 'sha256': hashlib.sha256(raw).hexdigest(), 'generated_at': generated},
+ 'historical_totals': {'vendors': 26, 'active_products': 12852, 'distinct_product_sku_key_matches': 10704},
+ 'limitations': ['Key-match counts do not require a populated price on the joined row; column population counts are separate measures.',
+ 'Candidate selection includes registry/name heuristics; table identity and cost meaning require evidence.',
+ 'The source generator swallows query errors; this report does not prove query success or exhaustive identity resolution.',
+ 'Metadata-shaped column names and existing discount stamps are not price/net-cost proof.',
+ 'No external evidence was fetched or sent; no current costs, coverage lift or adoption are established.'],
+ 'vendors': entries, 'source_ticket_status': 'UNRESOLVED_EXTERNAL_EVIDENCE_REQUIRED',
+ 'next_dependency': 'Obtain vendor-external cost evidence and identity/cardinality proof; any adoption into the cost map remains gated.'}
+
+def main():
+ parser = argparse.ArgumentParser(description=__doc__)
+ parser.add_argument('input', type=Path)
+ parser.add_argument('--output', required=True, type=Path)
+ args = parser.parse_args()
+ try:
+ result = build(args.input)
+ except (ValueError, OSError, TypeError, KeyError) as error:
+ parser.exit(2, f'MANIFEST REJECTED: {error}\n')
+ args.output.write_text(json.dumps(result, indent=2) + '\n')
+ print('PASS: 26 vendors / 12,852 active / 10,704 historical key matches; cost semantics UNPROVEN')
+
+if __name__ == '__main__':
+ main()
diff --git a/verification/yoloforever-yf2139.YF57g8/column-manifest/input-snapshot.json b/verification/yoloforever-yf2139.YF57g8/column-manifest/input-snapshot.json
new file mode 100644
index 00000000..3b4bc518
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-manifest/input-snapshot.json
@@ -0,0 +1,2750 @@
+{
+ "summary": {
+ "generated_at": "2026-09-16T21:22:26.640Z",
+ "ticket": "TK-11427",
+ "active_products_total": 91167,
+ "vendors_with_active": 170,
+ "covered_vendors": 32,
+ "buckets": [
+ {
+ "state": "STRONG_CANDIDATE",
+ "vendors": 26,
+ "active_products": 12852,
+ "reachable_products": 10704
+ },
+ {
+ "state": "PARTIAL_CANDIDATE",
+ "vendors": 13,
+ "active_products": 24623,
+ "reachable_products": 4389
+ },
+ {
+ "state": "COLUMN_BUT_NO_JOIN",
+ "vendors": 18,
+ "active_products": 6243,
+ "reachable_products": 0
+ },
+ {
+ "state": "NO_COST_TABLE",
+ "vendors": 81,
+ "active_products": 10735,
+ "reachable_products": 0
+ }
+ ]
+ },
+ "report": [
+ {
+ "vendor": "Phillipe Romano",
+ "active": 13066,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "phillipe_romano_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 474
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1082
+ },
+ "join_pct": 8.3
+ }
+ ],
+ "join_pct": 8.3,
+ "reachable": 1082
+ },
+ {
+ "vendor": "Carnegie",
+ "active": 4147,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Malibu Wallpaper",
+ "active": 3822,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "malibu_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 3551
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1637
+ },
+ "join_pct": 42.8
+ }
+ ],
+ "join_pct": 42.8,
+ "reachable": 1637
+ },
+ {
+ "vendor": "Clarke And Clarke",
+ "active": 3567,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Hollywood Wallcoverings",
+ "active": 3561,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "hollywood_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 5893
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.sku",
+ "matched": 2039
+ },
+ "join_pct": 57.3
+ },
+ {
+ "table": "hollywood_price_audit_log",
+ "cost_columns": [
+ {
+ "col": "new_price",
+ "populated": 102
+ },
+ {
+ "col": "old_price",
+ "populated": 98
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 57.3,
+ "reachable": 2039
+ },
+ {
+ "vendor": "Phillip Jeffries",
+ "active": 3392,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "phillipe_romano_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 474
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Rebel Walls",
+ "active": 3373,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "rebelwalls_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 4382
+ },
+ {
+ "col": "price_per_sqft_nonwoven",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_peelstick",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_retail",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_commercial",
+ "populated": 3958
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1199
+ },
+ "join_pct": 35.5
+ },
+ {
+ "table": "rebel_walls_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 4123
+ },
+ {
+ "col": "price_trade",
+ "populated": 449
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1172
+ },
+ "join_pct": 34.7
+ },
+ {
+ "table": "rebelwalls_catalog_premerge_tk10084",
+ "cost_columns": [
+ {
+ "col": "price_per_sqft_nonwoven",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_retail",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_peelstick",
+ "populated": 4133
+ },
+ {
+ "col": "price_retail",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_commercial",
+ "populated": 3958
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1014
+ },
+ "join_pct": 30.1
+ }
+ ],
+ "join_pct": 35.5,
+ "reachable": 1199
+ },
+ {
+ "vendor": "Thibaut",
+ "active": 3101,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Brunschwig & Fils",
+ "active": 2737,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Jeffrey Stevens",
+ "active": 2654,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "jeffrey_stevens_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 4991
+ },
+ {
+ "col": "cost",
+ "populated": 1
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.sku",
+ "matched": 2652
+ },
+ "join_pct": 99.9
+ }
+ ],
+ "join_pct": 99.9,
+ "reachable": 2652
+ },
+ {
+ "vendor": "Kravet",
+ "active": 2601,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Koroseal",
+ "active": 2449,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Gaston Y Daniela",
+ "active": 2148,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Lee Jofa",
+ "active": 2026,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Los Angeles Fabrics",
+ "active": 1821,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "China Seas",
+ "active": 1776,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Maharam",
+ "active": 1429,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Coordonné",
+ "active": 1428,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "coordonne_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 3676
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 136
+ },
+ "join_pct": 9.5
+ }
+ ],
+ "join_pct": 9.5,
+ "reachable": 136
+ },
+ {
+ "vendor": "Harlequin",
+ "active": 1257,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Cole & Son",
+ "active": 1238,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Sanderson",
+ "active": 1221,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "GP & J Baker",
+ "active": 1191,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Mind the Gap",
+ "active": 1019,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "mindthegap_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 1040
+ },
+ {
+ "col": "price_trade",
+ "populated": 2
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 830
+ },
+ "join_pct": 81.5
+ }
+ ],
+ "join_pct": 81.5,
+ "reachable": 830
+ },
+ {
+ "vendor": "Designer Wallcoverings",
+ "active": 978,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "designers_guild_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 23
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Scalamandre Wallpaper",
+ "active": 942,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "scalamandre_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 5002
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 14
+ },
+ "join_pct": 1.5
+ },
+ {
+ "table": "scalamandre_catalog_prebackfill_bak_20260901172726",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 4996
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 14
+ },
+ "join_pct": 1.5
+ },
+ {
+ "table": "scalamandre_pillows",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 1512
+ },
+ {
+ "col": "price_retail",
+ "populated": 1512
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1
+ },
+ "join_pct": 0.1
+ }
+ ],
+ "join_pct": 1.5,
+ "reachable": 14
+ },
+ {
+ "vendor": "DW Bespoke Studio",
+ "active": 925,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Zoffany",
+ "active": 902,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Anna French",
+ "active": 790,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "anna_french_catalog",
+ "cost_columns": [
+ {
+ "col": "cost",
+ "populated": 731
+ },
+ {
+ "col": "price_retail",
+ "populated": 469
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 651
+ },
+ "join_pct": 82.4
+ }
+ ],
+ "join_pct": 82.4,
+ "reachable": 651
+ },
+ {
+ "vendor": "Sandberg",
+ "active": 743,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "sandberg_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 948
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 557
+ },
+ "join_pct": 75
+ },
+ {
+ "table": "sandberg_catalog_prebackfill_bak_20260901172725",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 945
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 557
+ },
+ "join_pct": 75
+ }
+ ],
+ "join_pct": 75,
+ "reachable": 557
+ },
+ {
+ "vendor": "Pierre Frey",
+ "active": 722,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Designtex",
+ "active": 703,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Wolf Gordon",
+ "active": 688,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Morris & Co.",
+ "active": 686,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "morris_feed_pricing",
+ "cost_columns": [
+ {
+ "col": "trade_usd",
+ "populated": 1162
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "PS Removable Wallpaper",
+ "active": 681,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Surface Stick",
+ "active": 639,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Knoll",
+ "active": 622,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "knoll_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 622
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 622
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "knoll_price_backup_20260806",
+ "cost_columns": [
+ {
+ "col": "orig_cost_price",
+ "populated": 622
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 622
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 622
+ },
+ {
+ "vendor": "Maya Romanoff",
+ "active": 617,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Osborne & Little",
+ "active": 602,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Tres Tintas",
+ "active": 601,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "tres_tintas_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 1556
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 601
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 601
+ },
+ {
+ "vendor": "Romo",
+ "active": 585,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Elitis",
+ "active": 579,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Designers Guild",
+ "active": 568,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "designers_guild_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 23
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 145
+ },
+ "join_pct": 25.5
+ }
+ ],
+ "join_pct": 25.5,
+ "reachable": 145
+ },
+ {
+ "vendor": "William Morris",
+ "active": 522,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Fentucci",
+ "active": 514,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "fentucci_catalog",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 85
+ },
+ {
+ "col": "cost",
+ "populated": 84
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 6
+ },
+ "join_pct": 1.2
+ }
+ ],
+ "join_pct": 1.2,
+ "reachable": 6
+ },
+ {
+ "vendor": "Fentucci Naturals",
+ "active": 504,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "fentucci_catalog",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 85
+ },
+ {
+ "col": "cost",
+ "populated": 84
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Arte International",
+ "active": 489,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "1838 Wallcoverings",
+ "active": 456,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "w1838_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 404
+ },
+ {
+ "col": "maxwell_price",
+ "populated": 332
+ },
+ {
+ "col": "master_cost",
+ "populated": 332
+ },
+ {
+ "col": "price_trade",
+ "populated": 332
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 451
+ },
+ "join_pct": 98.9
+ }
+ ],
+ "join_pct": 98.9,
+ "reachable": 451
+ },
+ {
+ "vendor": "Versace",
+ "active": 454,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "versace_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 158
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 157
+ },
+ "join_pct": 34.6
+ }
+ ],
+ "join_pct": 34.6,
+ "reachable": 157
+ },
+ {
+ "vendor": "Quadrille",
+ "active": 454,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Alan Campbell",
+ "active": 434,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Nina Campbell",
+ "active": 433,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "nina_campbell_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 275
+ },
+ {
+ "col": "price_trade",
+ "populated": 3
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 6
+ },
+ "join_pct": 1.4
+ },
+ {
+ "table": "nina_campbell_catalog_prebackfill_bak_20260901172723",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 238
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 6
+ },
+ "join_pct": 1.4
+ }
+ ],
+ "join_pct": 1.4,
+ "reachable": 6
+ },
+ {
+ "vendor": "Scalamandre",
+ "active": 418,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "scalamandre_pillows",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 1512
+ },
+ {
+ "col": "price_retail",
+ "populated": 1512
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 418
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "scalamandre_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 5002
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 416
+ },
+ "join_pct": 99.5
+ },
+ {
+ "table": "scalamandre_catalog_prebackfill_bak_20260901172726",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 4996
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 416
+ },
+ "join_pct": 99.5
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 418
+ },
+ {
+ "vendor": "Graham & Brown",
+ "active": 405,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "graham_brown_catalog",
+ "cost_columns": [
+ {
+ "col": "retail_price",
+ "populated": 2020
+ },
+ {
+ "col": "dw_retail_price",
+ "populated": 809
+ },
+ {
+ "col": "cost_price",
+ "populated": 809
+ },
+ {
+ "col": "master_cost",
+ "populated": 312
+ },
+ {
+ "col": "vendor_retail_price",
+ "populated": 132
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 403
+ },
+ "join_pct": 99.5
+ },
+ {
+ "table": "graham_brown_murals",
+ "cost_columns": [
+ {
+ "col": "retail_price",
+ "populated": 36
+ },
+ {
+ "col": "price_per_sqft",
+ "populated": 36
+ },
+ {
+ "col": "member_price_per_sqm",
+ "populated": 36
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 99.5,
+ "reachable": 403
+ },
+ {
+ "vendor": "Glitter Walls",
+ "active": 405,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "glitter_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 121
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "British Walls",
+ "active": 351,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "CMO Paris",
+ "active": 344,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "AS Creation",
+ "active": 327,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Mulberry",
+ "active": 317,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Fabricut",
+ "active": 276,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "fabricut_catalog",
+ "cost_columns": [
+ {
+ "col": "vendor_msrp",
+ "populated": 1263
+ },
+ {
+ "col": "price_retail",
+ "populated": 1263
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 274
+ },
+ "join_pct": 99.3
+ }
+ ],
+ "join_pct": 99.3,
+ "reachable": 274
+ },
+ {
+ "vendor": "Suncloth",
+ "active": 254,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Newwall",
+ "active": 251,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "newwall_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 8713
+ },
+ {
+ "col": "price_trade",
+ "populated": 6276
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 251
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 251
+ },
+ {
+ "vendor": "Groundworks",
+ "active": 237,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Home Couture",
+ "active": 229,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Innovations USA",
+ "active": 202,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "innovations_catalog",
+ "cost_columns": [
+ {
+ "col": "price_source",
+ "populated": 221
+ },
+ {
+ "col": "price_trade",
+ "populated": 220
+ },
+ {
+ "col": "price_retail",
+ "populated": 182
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.dw_sku",
+ "matched": 160
+ },
+ "join_pct": 79.2
+ }
+ ],
+ "join_pct": 79.2,
+ "reachable": 160
+ },
+ {
+ "vendor": "Plains",
+ "active": 181,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Stout Textiles",
+ "active": 180,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "stout_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 180
+ },
+ {
+ "col": "price_retail",
+ "populated": 180
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 180
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 180
+ },
+ {
+ "vendor": "De Gournay",
+ "active": 172,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Ronald Redding",
+ "active": 167,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Novasuede",
+ "active": 166,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Majilite",
+ "active": 160,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Brand McKenzie",
+ "active": 155,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "brand_mckenzie_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 167
+ },
+ {
+ "col": "price_trade",
+ "populated": 37
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 118
+ },
+ "join_pct": 76.1
+ },
+ {
+ "table": "brand_mckenzie_products",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 110
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 76.1,
+ "reachable": 118
+ },
+ {
+ "vendor": "Artmura",
+ "active": 144,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Ralph Lauren",
+ "active": 140,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Roberto Cavalli Wallpaper",
+ "active": 140,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "roberto_cavalli_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 82
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Donghia",
+ "active": 125,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "donghia_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 167
+ },
+ {
+ "col": "price_trade",
+ "populated": 167
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 124
+ },
+ "join_pct": 99.2
+ }
+ ],
+ "join_pct": 99.2,
+ "reachable": 124
+ },
+ {
+ "vendor": "Newmor Wallcoverings",
+ "active": 116,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "newmor_sku_reconcile",
+ "cost_columns": [
+ {
+ "col": "live_price",
+ "populated": 542
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 116
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 116
+ },
+ {
+ "vendor": "Marburg",
+ "active": 112,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "marburg_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 2559
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 96
+ },
+ "join_pct": 85.7
+ }
+ ],
+ "join_pct": 85.7,
+ "reachable": 96
+ },
+ {
+ "vendor": "Ultrasuede",
+ "active": 109,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Laura Ashley Wallpaper",
+ "active": 107,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Mid Century Modern",
+ "active": 106,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Hospitality Wallcoverings",
+ "active": 98,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "PR Faux Leather",
+ "active": 97,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "LA Walls",
+ "active": 94,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Charles Burger",
+ "active": 79,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Christian Lacroix Europe",
+ "active": 77,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Nobilis",
+ "active": 74,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Primo Leathers",
+ "active": 72,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Sister Parish",
+ "active": 71,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Threads",
+ "active": 71,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "LEED Walls",
+ "active": 68,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Pixels",
+ "active": 59,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Glambeads by DW",
+ "active": 58,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Daisy Bennett",
+ "active": 58,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "daisy_bennett_v2_stage",
+ "cost_columns": [
+ {
+ "col": "price_cost",
+ "populated": 64
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "daisy_bennett_v2_catalog",
+ "cost_columns": [
+ {
+ "col": "cost",
+ "populated": 52
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "daisy_bennett_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 63
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Luxury Murals",
+ "active": 56,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "MC Escher Wallpaper",
+ "active": 50,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Steve Abrams Studios",
+ "active": 50,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Missoni Wallpaper",
+ "active": 49,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Madagascar Walls",
+ "active": 49,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Anthology",
+ "active": 48,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Retro Walls",
+ "active": 48,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Lincrusta",
+ "active": 47,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "lincrusta_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 47
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 45
+ },
+ "join_pct": 95.7
+ }
+ ],
+ "join_pct": 95.7,
+ "reachable": 45
+ },
+ {
+ "vendor": "FallingStar Studio",
+ "active": 42,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Sancar",
+ "active": 42,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "sancar_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 3418
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 42
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 42
+ },
+ {
+ "vendor": "Cloth and Paper",
+ "active": 41,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "quadrille_house_catalog",
+ "cost_columns": [
+ {
+ "col": "cost_price",
+ "populated": 1928
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 40
+ },
+ "join_pct": 97.6
+ }
+ ],
+ "join_pct": 97.6,
+ "reachable": 40
+ },
+ {
+ "vendor": "Graduate Collection",
+ "active": 40,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Apartment Wallpaper",
+ "active": 38,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "DW Home",
+ "active": 37,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Marimekko Exclusive",
+ "active": 35,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Graduate Collection UK",
+ "active": 29,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Glass Beaded",
+ "active": 29,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "glass_bead_products",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 717
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Franquemont London",
+ "active": 26,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "franquemont_catalog",
+ "cost_columns": [
+ {
+ "col": "roll_price",
+ "populated": 26
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 26
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 26
+ },
+ {
+ "vendor": "Natural Paint",
+ "active": 26,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Dolce & Gabbana",
+ "active": 26,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "dolce_gabbana_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 15
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Phyllis Morris",
+ "active": 24,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Zeuxis Parrhasius Europe",
+ "active": 21,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Contrado",
+ "active": 15,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "contrado_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 11
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "contrado_catalog_prebackfill_bak_20260901172453",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 8
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Hand Crafted",
+ "active": 15,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Traditional Whimsy",
+ "active": 13,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Hollywood Acoustical",
+ "active": 13,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "hollywood_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 5893
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 4
+ },
+ "join_pct": 30.8
+ },
+ {
+ "table": "hollywood_price_audit_log",
+ "cost_columns": [
+ {
+ "col": "new_price",
+ "populated": 102
+ },
+ {
+ "col": "old_price",
+ "populated": 98
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 30.8,
+ "reachable": 4
+ },
+ {
+ "vendor": "Witch & Watchman",
+ "active": 10,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "SUGARBOO",
+ "active": 10,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Backdrop",
+ "active": 9,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Innovations",
+ "active": 8,
+ "state": "COVERED"
+ },
+ {
+ "vendor": "Wallpaper NYC",
+ "active": 6,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Zeuxis Parrhasius at DW",
+ "active": 5,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Andrew Martin",
+ "active": 5,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "andrew_martin_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 185
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 3
+ },
+ "join_pct": 60
+ }
+ ],
+ "join_pct": 60,
+ "reachable": 3
+ },
+ {
+ "vendor": "Architectural Wallcoverings",
+ "active": 4,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Baker Lifestyle",
+ "active": 4,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "baker_lifestyle_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 74
+ },
+ {
+ "col": "price_retail",
+ "populated": 74
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1
+ },
+ "join_pct": 25
+ }
+ ],
+ "join_pct": 25,
+ "reachable": 1
+ },
+ {
+ "vendor": "Black Edition",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Malibu",
+ "active": 3,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "malibu_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 3551
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 1
+ },
+ "join_pct": 33.3
+ }
+ ],
+ "join_pct": 33.3,
+ "reachable": 1
+ },
+ {
+ "vendor": "Malibu Walls",
+ "active": 3,
+ "state": "PARTIAL_CANDIDATE",
+ "candidates": [
+ {
+ "table": "malibu_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 3551
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 1
+ },
+ "join_pct": 33.3
+ }
+ ],
+ "join_pct": 33.3,
+ "reachable": 1
+ },
+ {
+ "vendor": "Holland and Sherry",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Peg Norriss",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Sacha Walckhoff",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Clarke and Clarke",
+ "active": 3,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "clarke_clarke_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 578
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Caroline Cecil Textiles",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Villa Nova",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Zinc Textile",
+ "active": 3,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Patty Madden",
+ "active": 2,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Kravet Design",
+ "active": 2,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "kravet_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 9494
+ },
+ {
+ "col": "price_trade",
+ "populated": 9494
+ },
+ {
+ "col": "cost_price",
+ "populated": 8592
+ },
+ {
+ "col": "price_effective_date",
+ "populated": 8221
+ },
+ {
+ "col": "price_retail_new",
+ "populated": 8191
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_map_authoritative",
+ "cost_columns": [
+ {
+ "col": "retail_price",
+ "populated": 4522
+ },
+ {
+ "col": "map_price",
+ "populated": 4522
+ },
+ {
+ "col": "whls_cost",
+ "populated": 4522
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_dwkk_variant_map",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 14030
+ },
+ {
+ "col": "cost",
+ "populated": 26
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 2
+ },
+ {
+ "vendor": "Atomic 50 Ceilings",
+ "active": 2,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Kirkby Design",
+ "active": 2,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Kravet Couture",
+ "active": 2,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "kravet_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 9494
+ },
+ {
+ "col": "price_trade",
+ "populated": 9494
+ },
+ {
+ "col": "cost_price",
+ "populated": 8592
+ },
+ {
+ "col": "price_effective_date",
+ "populated": 8221
+ },
+ {
+ "col": "price_retail_new",
+ "populated": 8191
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_dwkk_variant_map",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 14030
+ },
+ {
+ "col": "cost",
+ "populated": 26
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_master_price",
+ "cost_columns": [
+ {
+ "col": "map_price",
+ "populated": 13726
+ },
+ {
+ "col": "whls_cost",
+ "populated": 13726
+ },
+ {
+ "col": "retail_price",
+ "populated": 4685
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 2
+ },
+ {
+ "vendor": "Winfield Thybony",
+ "active": 2,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Scion",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Linherr Hollingsworth",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "DW Exclusive Wallpaper",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Steven Abrams Photography",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "DWHD",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Studio Ditte",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "studio_printworks_catalog",
+ "cost_columns": [
+ {
+ "col": "price_sample",
+ "populated": 383
+ },
+ {
+ "col": "price_retail",
+ "populated": 383
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Emiliana Parati",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Farrow & Ball",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "farrow_ball_catalog",
+ "cost_columns": [
+ {
+ "col": "price_gbp",
+ "populated": 545
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "farrow_ball_paints",
+ "cost_columns": [
+ {
+ "col": "price_usd",
+ "populated": 301
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "G P & J Baker",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Happy Menocal",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Architectural Fabrics",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Morris and Company",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "morris_feed_pricing",
+ "cost_columns": [
+ {
+ "col": "trade_usd",
+ "populated": 1162
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Milton & King",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "A.S. Création",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Mark Alexander",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Dedar",
+ "active": 1,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "dedar_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 46
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 1
+ },
+ {
+ "vendor": "Roberto Cavalli",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "roberto_cavalli_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 82
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Rebel Studio",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "rebel_walls_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 4123
+ },
+ {
+ "col": "price_trade",
+ "populated": 449
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "rebelwalls_catalog_premerge_tk10084",
+ "cost_columns": [
+ {
+ "col": "price_per_sqft_nonwoven",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_retail",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_peelstick",
+ "populated": 4133
+ },
+ {
+ "col": "price_retail",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_commercial",
+ "populated": 3958
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "rebelwalls_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 4382
+ },
+ {
+ "col": "price_per_sqft_nonwoven",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_peelstick",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_retail",
+ "populated": 4133
+ },
+ {
+ "col": "price_per_sqft_commercial",
+ "populated": 3958
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Ananbo",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Dupenny",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Rebecca Moses",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Sara Bergqvist",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Sarah Bartholomew",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Celerie Kemble",
+ "active": 1,
+ "state": "NO_COST_TABLE",
+ "candidates": [],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Scalamandre Fabrics",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "scalamandre_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 5002
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "scalamandre_pillows",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 1512
+ },
+ {
+ "col": "price_retail",
+ "populated": 1512
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ },
+ {
+ "table": "scalamandre_catalog_prebackfill_bak_20260901172726",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 4996
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ },
+ {
+ "vendor": "Catchii Netherlands Europe",
+ "active": 1,
+ "state": "COLUMN_BUT_NO_JOIN",
+ "candidates": [
+ {
+ "table": "catchii_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 670
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 0,
+ "reachable": 0
+ }
+ ]
+}
\ No newline at end of file
diff --git a/verification/yoloforever-yf2139.YF57g8/column-manifest/manifest.json b/verification/yoloforever-yf2139.YF57g8/column-manifest/manifest.json
new file mode 100644
index 00000000..ae95f733
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-manifest/manifest.json
@@ -0,0 +1,1464 @@
+{
+ "schema_version": 1,
+ "ticket": "TK-11860",
+ "correlation_id": "yf2139-i6-execute",
+ "kind": "OFFLINE_EVIDENCE_REQUEST_MANIFEST",
+ "created_at": "2026-09-16T22:16:18.232730+00:00",
+ "source": {
+ "path": "/private/tmp/yf2139.YF57g8/column-manifest/input-snapshot.json",
+ "sha256": "fe1406dd96ec286e291373d363b0929a65d54bd5c0ff9542017e31a7b997151a",
+ "generated_at": "2026-09-16T21:22:26.640Z"
+ },
+ "historical_totals": {
+ "vendors": 26,
+ "active_products": 12852,
+ "distinct_product_sku_key_matches": 10704
+ },
+ "limitations": [
+ "Key-match counts do not require a populated price on the joined row; column population counts are separate measures.",
+ "Candidate selection includes registry/name heuristics; table identity and cost meaning require evidence.",
+ "The source generator swallows query errors; this report does not prove query success or exhaustive identity resolution.",
+ "Metadata-shaped column names and existing discount stamps are not price/net-cost proof.",
+ "No external evidence was fetched or sent; no current costs, coverage lift or adoption are established."
+ ],
+ "vendors": [
+ {
+ "vendor": "Hollywood Wallcoverings",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 3561,
+ "distinct_product_sku_key_matches_reported": 2039,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Hollywood Wallcoverings",
+ "active": 3561,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "hollywood_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 5893
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.sku",
+ "matched": 2039
+ },
+ "join_pct": 57.3
+ },
+ {
+ "table": "hollywood_price_audit_log",
+ "cost_columns": [
+ {
+ "col": "new_price",
+ "populated": 102
+ },
+ {
+ "col": "old_price",
+ "populated": 98
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 57.3,
+ "reachable": 2039
+ }
+ },
+ {
+ "vendor": "Jeffrey Stevens",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 2654,
+ "distinct_product_sku_key_matches_reported": 2652,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Jeffrey Stevens",
+ "active": 2654,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "jeffrey_stevens_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 4991
+ },
+ {
+ "col": "cost",
+ "populated": 1
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.sku",
+ "matched": 2652
+ },
+ "join_pct": 99.9
+ }
+ ],
+ "join_pct": 99.9,
+ "reachable": 2652
+ }
+ },
+ {
+ "vendor": "Mind the Gap",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 1019,
+ "distinct_product_sku_key_matches_reported": 830,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Mind the Gap",
+ "active": 1019,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "mindthegap_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 1040
+ },
+ {
+ "col": "price_trade",
+ "populated": 2
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 830
+ },
+ "join_pct": 81.5
+ }
+ ],
+ "join_pct": 81.5,
+ "reachable": 830
+ }
+ },
+ {
+ "vendor": "Anna French",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 790,
+ "distinct_product_sku_key_matches_reported": 651,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Anna French",
+ "active": 790,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "anna_french_catalog",
+ "cost_columns": [
+ {
+ "col": "cost",
+ "populated": 731
+ },
+ {
+ "col": "price_retail",
+ "populated": 469
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 651
+ },
+ "join_pct": 82.4
+ }
+ ],
+ "join_pct": 82.4,
+ "reachable": 651
+ }
+ },
+ {
+ "vendor": "Sandberg",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 743,
+ "distinct_product_sku_key_matches_reported": 557,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Sandberg",
+ "active": 743,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "sandberg_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 948
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 557
+ },
+ "join_pct": 75
+ },
+ {
+ "table": "sandberg_catalog_prebackfill_bak_20260901172725",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 945
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 557
+ },
+ "join_pct": 75
+ }
+ ],
+ "join_pct": 75,
+ "reachable": 557
+ }
+ },
+ {
+ "vendor": "Knoll",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 622,
+ "distinct_product_sku_key_matches_reported": 622,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Knoll",
+ "active": 622,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "knoll_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 622
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 622
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "knoll_price_backup_20260806",
+ "cost_columns": [
+ {
+ "col": "orig_cost_price",
+ "populated": 622
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 622
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 622
+ }
+ },
+ {
+ "vendor": "Tres Tintas",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 601,
+ "distinct_product_sku_key_matches_reported": 601,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Tres Tintas",
+ "active": 601,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "tres_tintas_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 1556
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 601
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 601
+ }
+ },
+ {
+ "vendor": "1838 Wallcoverings",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 456,
+ "distinct_product_sku_key_matches_reported": 451,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "1838 Wallcoverings",
+ "active": 456,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "w1838_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 404
+ },
+ {
+ "col": "maxwell_price",
+ "populated": 332
+ },
+ {
+ "col": "master_cost",
+ "populated": 332
+ },
+ {
+ "col": "price_trade",
+ "populated": 332
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 451
+ },
+ "join_pct": 98.9
+ }
+ ],
+ "join_pct": 98.9,
+ "reachable": 451
+ }
+ },
+ {
+ "vendor": "Scalamandre",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 418,
+ "distinct_product_sku_key_matches_reported": 418,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Scalamandre",
+ "active": 418,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "scalamandre_pillows",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 1512
+ },
+ {
+ "col": "price_retail",
+ "populated": 1512
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 418
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "scalamandre_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 5002
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 416
+ },
+ "join_pct": 99.5
+ },
+ {
+ "table": "scalamandre_catalog_prebackfill_bak_20260901172726",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 4996
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 416
+ },
+ "join_pct": 99.5
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 418
+ }
+ },
+ {
+ "vendor": "Graham & Brown",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 405,
+ "distinct_product_sku_key_matches_reported": 403,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Graham & Brown",
+ "active": 405,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "graham_brown_catalog",
+ "cost_columns": [
+ {
+ "col": "retail_price",
+ "populated": 2020
+ },
+ {
+ "col": "dw_retail_price",
+ "populated": 809
+ },
+ {
+ "col": "cost_price",
+ "populated": 809
+ },
+ {
+ "col": "master_cost",
+ "populated": 312
+ },
+ {
+ "col": "vendor_retail_price",
+ "populated": 132
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 403
+ },
+ "join_pct": 99.5
+ },
+ {
+ "table": "graham_brown_murals",
+ "cost_columns": [
+ {
+ "col": "retail_price",
+ "populated": 36
+ },
+ {
+ "col": "price_per_sqft",
+ "populated": 36
+ },
+ {
+ "col": "member_price_per_sqm",
+ "populated": 36
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 99.5,
+ "reachable": 403
+ }
+ },
+ {
+ "vendor": "Fabricut",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 276,
+ "distinct_product_sku_key_matches_reported": 274,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Fabricut",
+ "active": 276,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "fabricut_catalog",
+ "cost_columns": [
+ {
+ "col": "vendor_msrp",
+ "populated": 1263
+ },
+ {
+ "col": "price_retail",
+ "populated": 1263
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 274
+ },
+ "join_pct": 99.3
+ }
+ ],
+ "join_pct": 99.3,
+ "reachable": 274
+ }
+ },
+ {
+ "vendor": "Newwall",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 251,
+ "distinct_product_sku_key_matches_reported": 251,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Newwall",
+ "active": 251,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "newwall_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 8713
+ },
+ {
+ "col": "price_trade",
+ "populated": 6276
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 251
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 251
+ }
+ },
+ {
+ "vendor": "Innovations USA",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 202,
+ "distinct_product_sku_key_matches_reported": 160,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [
+ {
+ "table": "innovations_catalog",
+ "column": "price_source",
+ "flag": "METADATA_SHAPED_NOT_COST_PROOF"
+ }
+ ],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Innovations USA",
+ "active": 202,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "innovations_catalog",
+ "cost_columns": [
+ {
+ "col": "price_source",
+ "populated": 221
+ },
+ {
+ "col": "price_trade",
+ "populated": 220
+ },
+ {
+ "col": "price_retail",
+ "populated": 182
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.dw_sku",
+ "matched": 160
+ },
+ "join_pct": 79.2
+ }
+ ],
+ "join_pct": 79.2,
+ "reachable": 160
+ }
+ },
+ {
+ "vendor": "Stout Textiles",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 180,
+ "distinct_product_sku_key_matches_reported": 180,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Stout Textiles",
+ "active": 180,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "stout_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 180
+ },
+ {
+ "col": "price_retail",
+ "populated": 180
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 180
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 180
+ }
+ },
+ {
+ "vendor": "Brand McKenzie",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 155,
+ "distinct_product_sku_key_matches_reported": 118,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Brand McKenzie",
+ "active": 155,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "brand_mckenzie_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 167
+ },
+ {
+ "col": "price_trade",
+ "populated": 37
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 118
+ },
+ "join_pct": 76.1
+ },
+ {
+ "table": "brand_mckenzie_products",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 110
+ }
+ ],
+ "best_join": {
+ "key": null,
+ "matched": 0
+ },
+ "join_pct": 0
+ }
+ ],
+ "join_pct": 76.1,
+ "reachable": 118
+ }
+ },
+ {
+ "vendor": "Donghia",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 125,
+ "distinct_product_sku_key_matches_reported": 124,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Donghia",
+ "active": 125,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "donghia_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 167
+ },
+ {
+ "col": "price_trade",
+ "populated": 167
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 124
+ },
+ "join_pct": 99.2
+ }
+ ],
+ "join_pct": 99.2,
+ "reachable": 124
+ }
+ },
+ {
+ "vendor": "Newmor Wallcoverings",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 116,
+ "distinct_product_sku_key_matches_reported": 116,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [
+ {
+ "table": "newmor_sku_reconcile",
+ "column": "live_price",
+ "flag": "LIVE_PRICE_UNPROVEN_AS_ACQUISITION_COST"
+ }
+ ],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Newmor Wallcoverings",
+ "active": 116,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "newmor_sku_reconcile",
+ "cost_columns": [
+ {
+ "col": "live_price",
+ "populated": 542
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 116
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 116
+ }
+ },
+ {
+ "vendor": "Marburg",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 112,
+ "distinct_product_sku_key_matches_reported": 96,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Marburg",
+ "active": 112,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "marburg_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 2559
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 96
+ },
+ "join_pct": 85.7
+ }
+ ],
+ "join_pct": 85.7,
+ "reachable": 96
+ }
+ },
+ {
+ "vendor": "Lincrusta",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 47,
+ "distinct_product_sku_key_matches_reported": 45,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Lincrusta",
+ "active": 47,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "lincrusta_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 47
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 45
+ },
+ "join_pct": 95.7
+ }
+ ],
+ "join_pct": 95.7,
+ "reachable": 45
+ }
+ },
+ {
+ "vendor": "Sancar",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 42,
+ "distinct_product_sku_key_matches_reported": 42,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Sancar",
+ "active": 42,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "sancar_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 3418
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 42
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 42
+ }
+ },
+ {
+ "vendor": "Cloth and Paper",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 41,
+ "distinct_product_sku_key_matches_reported": 40,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Cloth and Paper",
+ "active": 41,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "quadrille_house_catalog",
+ "cost_columns": [
+ {
+ "col": "cost_price",
+ "populated": 1928
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 40
+ },
+ "join_pct": 97.6
+ }
+ ],
+ "join_pct": 97.6,
+ "reachable": 40
+ }
+ },
+ {
+ "vendor": "Franquemont London",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 26,
+ "distinct_product_sku_key_matches_reported": 26,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Franquemont London",
+ "active": 26,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "franquemont_catalog",
+ "cost_columns": [
+ {
+ "col": "roll_price",
+ "populated": 26
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 26
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 26
+ }
+ },
+ {
+ "vendor": "Andrew Martin",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 5,
+ "distinct_product_sku_key_matches_reported": 3,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Andrew Martin",
+ "active": 5,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "andrew_martin_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 185
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 3
+ },
+ "join_pct": 60
+ }
+ ],
+ "join_pct": 60,
+ "reachable": 3
+ }
+ },
+ {
+ "vendor": "Kravet Design",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 2,
+ "distinct_product_sku_key_matches_reported": 2,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [
+ {
+ "table": "kravet_catalog",
+ "column": "price_effective_date",
+ "flag": "METADATA_SHAPED_NOT_COST_PROOF"
+ }
+ ],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Kravet Design",
+ "active": 2,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "kravet_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 9494
+ },
+ {
+ "col": "price_trade",
+ "populated": 9494
+ },
+ {
+ "col": "cost_price",
+ "populated": 8592
+ },
+ {
+ "col": "price_effective_date",
+ "populated": 8221
+ },
+ {
+ "col": "price_retail_new",
+ "populated": 8191
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_map_authoritative",
+ "cost_columns": [
+ {
+ "col": "retail_price",
+ "populated": 4522
+ },
+ {
+ "col": "map_price",
+ "populated": 4522
+ },
+ {
+ "col": "whls_cost",
+ "populated": 4522
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_dwkk_variant_map",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 14030
+ },
+ {
+ "col": "cost",
+ "populated": 26
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 2
+ }
+ },
+ {
+ "vendor": "Kravet Couture",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 2,
+ "distinct_product_sku_key_matches_reported": 2,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [
+ {
+ "table": "kravet_catalog",
+ "column": "price_effective_date",
+ "flag": "METADATA_SHAPED_NOT_COST_PROOF"
+ }
+ ],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Kravet Couture",
+ "active": 2,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "kravet_catalog",
+ "cost_columns": [
+ {
+ "col": "price_retail",
+ "populated": 9494
+ },
+ {
+ "col": "price_trade",
+ "populated": 9494
+ },
+ {
+ "col": "cost_price",
+ "populated": 8592
+ },
+ {
+ "col": "price_effective_date",
+ "populated": 8221
+ },
+ {
+ "col": "price_retail_new",
+ "populated": 8191
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_dwkk_variant_map",
+ "cost_columns": [
+ {
+ "col": "price",
+ "populated": 14030
+ },
+ {
+ "col": "cost",
+ "populated": 26
+ }
+ ],
+ "best_join": {
+ "key": "ct.dw_sku=sp.sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ },
+ {
+ "table": "kravet_master_price",
+ "cost_columns": [
+ {
+ "col": "map_price",
+ "populated": 13726
+ },
+ {
+ "col": "whls_cost",
+ "populated": 13726
+ },
+ {
+ "col": "retail_price",
+ "populated": 4685
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 2
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 2
+ }
+ },
+ {
+ "vendor": "Dedar",
+ "cost_semantics": "UNPROVEN",
+ "external_evidence_status": "NOT_VERIFIED_IN_THIS_PASS",
+ "active_products_reported": 1,
+ "distinct_product_sku_key_matches_reported": 1,
+ "column_population_is_separate_from_join_counts": true,
+ "flags": [],
+ "evidence_requirements": {
+ "sku": "Vendor-external SKU matched to the exact candidate catalog row and live product identity; no SKU is invented here.",
+ "unit": "Quoted purchase unit and catalog unit, pack/roll dimensions and conversion evidence if different.",
+ "currency": "Explicit acquisition-cost currency and documented conversion basis if needed.",
+ "effective_date": "Document date, price effective date and any expiry/supersession evidence.",
+ "basis": "Dated vendor quote, invoice or authoritative list identifying net/trade/list basis; a column name or our sell price is insufficient.",
+ "discount_proof": "If list/retail basis, documented vendor discount and scope; registry stamp alone or a default0% is insufficient.",
+ "table_identity": "Prove each proposed table belongs to this upstream/vendor/cohort; retained candidate names are hypotheses.",
+ "population": "For the proposed cost column, establish populated positive values on joined rows, uniqueness/fan-out, cross-vendor scope and captured query errors."
+ },
+ "acquired_external_evidence": null,
+ "original_row": {
+ "vendor": "Dedar",
+ "active": 1,
+ "state": "STRONG_CANDIDATE",
+ "candidates": [
+ {
+ "table": "dedar_catalog",
+ "cost_columns": [
+ {
+ "col": "price_trade",
+ "populated": 46
+ }
+ ],
+ "best_join": {
+ "key": "ct.mfr_sku=sp.mfr_sku",
+ "matched": 1
+ },
+ "join_pct": 100
+ }
+ ],
+ "join_pct": 100,
+ "reachable": 1
+ }
+ }
+ ],
+ "source_ticket_status": "UNRESOLVED_EXTERNAL_EVIDENCE_REQUIRED",
+ "next_dependency": "Obtain vendor-external cost evidence and identity/cardinality proof; any adoption into the cost map remains gated."
+}
diff --git a/verification/yoloforever-yf2139.YF57g8/column-manifest/verification/e2e-proof.json b/verification/yoloforever-yf2139.YF57g8/column-manifest/verification/e2e-proof.json
new file mode 100644
index 00000000..c9bca260
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-manifest/verification/e2e-proof.json
@@ -0,0 +1,67 @@
+{
+ "schema_version": 1,
+ "risk_tier": "R0 isolated offline artifact",
+ "intent": "Prepare actual26 vendor-external cost evidence requirements without inventing authority.",
+ "correlation_id": "yf2139-i6-execute",
+ "timestamp": "2026-09-16T22:16:18.232730+00:00",
+ "build_identity": "Root independent acceptance/commit pending",
+ "baseline": {
+ "guard": "ZERO_COST_REQUIRED",
+ "DTD_ZERO_COST": "1",
+ "source_sha256": "fe1406dd96ec286e291373d363b0929a65d54bd5c0ff9542017e31a7b997151a",
+ "source_generated_at": "2026-09-16T21:22:26.640Z"
+ },
+ "commands": [
+ {
+ "command": "python3 generate.py input-snapshot.json --output manifest.json",
+ "exit_code": 0
+ },
+ {
+ "command": "python3 verify.py",
+ "exit_code": 0,
+ "result": "PASS real replay, all original candidates preserved, totals/schema/flags/source hash; malformed and summary mismatch rejected"
+ }
+ ],
+ "assertions": [
+ {
+ "boundary": "retained input -> manifest",
+ "verdict": "PASS",
+ "evidence": "All26 original rows and every candidate data structure equal; historical26/12852/10704 preserved"
+ },
+ {
+ "boundary": "evidence requirements",
+ "verdict": "PASS",
+ "evidence": "All26 carry SKU/unit/currency/date/basis/discount/table identity/population requirements; acquired evidence null; semantics UNPROVEN"
+ },
+ {
+ "boundary": "metadata flags",
+ "verdict": "PASS",
+ "evidence": "price_source, price_effective_date, live_price explicitly flagged"
+ },
+ {
+ "boundary": "malformed input -> output",
+ "verdict": "PASS",
+ "evidence": "Malformed JSON and summary mismatch exit2 without creating output; fixtures retained under /private/tmp"
+ },
+ {
+ "boundary": "external acquisition cost/production",
+ "verdict": "SKIP",
+ "reason": "Explicitly excluded. Source remains unresolved until external evidence and gated adoption"
+ },
+ {
+ "boundary": "parent acceptance",
+ "verdict": "SKIP",
+ "reason": "Root independently verifies"
+ }
+ ],
+ "cleanup": "No cleanup or deletion; input snapshot, output and mktemp fixtures retained.",
+ "artifacts": [
+ "input-snapshot.json",
+ "generate.py",
+ "verify.py",
+ "manifest.json",
+ "README.md"
+ ],
+ "verdict": "PASS offline preparation only; no coverage lift or source resolution",
+ "retained_fixture": "/private/tmp/yf2139-column-check.3y30pH"
+}
diff --git a/verification/yoloforever-yf2139.YF57g8/column-manifest/verify.py b/verification/yoloforever-yf2139.YF57g8/column-manifest/verify.py
new file mode 100644
index 00000000..ed1a64d2
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-manifest/verify.py
@@ -0,0 +1,38 @@
+"""Replay retained evidence and retain malformed fixtures; standard library only."""
+import hashlib
+import json
+import subprocess
+import sys
+from pathlib import Path
+
+ROOT = Path(__file__).resolve().parent
+snapshot = ROOT / 'input-snapshot.json'
+raw = snapshot.read_bytes()
+assert hashlib.sha256(raw).hexdigest() == 'fe1406dd96ec286e291373d363b0929a65d54bd5c0ff9542017e31a7b997151a'
+fixture = Path(subprocess.check_output(['mktemp', '-d', '/private/tmp/yf2139-column-check.XXXXXX'], text=True).strip())
+run = subprocess.run([sys.executable, str(ROOT / 'generate.py'), str(snapshot), '--output', str(fixture / 'manifest.json')], capture_output=True, text=True)
+assert run.returncode == 0, run.stderr
+result = json.loads((fixture / 'manifest.json').read_text())
+source = json.loads(raw)
+actual = [r for r in source['report'] if r['state'] == 'STRONG_CANDIDATE']
+assert len(actual) == 26 and [v['original_row'] for v in result['vendors']] == actual
+assert sum(v['active_products_reported'] for v in result['vendors']) == 12852
+assert sum(v['distinct_product_sku_key_matches_reported'] for v in result['vendors']) == 10704
+assert all(v['cost_semantics'] == 'UNPROVEN' and v['acquired_external_evidence'] is None for v in result['vendors'])
+required = {'sku', 'unit', 'currency', 'effective_date', 'basis', 'discount_proof', 'table_identity', 'population'}
+assert all(set(v['evidence_requirements']) == required for v in result['vendors'])
+flags = [f for v in result['vendors'] for f in v['flags']]
+assert {'price_source', 'price_effective_date', 'live_price'} <= {f['column'] for f in flags}
+for label, content in [('malformed', '{invalid'), ('summary-mismatch', None)]:
+ if content is None:
+ changed = json.loads(raw)
+ next(b for b in changed['summary']['buckets'] if b['state'] == 'STRONG_CANDIDATE')['reachable_products'] += 1
+ content = json.dumps(changed)
+ bad, output = fixture / (label + '.json'), fixture / (label + '-output.json')
+ bad.write_text(content)
+ rejected = subprocess.run([sys.executable, str(ROOT / 'generate.py'), str(bad), '--output', str(output)], capture_output=True, text=True)
+ assert rejected.returncode == 2 and 'MANIFEST REJECTED' in rejected.stderr
+ assert not output.exists()
+assert snapshot.read_bytes() == raw
+print('PASS: real replay, all original candidates preserved, totals/schema/flags/source hash; malformed and summary mismatch rejected')
+print('RETAINED_FIXTURE=' + str(fixture))
diff --git a/verification/yoloforever-yf2139.YF57g8/column-parent-proof.json b/verification/yoloforever-yf2139.YF57g8/column-parent-proof.json
new file mode 100644
index 00000000..3c00e692
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/column-parent-proof.json
@@ -0,0 +1,30 @@
+{
+ "real_cli": "PASS",
+ "all26original_rows_preserved": "PASS",
+ "10704_keymatches_notcost": "PASS",
+ "metadata_flags": [
+ {
+ "table": "innovations_catalog",
+ "column": "price_source",
+ "flag": "METADATA_SHAPED_NOT_COST_PROOF"
+ },
+ {
+ "table": "newmor_sku_reconcile",
+ "column": "live_price",
+ "flag": "LIVE_PRICE_UNPROVEN_AS_ACQUISITION_COST"
+ },
+ {
+ "table": "kravet_catalog",
+ "column": "price_effective_date",
+ "flag": "METADATA_SHAPED_NOT_COST_PROOF"
+ },
+ {
+ "table": "kravet_catalog",
+ "column": "price_effective_date",
+ "flag": "METADATA_SHAPED_NOT_COST_PROOF"
+ }
+ ],
+ "negative_malformed_and_total": "PASS",
+ "evidence": "/private/tmp/yf-column-parent.18aiQ9",
+ "source_outcome": "UNVERIFIED"
+}
\ No newline at end of file
diff --git a/verification/yoloforever-yf2139.YF57g8/increment6-dtd.json b/verification/yoloforever-yf2139.YF57g8/increment6-dtd.json
new file mode 100644
index 00000000..f1e4840a
--- /dev/null
+++ b/verification/yoloforever-yf2139.YF57g8/increment6-dtd.json
@@ -0,0 +1,19 @@
+{
+ "decision": "A",
+ "tally": "5/5valid",
+ "dissent": "none",
+ "votes": {
+ "exo.txt": "[exo unavailable: no good+safe model loaded on cluster]\n",
+ "kimi.txt": "[kimi disabled: DTD_ZERO_COST=1 \u2014 paid lens intentionally skipped, not a failure]\n",
+ "heretic.txt": "[ERR heretic]\n",
+ "grok.txt": "[grok disabled: DTD_ZERO_COST=1 \u2014 paid lens intentionally skipped, not a failure]\n",
+ "qwen.txt": "**VERDICT: A** \n\n**Paragraph:** \nOption **A** is the only viable path to ensure compliance with the declared-sourcing requirements while preserving data integrity and avoiding unproven assumptions. Preparing an **offline evidence-request manifest** for the **ACTUAL26 STRONG_CANDIDATE rows** explicitly enforces the need for **SKU-matched vendor-external quotes/invoices**, **unit/currency/date alignment**, and **evidence-backed discounts**\u2014all critical to validate cost mappings without relying on unverified metadata (e.g., `price_source/price_effective_date` or `Newmor live_price`). By **preserving candidate table/key/populated-column counts and key-match counts separately**, the process avoids conflating data completeness with cost reachability, which is explicitly disallowed. \n\nStructural/total validation of the **real artifact** and **malformed data** ensures no DB/API/source/cost-map edits are made, preserving the original state of the **cost-source-triage.json** and **historical totals26/12852/10704**. This aligns with the requirement to **block external cost evidence** until verified, preventing premature financial measurement/coverage lifts. While **B** (turning 10704 keymatched into verifiedcost) and **C** (leaving correction undone) may appear expedient, they risk unproven cost assertions or data stagnation. **A** ensures the **ticket remains blocked** until external evidence is formally submitted, maintaining governance and preventing gated adoption without rigorous validation. The **$0guard/env/Codexlocal** context further reinforces the need for artifact-only processing, avoiding any environmental dependencies. Thus, **A** is the only choice that satisfies all constraints: **no edits, no unproven metadata, and strict evidence requirements**.\n",
+ "codex.txt": "**VERDICT: A.** Independently read the generator and actual 26 rows; historical totals reconcile to **26 / 12,852 / 10,704**, generated `2026-09-16T21:22:26.640Z`. Prepare only the offline manifest, retaining source SHA-256 and every candidate table, key, populated-column count, and key-match count separately. The generator matches keys without requiring populated prices and swallows query errors; names and discount stamps prove neither priced-row reachability nor net cost. Flag `price_source`/`price_effective_date` as metadata-shaped and Newmor `live_price` as unproven. Require declared vendor/table provenance, SKU-matched vendor-external quote/invoice, unit, currency, effective date, and evidence-backed discount before mapping. Include structural/total validation and malformed-input rejection. No sends, DB/API/source/cost-map edits, fresh financial measurement, or coverage lift; preserve $0/env/Codex-local constraints. TK-11860 stays blocked pending external evidence and later gated adoption.",
+ "muse.txt": "[disabled \u2014 muse-glimmer removed 2026-08-31 per TK-10980; voter slot retired]\n",
+ "root": "VERDICT: A\nActual26-row evidence manifest is concrete safe prep; no cost assertion from shape or join.\n",
+ "ops": "VERDICT: A\n\nPrepare the offline evidence-request manifest from the report's literal 26 STRONG_CANDIDATE rows rather than the ticket's mixed illustrative vendor list, preserving source hash, timestamp and historical 26/12852/10704 totals. Keep populated-column counts and key-match counts separate: the generator's unrestricted key matching and swallowed query errors do not prove populated priced-row reachability, verified net acquisition cost, or a trustworthy coverage lift. Explicitly flag metadata-shaped price_source and price_effective_date columns and unproven derived live_price evidence; for every candidate require a SKU-matched vendor-external quote, invoice or authoritative price basis, dated unit/currency terms, and documented discount provenance where applicable. Structural and total-validation failures must stop generation rather than silently drop rows, while the resulting manifest prepares a precise sourcing request without querying live systems, sending messages, adopting prices, or closing the source ticket.\n\nGuard evidence: directly reread /Users/macstudio3/Projects/ticket-system/config/dtd-cost-mode = ZERO_COST_REQUIRED and printenv DTD_ZERO_COST = 1; canonical TK-11860 read. Own this vote file and required source log only. No other ballots, source edits or claims, DB/API calls, external messages, paid endpoints or Claude runtime. Spend $0. Correlation yf2139-i6-ops.\n",
+ "risk": "VERDICT: A\nPrepare the offline evidence-request manifest from the actual 26 STRONG_CANDIDATE rows because the ticket currently conflates matched keys, populated columns, and verified acquisition costs, and its example vendor list diverges from that artifact. Preserve source hash/generated_at and historical 26/12852/10704 totals, with candidate identity, key-match counts, and each populated-column count kept separate. Neither 10704 key matches nor column population proves their intersection, priced reachability, join uniqueness, or net-cost semantics; swallowed query errors further limit the report. Mark price_source and price_effective_date metadata-shaped rather than confirmed price values, leave Newmor live_price unproven, and require SKU-matched vendor-external evidence with unit, currency, effective date, price basis, and any evidence-backed discount before adoption. One example SKU can support an evidence request but cannot automatically validate every row or vendor-wide discount. B converts unverified matches into financial authority; C preserves a misleading readiness claim.\n\nGuard evidence: freshly read /Users/macstudio3/Projects/ticket-system/config/dtd-cost-mode as ZERO_COST_REQUIRED and printenv DTD_ZERO_COST as 1. Read increment6-question.txt and canonical TK-11860 with tk show. Full a2a-contract and dtd skills previously read in the same delegated session. No other ballots read. Provider spend $0; no Claude runtime, paid API, DB/API query, or external message.\nCorrelation: yf2139-i6-risk\nStatus: complete (independent decision vote only). Changed path: this artifact only; no source edit, claim, or commit. Residual risk: all financial semantics, current measurements, priced-row reachability, and vendor-wide applicability remain unverified. Remaining gates: external messaging and later cost-map/canonical/customer adoption. Safest next action: parent independently inspect vote and prepare structurally validated source-faithful requests; do not claim cost coverage or source completion, and retain the external-evidence dependency.\n"
+ },
+ "cost_usd": 0,
+ "operational_authority": false
+}
\ No newline at end of file
← d9979e62 Separate Phillipe Romano selling price from acquisition cost
·
back to Ticket System
·
Stage anchored Watchtower daemon count with negative boundar 89428d32 →