dup-image scan (c47): clean — no wrong-image errors; all 27 shared-image groups are pattern variants

6c874fe12bd797fd3122b19372cc2966754f678f · 2026-06-16 17:55:55 -0700 · Steve Abrams

Read-only. ACTIVE products sharing exact primary image_url: 27 groups / 56 products.
Two-step skeptical decode caught the false positives: 20 are colorways (Babington
Check Indigo/Red/Green/Teal share Mulberry's one pattern photo), 7 are substrate
variants (Simpatico Paper/Print, Sporting Life/Velvet, Arioso Paper/Print). In every
case the shared photo is the CORRECT pattern across that pattern's color/material
variants (vendor one-photo limitation) — NOT a wrong-image copy-paste defect. Clean
PASS. First isolated-worktree commit.

Files touched

A scripts/dup-image-scan/dup-image-scan.sh

Diff

commit 6c874fe12bd797fd3122b19372cc2966754f678f
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Jun 16 17:55:55 2026 -0700

    dup-image scan (c47): clean — no wrong-image errors; all 27 shared-image groups are pattern variants
    
    Read-only. ACTIVE products sharing exact primary image_url: 27 groups / 56 products.
    Two-step skeptical decode caught the false positives: 20 are colorways (Babington
    Check Indigo/Red/Green/Teal share Mulberry's one pattern photo), 7 are substrate
    variants (Simpatico Paper/Print, Sporting Life/Velvet, Arioso Paper/Print). In every
    case the shared photo is the CORRECT pattern across that pattern's color/material
    variants (vendor one-photo limitation) — NOT a wrong-image copy-paste defect. Clean
    PASS. First isolated-worktree commit.
---
 scripts/dup-image-scan/dup-image-scan.sh | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/scripts/dup-image-scan/dup-image-scan.sh b/scripts/dup-image-scan/dup-image-scan.sh
new file mode 100755
index 0000000..55cbc9d
--- /dev/null
+++ b/scripts/dup-image-scan/dup-image-scan.sh
@@ -0,0 +1,22 @@
+#!/bin/sh
+# dup-image-scan (c47) — READ-ONLY. ACTIVE products sharing the EXACT same primary
+# image_url across distinct handles could be a wrong-image/copy-paste error (shopper
+# sees the wrong picture). VERDICT: clean — 27 shared-image groups / 56 products, but
+# ALL are same-PATTERN variants: 20 colorways (same pattern, diff color) + 7 substrate
+# variants (e.g. Simpatico Paper vs Print, Sporting Life vs Velvet). The shared photo
+# is the correct pattern image across that pattern's color/material variants (vendor
+# gave one photo/pattern) — NOT a wrong-image defect. $0 local mirror.
+PSQL=/opt/homebrew/opt/postgresql@14/bin/psql
+DB="postgresql:///dw_unified?host=/tmp"
+$PSQL "$DB" -c "
+with i as (select image_url, count(distinct handle) h,
+  count(distinct split_part(trim(title),' - ',1)) bp
+  from shopify_products where status='ACTIVE' and image_url<>'' group by image_url having count(distinct handle)>1)
+select count(*) shared_groups, sum(h) products,
+  count(*) filter (where bp=1) colorway_groups,
+  count(*) filter (where bp>1) cross_label_groups
+from i;"
+echo '-- cross-label groups (manually confirmed = substrate variants of same pattern, not wrong-image) --'
+$PSQL "$DB" -c "
+with i as (select image_url, count(distinct handle) h, count(distinct split_part(trim(title),' - ',1)) bp, string_agg(distinct split_part(trim(title),' - ',1),' | ') pats, string_agg(distinct vendor,',') v from shopify_products where status='ACTIVE' and image_url<>'' group by image_url having count(distinct handle)>1)
+select v vendor, left(pats,55) patterns from i where bp>1 order by h desc;"

← b5c27d7 isolate read-only yolo loop on its own worktree branch (yolo · back to Dw Yolo Loop · orphan-products scan (c49): PASS — 0 un-navigable products o 91e962c →