auto-data-snapshot: 2026-09-17T20:37:29 (2 data files) — evidence/TK-11860-w1838-20260917/findings.md evidence/TK-11860-w1838-20260917/prestate.json

49ef5a00fcdfdb279af8ca862e069481ec40313c · 2026-09-17 20:38:24 -0700 · auto-commit-fleet
Files touched

A evidence/TK-11860-w1838-20260917/findings.md
A evidence/TK-11860-w1838-20260917/prestate.json
Diff

commit 49ef5a00fcdfdb279af8ca862e069481ec40313c
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Thu Sep 17 20:38:24 2026 -0700

    auto-data-snapshot: 2026-09-17T20:37:29 (2 data files) — evidence/TK-11860-w1838-20260917/findings.md evidence/TK-11860-w1838-20260917/prestate.json
---
 evidence/TK-11860-w1838-20260917/findings.md   | 50 ++++++++++++++++++++++++++
 evidence/TK-11860-w1838-20260917/prestate.json | 28 +++++++++++++++
 2 files changed, 78 insertions(+)

diff --git a/evidence/TK-11860-w1838-20260917/findings.md b/evidence/TK-11860-w1838-20260917/findings.md
new file mode 100644
index 0000000..347eef4
--- /dev/null
+++ b/evidence/TK-11860-w1838-20260917/findings.md
@@ -0,0 +1,50 @@
+# 1838 Wallcoverings — VERIFY-THE-COLUMN verdict (TK-11860, lane 22, 2026-09-17)
+
+## Test applied (Knoll precedent)
+Does `w1838_catalog.price_retail` equal published × ~1.81 (RETAIL-AS-COST), published × 1.00
+(vendor list), or something else? Bonus: identify what maxwell_price/master_cost are.
+
+## External-plane findings (1838wallcoverings.com JSON-LD ProductGroup, fetched 2026-09-17 ~20:05-20:20 PDT; raw HTML archived)
+
+1838's own Shopify store publishes GBP prices:
+
+| SKU (mfr) | mirror price_retail | mirror maxwell_price | site GBP roll (JSON-LD) | retail/maxwell |
+|---|---|---|---|---|
+| 1601-103-01 Milton Silver | 207.69 | 135.00 | **£70.00** | 1.5385 (= 1/0.65 exact) |
+| 2210-165-03 Mineral Agate Blue | 215.38 | 140.00 | **£75.00** | 1.5385 (= 1/0.65 exact) |
+| 1907-138-03 Clarice Jet Black | 80.00 | 150.00 | **£80.00** | col = site GBP × 1.000 |
+
+## Classification: RETAIL-AS-COST (mixed-basis derived retail) — the column is NOT vendor cost
+
+- **299/332 rows**: `price_retail = maxwell_price / 0.65` EXACTLY (rounded to cents). 1/0.65 = 1.5385
+  is DW's OWN first markup step (DW retail pipeline = ×1/0.65 then ×1/0.85; 1/0.65 applied once, not
+  the full 1.81). The column holds a DERIVED DW-side value, not vendor data.
+- **22 rows**: `price_retail` = the vendor's own published GBP retail verbatim (70/80/90/104 —
+  Milton £70, Clarice £80 confirmed on-site). These look like raw Shopify-JSON scrape values.
+- **maxwell_price** = 0.9346 × master_cost on the same 299 rows (fixed ratio, 15 distinct values,
+  quarters+odd-cents shape = converted ERP data, NOT vendor list quarters).
+- **master_cost** looks like a converted cost basis (GBP trade × FX) but is NOT vendor-external
+  verifiable from the public site — vendor site shows only GBP retail; no public net/wholesale.
+- ⚠️ CURRENCY: the vendor site is GBP. All mirror numeric values (207.69/135/144.45) cannot be
+  USD vendor list without an FX/derivation step — none documented.
+
+## What this means
+The Knoll pattern REPEATS in a partial form: `price_retail` carries DW's own derived retail
+(= maxwell_price/0.65) on 90% of priced rows — a computed signature, exactly the shape TK-10302
+mistook for "raw cost" on Knoll. Treating this column as cost would understate cost by the markup.
+The underlying `maxwell_price` (15 distinct values, quarter-ish but odd-cents) is plausibly a
+Maxwell trade price converted at scrape — but WITHOUT a vendor-external Maxwell document, it stays
+NOT-MEASURED as true net cost (vendor_discount_pct NULL, discount_confirmed FALSE, TK-11669 class).
+
+## Consequence (measured, not touched)
+- Verify-price must NEVER read w1838_catalog.price_retail as cost for 1838 — it is DW-derived
+  retail (maxwell/0.65) or the vendor GBP retail (22 rows), in no case a net cost.
+- Candidate for a follow-up: verify `maxwell_price` against a Maxwell Fabrics trade document
+  (login-gated), then 1838 cost could flip to COST-CONFIRMED via that basis.
+- No cost-map entry added; mirror untouched.
+
+## Evidence files
+- external-plane/1838-Milton-Silver.html (roll £70.00 GBP JSON-LD; mirror price_retail 207.69 = 135/0.65)
+- external-plane/1838-Mineral-Agate-Blue.html (roll £75.00 GBP; mirror 215.38 = 140/0.65)
+- external-plane/1838-Clarice-Jet-Black.html (roll £80.00 GBP = mirror price_retail 80.00 verbatim)
+- prestate.json (mutation: NONE)
\ No newline at end of file
diff --git a/evidence/TK-11860-w1838-20260917/prestate.json b/evidence/TK-11860-w1838-20260917/prestate.json
new file mode 100644
index 0000000..99836e6
--- /dev/null
+++ b/evidence/TK-11860-w1838-20260917/prestate.json
@@ -0,0 +1,28 @@
+{
+  "captured_at": "2026-09-17T20:30:00-07:00",
+  "ticket": "TK-11860",
+  "lane": "sledgehammer lane 22 (batch retry)",
+  "vendor": "1838 Wallcoverings (1838wallcoverings.com, UK/GBP Shopify; US trade via Maxwell)",
+  "candidate": {
+    "table": "w1838_catalog",
+    "column": "price_retail (primary candidate per manifest; plus maxwell_price/master_cost/price_trade observed)",
+    "active_products_reported": 456,
+    "distinct_product_sku_key_matches_reported": 451,
+    "join_key": "ct.mfr_sku=sp.mfr_sku"
+  },
+  "prestate": {
+    "mirror_population": "404 rows total in table view; price_retail populated 404; maxwell_price populated 332; master_cost populated 332; price_trade populated 332; cost populated 0; last_scraped 2026-02-24..2026-03-14",
+    "key_relations_measured": {
+      "price_retail_vs_maxwell": "299/332 rows price_retail = maxwell_price/0.65 EXACTLY (DW first markup step 1/0.65 = 1.5385); 22 rows price_retail = vendor-site GBP roll price (70/80/90/104); 11 other",
+      "maxwell_vs_master_cost": "299/332 rows maxwell_price = master_cost x 0.9346 (fixed)"
+    },
+    "sampled_rows": [
+      {"mfr_sku": "1601-103-01", "pattern": "Milton Silver", "price_retail": 207.69, "maxwell_price": 135.00, "site_GBP_roll": 70.00},
+      {"mfr_sku": "2210-165-03", "pattern": "Mineral Agate Blue", "price_retail": 215.38, "maxwell_price": 140.00, "site_GBP_roll": 75.00},
+      {"mfr_sku": "1907-138-03", "pattern": "Clarice Jet Black", "price_retail": 80.00, "maxwell_price": 150.00, "site_GBP_roll": 80.00}
+    ],
+    "vendor_registry": {"vendor_discount_pct": null, "discount_confirmed": false, "pricing_unit": "yard", "pricing_model": "vendor_discount", "buy_from_notes": "Shopify site. JSON API + HTML scraping"}
+  },
+  "mutation": "NONE — read-only session. No writes to dw_unified, Shopify, GMC, or cost-map.",
+  "rollback": "Nothing to roll back."
+}
\ No newline at end of file
← 5ede52b auto-data-snapshot: 2026-09-17T20:05:20 (8 data files) — evi · back to Designerwallcoverings · auto-data-snapshot: 2026-09-17T21:10:25 (14 data files) — as 57f0447 →