pending-approval: draft live Coastal Mist oil-filter image fix (DTD-A)

3b51069d0e505d5c21010bc9110d75bdd1f6dd70 · 2026-06-24 07:38:10 -0700 · Steve
Files touched

A pending-approval/coastal-mist-oil-filter-image-fix.md
Diff

commit 3b51069d0e505d5c21010bc9110d75bdd1f6dd70
Author: Steve <steve@designerwallcoverings.com>
Date:   Wed Jun 24 07:38:10 2026 -0700

    pending-approval: draft live Coastal Mist oil-filter image fix (DTD-A)
---
 .../coastal-mist-oil-filter-image-fix.md           | 32 ++++++++++++++++++++++
 1 file changed, 32 insertions(+)

diff --git a/pending-approval/coastal-mist-oil-filter-image-fix.md b/pending-approval/coastal-mist-oil-filter-image-fix.md
new file mode 100644
index 00000000..143c16cd
--- /dev/null
+++ b/pending-approval/coastal-mist-oil-filter-image-fix.md
@@ -0,0 +1,32 @@
+# PENDING APPROVAL — Live Shopify fix: "Portofino Bamboo - Coastal Mist" wrong image + bad color tag
+
+**Status:** awaiting Steve sign-off (customer-facing prod write — NOT executed by agent)
+**Drafted:** 2026-06-24
+**Decision basis:** DTD verdict A (3/3 unanimous — Claude/Codex/Qwen)
+
+## What's wrong (live, customer-facing)
+Product on designerwallcoverings.com:
+- **handle:** `bamboo-wallcovering-coastal-mist-wallcovering-phillipe-romano`
+- **SKU:** DWPW-430065 · vendor Phillipe Romano
+
+Defects on the live product:
+1. **Wrong image** — `cdn.shopify.com/.../files/B7469-2_bddd78c0-...jpg` is a **Baldwin B7469 automotive oil filter** photo (from a "Filters Plus" listing), not a wallcovering. Verified by downloading + viewing the asset.
+2. **Bad color facet** — product carries a `Red` tag (and the demo dataset derived `colorBucket:Red / #b23b3b`) sourced from the oil filter's red can. The correct tone is **Smoke** (the product already also carries `color:Smoke`). "Coastal Mist" reads as soft grey/blue.
+3. Product is already tagged **`Needs-Image`** — i.e. **no genuine Coastal Mist photo exists anywhere** in the catalog or on the live store (its 2 image slots both point at the filter).
+
+Root cause: importer attached an unrelated CDN file to satisfy a non-null image field; a dominant-color step then mis-read the filter's red can → `Red`. Blast radius confirmed = this one SKU.
+
+## Proposed live correction (for Steve to execute)
+1. **Remove** the B7469 oil-filter image from the product (both image references).
+2. **Remove** the erroneous `Red` tag; keep `color:Smoke`.
+3. **Keep** `Needs-Image` set until a real photo lands.
+4. **Source a genuine "Portofino Bamboo – Coastal Mist" (Smoke) photo** — the actual smoke/grey bamboo grasscloth texture — then attach + clear `Needs-Image`. Do NOT substitute a different colorway as if it were real.
+
+⚠️ Do not auto-publish a guessed/substituted image to the live product (activation-gate + no-fabrication rules).
+
+## Already done (non-gated, no approval needed)
+- **dw-discovery demo** (`~/Projects/dw-discovery`, commit `9ba8fa6`): repointed `index.html` from the broken seed `products.json` to the clean real adapter output (`products.real.json` + `config.real.json`). Oil filter gone; color buckets sane (Blue 42 / Neutral 54 / Grey 16 / Green 16 / Brown 15 / Black 6). Refresh `http://127.0.0.1:8771/index.html`.
+- **philipperomano local data** (`~/Projects/philipperomano/data/products.json`): swapped the oil-filter URL for a **real Portofino Bamboo line texture (`BA-346.jpg`) as an explicit interim stand-in** so the storefront won't show a filter on a future deploy. This is interim — replace with the genuine Coastal Mist photo per step 4 above. No deploy performed.
+
+## Related (separate, larger — flag only)
+The dw-discovery **seed** `data/products.json` had **~2,960 / 3,128 (94%) products mis-bucketed `Red`** by the same dominant-color step. It's now unused by the page (repointed away), so no action is forced — but if that seed is ever reused, the color derivation needs the keyword-based `build-data.py` approach, not dominant-pixel. Surfacing for awareness; no mass rewrite done.
← 9ca4e85a VCC: fix DB fallback connection string (dw_admin@127.0.0.1, · back to Designer Wallcoverings · pending-approval: found genuine BA469 image + ready-to-run l b91d293d →