← back to Ticket System
TK-10002 Phase-2b: same-vendor merge plan (3 true dupes to archive, 32 false collisions to re-SKU) — read-only, gated
af440a28057205f6b228da9ee7fdab319301473d · 2026-07-28 16:28:34 -0700 · Steve Abrams
Files touched
A tk10002-phase2b/PLAN.mdA tk10002-phase2b/collision-dump.psvA tk10002-phase2b/false-collisions.mdA tk10002-phase2b/false-collisions.tsvA tk10002-phase2b/verify-truedupes.js
Diff
commit af440a28057205f6b228da9ee7fdab319301473d
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Tue Jul 28 16:28:34 2026 -0700
TK-10002 Phase-2b: same-vendor merge plan (3 true dupes to archive, 32 false collisions to re-SKU) — read-only, gated
---
tk10002-phase2b/PLAN.md | 231 +++++++++++++++++++++++++++++++++++
tk10002-phase2b/collision-dump.psv | 71 +++++++++++
tk10002-phase2b/false-collisions.md | 32 +++++
tk10002-phase2b/false-collisions.tsv | 32 +++++
tk10002-phase2b/verify-truedupes.js | 37 ++++++
5 files changed, 403 insertions(+)
diff --git a/tk10002-phase2b/PLAN.md b/tk10002-phase2b/PLAN.md
new file mode 100644
index 00000000..0887514c
--- /dev/null
+++ b/tk10002-phase2b/PLAN.md
@@ -0,0 +1,231 @@
+# TK-10002 Phase-2b — same_vendor_dupe_MERGE Plan (READ-ONLY, ruling-ready)
+
+**Ticket:** TK-10002-dw-duplicate-active-products-hunt-yolo · **Agent:** vp-dw-commerce · **Date:** 2026-07-28
+**Store:** `designer-laboratory-sandbox.myshopify.com` (LIVE prod DW store) · API `2024-10`
+**Guard baseline:** `skuTakenOnActiveProduct` hardened at commit `de4cd0e3` (fail-closed + case-fold, both lib copies).
+**Cost:** `$0 (local)` — all PG-mirror reads + git + read-only Shopify GraphQL (no metered/paid-model calls).
+**Authorization status:** NOTHING WRITTEN. This is a plan only. Every write below stays gated for Steve.
+
+---
+
+## TL;DR — what the write pass WOULD do (one paragraph)
+
+The `same_vendor_dupe_MERGE` class is **35 collision groups** (34 two-product + one three-product), all
+same-vendor, sharing a `variant_sku` across ≥2 ACTIVE products. On workup, **only 3 of the 35 are genuine
+same-product duplicates** — identical title, identical `dw_sku`, one a re-import of the other. Those 3
+(`DIG-740017`, `DWC-Arte-40323-Sample`, `DWK-30522`) are clean AUTO-MERGE recommends: keep the older,
+ARCHIVE the newer twin, add a `from→to` handle redirect. **The other 32 are NOT duplicates** — they are
+distinct patterns (different `dw_sku` roots and/or different titles/colorways) that share a **malformed
+`variant_sku` string** produced by a bad DW-Bespoke / MTG / MIS / PR sample-SKU templating bug (the Sample
+variant SKU was not uniquified per product). Archiving a member of any of those 32 would **destroy a real,
+distinct, live product** — so they are all marked **REVIEW**, and the correct remedy is a scoped
+**re-SKU** (uniquify the colliding variant SKU per product), NOT a merge/archive. So the mechanical write
+pass = **3 archives + 3 redirects**, plus a follow-up REVIEW project to re-SKU the 32 false-collision groups.
+
+**Approve options for Steve:** (A) approve the 3 AUTO-MERGE archives+redirects only; (B) approve A and
+authorize the 32-group re-SKU follow-up as a separate scoped task; (C) line-item — approve/hold each of
+the 3 individually (they're listed with per-group detail below).
+
+---
+
+## Classification method (deterministic, reproducible)
+
+For each collision group (ACTIVE-only, `variant_sku` not null and not `^null`, `count>1`):
+- `distinct_dwsku` = # distinct normalized `dw_sku` values across members
+- `distinct_title` = # distinct normalized titles across members
+
+| distinct_title | distinct_dwsku | meaning | disposition |
+|---|---|---|---|
+| **1** | **1** | same product imported twice (true dupe) | **AUTO-MERGE** (survivor + archive + redirect) |
+| 2 | 1 | same dw_sku but different pattern/colorway/title | **REVIEW** (re-SKU; ambiguous which is canonical) |
+| 2 | 2+ | clearly distinct products sharing a bad sample variant_sku | **REVIEW** (re-SKU the colliding variant; never archive) |
+
+Reproduce query (used to build this plan; `upper(status)='ACTIVE'` — mirror stores status MIXED-CASE):
+```sql
+with grp as (
+ select variant_sku from shopify_products
+ where upper(status)='ACTIVE' and variant_sku is not null and variant_sku !~* '^null'
+ group by variant_sku having count(*)>1)
+select p.variant_sku,
+ count(distinct lower(regexp_replace(coalesce(dw_sku,''),'[^a-z0-9]','','gi'))) distinct_dwsku,
+ count(distinct lower(regexp_replace(coalesce(title,''),'[^a-z0-9]','','gi'))) distinct_title
+from shopify_products p join grp g using(variant_sku)
+where upper(p.status)='ACTIVE' group by p.variant_sku;
+```
+
+**Result:** 3 groups `distinct_title=1` (AUTO-MERGE) · 32 groups REVIEW. Includes the 2 case-fold
+collisions from Phase-2a: `DWC-Arte-40323-Sample` (turns out a TRUE dupe → AUTO-MERGE) and `DWK-30522`
+(TRUE dupe → AUTO-MERGE). The Koroseal quote-only grandfather does NOT exempt an exact-title dupe.
+
+---
+
+## SECTION 1 — AUTO-MERGE (3 groups) — clean recommends, live-verified
+
+All 3 verified ACTIVE-ACTIVE on the LIVE store this session (read-only GraphQL). Survivor rule applied:
+**real SKU (both have it) → image (both have it) → OLDER `created_at` wins** (older = original import;
+newer = the re-import dupe). Tie-breaker used = **older created_at** in every case.
+
+### 1a. `DIG-740017` — DW Bespoke Studio — "Happy Days Revivial 1970's"
+| role | product id | handle | created | img | variants (live) |
+|---|---|---|---|---|---|
+| **SURVIVOR** | `6900076249139` | `happy-days-revivial-authentic-1970s-reproduction-vintage-wallcoverings` | 2023-03-13 | Y | `DIG-740017-SAMPLE`$4.25, `DIG-740017`$199.00 |
+| **ARCHIVE** | `7582541578291` | `happy-days-revivial-authentic-1970s-reproduction-vintage-**wallpapers**` | 2025-05-09 | Y | `DIG-740017-SAMPLE`$4.25, `DIG-740017`$199.00 |
+- Tie-breaker: older created_at. Extra signal: the archive twin's handle uses the **BANNED word "wallpapers"** — reinforces archiving it.
+- Redirect: `/products/happy-days-revivial-authentic-1970s-reproduction-vintage-wallpapers` → `/products/happy-days-revivial-authentic-1970s-reproduction-vintage-wallcoverings`
+- FM order-ref exposure: **0 in local caches** (see FM section); confirm via FM MCP at apply-time.
+- Risk: **LOW** — clean same-product dupe, identical price/variants.
+
+### 1b. `DWC-Arte-40323-Sample` — Arte International — "Fringe Double Jute Contemporary Wallcovering"
+| role | product id | handle | created | img | variants (live) |
+|---|---|---|---|---|---|
+| **SURVIVOR** | `4348475899955` | `fringe-double-jute-contemporary-wallpaper-5` | 2019-11-15 06:43:17 | Y | `DWC-Arte-40323`$4.25, `DWC-Arte-40323-Sample`$4.25 |
+| **ARCHIVE** | `4348476653619` | `fringe-double-jute-contemporary-wallpaper-6` | 2019-11-15 06:43:42 | Y | `DWC-Arte-40323`$4.25, `DWC-Arte-40323-Sample`$4.25 |
+- Tie-breaker: older created_at (25s earlier). Both identical title + dw_sku `DWC-Arte-40323`.
+- Redirect: `/products/fringe-double-jute-contemporary-wallpaper-6` → `/products/fringe-double-jute-contemporary-wallpaper-5`
+- **DATA-DEFECT NOTE (do not fix in this pass):** the survivor's ROLL variant (`DWC-Arte-40323`) is priced at the **$4.25 sample price**, not a real roll price — a below-cost/GMC risk that the survivor still carries. Flag to a separate Arte pricing fix; NOT a merge action.
+- FM order-ref exposure: **0 in local caches**; confirm via FM MCP.
+- Risk: **LOW** for the merge itself; survivor pricing defect noted separately.
+
+### 1c. `DWK-30522` — Koroseal — "Happenstance Curiosity - Steel Blue Commercial Wallcovering"
+| role | product id | handle | created | img | variants (live) |
+|---|---|---|---|---|---|
+| **SURVIVOR** | `7584916308019` | `dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-**amethyst**` | 2025-05-14 | Y | `DWK-30522`$4.25 (quote-only, single variant) |
+| **ARCHIVE** | `7632318464051` | `dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-**curiosity**` | 2025-07-08 | Y | `DWK-30522`$4.25 (quote-only, single variant) |
+- Tie-breaker: older created_at. Both identical title, dw_sku `DWK-30522`, mfr `HP21-08`. Koroseal quote-only ($4.25 sample-only) is grandfathered — but the dupe is still a clean archive.
+- Handle wrinkle: survivor handle slug ends `happenstance-amethyst` while title says "Steel Blue"; the archive slug ends `happenstance-curiosity` and matches the title word better. **Survivor choice stands on created_at**, but if Steve prefers the title-matching slug, this is the one line-item to flip (still archive one, keep one). Marked here so it's a conscious choice, not silent.
+- Redirect: `/products/dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-curiosity` → `/products/dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-amethyst`
+- FM order-ref exposure: **0 in local caches**; confirm via FM MCP.
+- Risk: **LOW-MEDIUM** — merge is clean; the only judgment call is which slug to keep (see wrinkle). Safe to auto-recommend on created_at; flip only if Steve says so.
+
+**AUTO-MERGE summary: 3 clean recommends. 0 groups where BOTH members carry a detectable open order. 0 genuinely-ambiguous survivor picks (1c has a cosmetic slug-preference note only).**
+
+---
+
+## SECTION 2 — REVIEW (32 groups) — FALSE COLLISIONS, do NOT archive
+
+These are **distinct live products** that collide only on a malformed shared `variant_sku`. Archiving a
+member destroys a real product. Remedy = **re-SKU** (uniquify the colliding variant SKU per product), which
+is a separate scoped task — NOT part of the merge/archive apply. Listed for completeness so Steve can
+approve the follow-up in the same batch. `dw` = each member's real distinct `dw_sku`.
+
+| colliding variant_sku | vendor | members (id · dw_sku · title) |
+|---|---|---|
+| `AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange` | DW Bespoke Studio | 7675395145779 · dw=AIDIG-4350142-25_Flame... · Piermont 1940's Retro<br>7675395178547 · dw=AIDIG-4350142-25_Flame... · Piermont 1940's **Cody** Retro |
+| `Dig-1100-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664512794675 · dw=DIG-1952-... · Classic Cherries Jubilee<br>7664512827443 · dw=Vin-1100-... · Classic green floral vintage |
+| `Dig-171053-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664490512435 · dw=DIG-171053-... · Charlotte's 1910's blush pink<br>7664490545203 · dw=DIG-171052-... · Charlotte's 1910's black & blush |
+| `DIG-2400069-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664493068339 · dw=Dig-2400069-... · Ethereal Dreamy White Clouds<br>7664493101107 · dw=Dig-2400069-... · Hand-Drawn White and Green Stripes |
+| `Dig-2400089-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664462233651 · dw=DIG-2400089-... · Blushed Marble Mural<br>7664462364723 · dw=DIG-2400085-... · Blush Tide Mural |
+| `DIG-2400093` | DW Bespoke Studio | 7589565300787 · dw=DIG-2400093-SAMPLE · Playform Mural<br>7589588402227 · dw=DIG-2400093-SAMPLE · Watercolor Dots Mural |
+| `Dig-240407-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664493002803 · dw=DIG-2400065-... · Minimalist Simple Leaves<br>7664584884275 · dw=DIG-74118-... · Fairfield Happy Days 1970's |
+| `Dig-240416-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664512237619 · dw=DIG-68000-... · Boudoir Ladies Pink<br>7664512663603 · dw=DIG-98621-... · Cello Damask Sepia Beige |
+| `Dig-240417-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664489529395 · dw=Dig-240416-Sample25-... · Calm Elegance Watercolor<br>7774188404787 · dw=Dig-240416-Sample25-... · Nocturnal Anthurium |
+| `Dig-240420` | DW Bespoke Studio | 7502400847923 · dw=Dig-240420 · Golden Peaks Majestic Mural<br>7502401634355 · dw=Dig-240420 · Lavender Mist Peaks Mural |
+| `DIG-240434-vinyl-2x1-sample` (n=3) | DW Bespoke Studio | 7663707619379 · dw=DIG-240434-peel-sample- · Rosé Luxe Mural<br>7663711354931 · dw=DIG-240434-peel-Sample- · Soft Nude Gradient Mural<br>7663711682611 · dw=DIG-240434-peel-Sample- · Watercolor Dots Mural |
+| `Dig-25-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664513646643 · dw=DIG_10082002-... · Deep Reef Mural<br>7664586686515 · dw=DIG-439241 Sample-... · Thug Stripe Cream Gun |
+| `DIG-320255-mural` | DW Bespoke Studio | 7547203026995 · dw=DIG-320255 · Royal Lady Frames Gold Mural Pop Art<br>7548957392947 · dw=DIG-320256 · Royal Lady Frames Gold Mural Half Drop |
+| `Dig-40021-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664512073779 · dw=DIG-40021-... · Bottles by Jordan Carlyle<br>7664512434227 · dw=DIG-85335-... · Cello Damask Charcoal Grey |
+| `DIG-4350959-Periwinkle - Sample` | DW Bespoke Studio | 6707947208755 · dw=DIG-4350959-Periwinkle - Sample · Cici's Periwinkle Traditional<br>7801847447603 · dw=∅ · Cici's Periwinkle Wallcovering |
+| `DIG-5531287-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664593338419 · dw=Dig-5531287-... · Wanda's Wandering Wisteria (5)<br>7664593371187 · dw=Dig-5531287-... · Wanda's Wandering Wisteria (4) |
+| `DIG-553801-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664593633331 · dw=Dig-553801-... · Rosie's Roses Authentic Vintage 1950's<br>7664629514291 · dw=Dig-553801-... · Rosie's Roses 1950's |
+| `DIG-762124-Sample-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664598614067 · dw=Dig-762124-... · Gregorious Gulls Yellow Coastal<br>7664616800307 · dw=Dig-762124-... · Zepellin Zebras Yellow |
+| `Dig-770064-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664638427187 · dw=Dig-770064-... · Hanover 1970's Geometric<br>7664638459955 · dw=Dig-770064-... · Bailey Bottles of Booze 1970's |
+| `Dig-7700743-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664488218675 · dw=Dig-240426-Sample-... · Cranes in the Cherry Blossom Lake<br>7664586915891 · dw=Dig-7700743-... · Geomino 1970's Geometric |
+| `Dig-770089-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664584851507 · dw=DIG-740108-... · Fitzwilliam 1970's Pop Art<br>7664636100659 · dw=DIG-435086-... · Willington 1940's Branches Chinoiserie |
+| `DIG-977081-Sample-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664592814131 · dw=Dig-977081-... · Riley's Rainbow Of Retro<br>7664592846899 · dw=Dig-977081-... · Fremont 1970S Fern |
+| `MTG-403024-Sample` | Mind the Gap | 4469009481779 · dw=MTG-403024 · Apodyterium Beige<br>4469009514547 · dw=MTG-403024 · Apodyterium Taupe Beige |
+| `MTG-403235-Sample` | Mind the Gap | 4469013381171 · dw=MTG-403235 · Exotic Fruit 2<br>4469049786419 · dw=MTG-403235 · Eyes and Circles Blue |
+| `MTG-403490-Sample` | Mind the Gap | 4469053718579 · dw=MTG-403490 · Neon Kiss White<br>4469053751347 · dw=MTG-403490 · Newton Geometry taupe |
+| `MTG-403723-Sample` | Mind the Gap | 4469024948275 · dw=MTG-403723 · Water Lilies White<br>4469057945651 · dw=MTG-403723 · Wilderness Beige |
+| `MIS-18313` | Missoni Wallpaper | 6751726698547 · dw=MIS-18313 · Magic Garden Blue/Green/Multi<br>6751727386675 · dw=MIS-18313 · Magic Garden Cream |
+| `MIS-18366W1` | Missoni Wallpaper | 6751729385523 · dw=MIS-18366W1 · Chevronette Pearl<br>6751729549363 · dw=MIS-118366W1 · Chevronette White |
+| `MIS-18398` | Missoni Wallpaper | 6753061896243 · dw=MIS-18398 · Iconic Shades Ombre Taupe<br>6753081589811 · dw=MIS-18398 · Striped Sunset Brown/Multi |
+| `PRW-65002-Sample` | Phillipe Romano | 7478729867315 · dw=PRW-65002 · Pietro Real Wood Veneer Cedar<br>7862994960435 · dw=∅ · Pietro Real Wood Veneer Cedar **Memo Sample** |
+| `PRW-65003-Sample` | Phillipe Romano | 7478729932851 · dw=PRW-65003 · Pietro Real Wood Veneer Natural<br>7862995419187 · dw=∅ · Pietro Real Wood Veneer Natural **Memo Sample** |
+| `PRW-65016-Sample` | Phillipe Romano | 7478730096691 · dw=PRW-65016 · Pietro Real Wood Veneer<br>7862995976243 · dw=∅ · Pietro Real Wood Veneer **Memo Sample** |
+
+### REVIEW sub-notes
+- **The 3 `PRW-650xx-Sample` groups** are a different pattern than the rest: the second member is a
+ `Memo Sample` twin (created 2026-06-16, `dw_sku` NULL) shadowing the real per-yard product. These belong
+ to the **deferred 112-null-Sample PR merge project**, not a re-SKU — route them there, don't fold into the
+ re-SKU task.
+- **`DIG-2400093`, `Dig-240420`, `DIG-2400069`, `DIG-5531287`, `Dig-770064`, `DIG-553801`, `DIG-977081`,
+ `MTG-403024/403235/403490/403723`, `MIS-18313/18398`, `AIDIG-4350142`** — same `dw_sku` on both members
+ but genuinely different colorway/pattern titles. This means the underlying `dw_sku` itself is duplicated
+ upstream, not just the variant SKU — a deeper Bespoke/MTG/MIS numbering bug. Re-SKU must assign a NEW
+ unique dw_sku to one member (color-suffix), which is exactly why this is REVIEW not auto — the "which
+ keeps the base number" call is per-group and needs Steve/DW-SKU-analyst judgment.
+- **`MIS-18366W1`** already has distinct dw_skus (`MIS-18366W1` vs `MIS-118366W1`) — the collision is only
+ on the shared `variant_sku` string; a straightforward variant re-SKU fixes it.
+- **`DIG-320255-mural`** dw_skus already distinct (`DIG-320255` vs `DIG-320256`); variant re-SKU fixes it.
+
+---
+
+## SECTION 3 — Redirects the write pass WOULD create (Shopify `redirects` API — NOT auto-301)
+
+Only the 3 AUTO-MERGE archives need a redirect. `from → to`:
+
+1. `/products/happy-days-revivial-authentic-1970s-reproduction-vintage-wallpapers` → `/products/happy-days-revivial-authentic-1970s-reproduction-vintage-wallcoverings`
+2. `/products/fringe-double-jute-contemporary-wallpaper-6` → `/products/fringe-double-jute-contemporary-wallpaper-5`
+3. `/products/dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-curiosity` → `/products/dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-amethyst`
+
+(No redirects for the 32 REVIEW groups — nothing is being archived there.)
+
+---
+
+## SECTION 4 — FileMaker order-ref exposure (READ-ONLY finding)
+
+**Authoritative open/sample-order lines live in FileMaker, not the mirror.** A FileMaker MCP is configured
+in `~/.claude.json` (`filemaker` / `filemaker-cloud` / `filemaker-mcp`) but its tools were not exposed to
+this read-only scoping agent, so the definitive per-SKU open-order check MUST be run at apply-time via the
+FM MCP (or the live Shopify Orders API). What WAS checked locally, read-only:
+
+- `dw_unified.digital_sample_orders` (25 live sample orders): grepped for `MTG-403*`, `MIS-18*`,
+ `DWK-305*`, `Arte-40323`, `PRW-650*`, `DIG-3202*` → **0 matches**. All 25 are DWSS/WPBOOK samples.
+- `dw_unified.mp_order_items` (6 rows, keyed by `pattern_id` not SKU) → no SKU linkage, none of ours.
+- `dw_unified.filemaker_wallpaper` (136,727 catalog rows) carries the `is_discontinued`/`date_discontinued`
+ master flags but **no order-lines table** — cannot confirm open orders from it. For the 3 AUTO-MERGE
+ archive candidates, none are flagged discontinued.
+
+**FM exposure verdict per AUTO-MERGE group: 0 in all local caches; UNVERIFIED against live FM.**
+| group | archive-candidate SKU(s) | local-cache exposure | apply-time action |
+|---|---|---|---|
+| DIG-740017 | `DIG-740017`, `DIG-740017-SAMPLE` (id 7582541578291) | 0 | FM MCP: `find` open+sample orders on those SKUs before archiving; if hit → re-point line to survivor `6900076249139` first |
+| DWC-Arte-40323 | `DWC-Arte-40323`, `DWC-Arte-40323-Sample` (id 4348476653619) | 0 | same |
+| DWK-30522 | `DWK-30522` (id 7632318464051) | 0 | same |
+
+Because both twins in each AUTO-MERGE group carry the **same** variant SKUs, any FM order line points to the
+SKU (not a specific product id) — so archiving the twin does not orphan an order line at all (the SKU still
+resolves via the survivor). Exposure risk is therefore **structurally low**; the FM check is a
+belt-and-suspenders confirmation, not a blocker.
+
+---
+
+## SECTION 5 — Exact operations the apply pass WOULD fire (mechanical)
+
+Nothing below has run. Ordered, PostgreSQL-BEFORE-Shopify per standing rule, ≥90s between any bulk batches
+(N=3 here so a single small batch). Discontinued=ARCHIVE (never draft/delete) — these are dupes, archive is correct.
+
+**Per AUTO-MERGE group (×3):**
+1. **FM MCP (read):** confirm no open/sample order line uniquely tied to the archive-candidate product id.
+2. **Mirror (write, local):** `UPDATE shopify_products SET status='ARCHIVED', synced_at=now() WHERE shopify_id=<archive gid>;` (source-of-truth first; re-syncs from Shopify after).
+3. **Shopify (write, authoritative):** `productUpdate(input:{id:<archive gid>, status:ARCHIVED})` via API 2024-10.
+4. **Shopify (write):** `urlRedirectCreate(urlRedirect:{path:<archive handle path>, target:<survivor handle path>})`.
+5. Log to ticket + audit JSON.
+
+Archive gids: `7582541578291` · `4348476653619` · `7632318464051`.
+Survivor gids (untouched): `6900076249139` · `4348475899955` · `7584916308019`.
+
+**Follow-up REVIEW task (separate approval, NOT this apply):** re-SKU the 32 false-collision groups —
+route the 3 `PRW-650xx-Sample` to the null-Sample PR merge project; for the remaining 29, assign a unique
+`variant_sku` (and, where dw_sku is also duplicated, a color-suffixed unique `dw_sku`) per member. This is a
+DW-SKU-analyst judgment task; do NOT archive any member.
+
+---
+
+## Data artifacts (git-tracked, this dir)
+- `collision-dump.psv` — full per-product dump of all 71 colliding ACTIVE products.
+- `false-collisions.tsv` / `false-collisions.md` — the 32 REVIEW groups.
+- `verify-truedupes.js` — the read-only live-Shopify verifier for the 3 AUTO-MERGE groups.
+
+## Cost
+`$0 (local)` — PG mirror reads, git, read-only Shopify GraphQL. No paid-model / metered calls.
diff --git a/tk10002-phase2b/collision-dump.psv b/tk10002-phase2b/collision-dump.psv
new file mode 100644
index 00000000..c4a560c6
--- /dev/null
+++ b/tk10002-phase2b/collision-dump.psv
@@ -0,0 +1,71 @@
+AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange|gid://shopify/Product/7675395145779|Piermont 1940's Retro | Architectural Wallcoverings|piermont-1940s-wallpaper-dw-bespoke-studios-flame-scarlet-orange-autumn-glaze-orange|ACTIVE|AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange|AIDIG-4350142-25_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange|PIERMONT-1940S-WALLPAPER-DW-BESPOKE-STUDIOS-FLAME-SCARLET-ORANGE-AUTUMN-GLAZE-ORANGE|DW Bespoke Studio|2025-09-25 03:42:37|Y|40|true|true|0
+AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange|gid://shopify/Product/7675395178547|Piermont 1940's Cody Retro | Architectural Wallcoverings|piermont-1940s-wallpaper-dw-bespoke-studios-flame-scarlet-orange-autumn-glaze-orange-1|ACTIVE|AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange|AIDIG-4350142-25_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange|PIERMONT-1940S-WALLPAPER-DW-BESPOKE-STUDIOS-FLAME-SCARLET-ORANGE-AUTUMN-GLAZE-ORANGE-1|DW Bespoke Studio|2025-09-25 03:42:41|Y|40|true|true|0
+Dig-1100-25-type-2-vinyl-Sample|gid://shopify/Product/7664512794675|Classic Cherries Jubilee - Red Green White Contemporary | Architectural Wallcoverings|classic-cherries-jubilee-red-green-white-pattern-design-lab-dig-1952-1|ACTIVE|Dig-1100-25-type-2-vinyl-Sample|DIG-1952-25-type-2-vinyl-2x12|CLASSIC-CHERRIES-JUBILEE-RED-GREEN-WHITE-PATTERN-DESIGN-LAB-DIG-1952-1|DW Bespoke Studio|2025-09-02 23:30:08|Y|16|true|true|0
+Dig-1100-25-type-2-vinyl-Sample|gid://shopify/Product/7664512827443|Classic green floral vintage wallcovering Victorian | Architectural Wallcoverings|classic-green-floral-vintage-wallcovering-vin-1100-1|ACTIVE|Dig-1100-25-type-2-vinyl-Sample|Vin-1100-25-type-2-vinyl-2x12|CLASSIC-GREEN-FLORAL-VINTAGE-WALLCOVERING-VIN-1100-1|DW Bespoke Studio|2025-09-02 23:30:17|Y|16|true|true|0
+Dig-171053-25-type-2-vinyl-Sample|gid://shopify/Product/7664490512435|Charlotte's Authentic Vintage 1910's Reproduction blush pink Traditional | Architectural Wallcoverings|charlottes-authentic-vintage-1910s-reproduction-wallpapers-blush-pink-1|ACTIVE|Dig-171053-25-type-2-vinyl-Sample|DIG-171053-25-type-2-vinyl-2x12|CHARLOTTES-AUTHENTIC-VINTAGE-1910S-REPRODUCTION-WALLPAPERS-BLUSH-PINK-1|DW Bespoke Studio|2025-09-02 22:26:30|Y|16|true|true|0
+Dig-171053-25-type-2-vinyl-Sample|gid://shopify/Product/7664490545203|Charlotte's Authentic Vintage 1910's Reproduction black & blush pink Victorian | Architectural Wallcoverings|charlottes-authentic-vintage-1910s-reproduction-wallpapers-black-blush-pink-1|ACTIVE|Dig-171053-25-type-2-vinyl-Sample|DIG-171052-25-type-2-vinyl-2x12|CHARLOTTES-AUTHENTIC-VINTAGE-1910S-REPRODUCTION-WALLPAPERS-BLACK-BLUSH-PINK-1|DW Bespoke Studio|2025-09-02 22:26:34|Y|16|true|true|0
+DIG-2400069-25-type-2-vinyl-2x27|gid://shopify/Product/7664493068339|Ethereal Dreamy White Clouds Contemporary | Architectural Wallcoverings|hand-drawn-white-and-green-stripes-wallpaper-copia-1|ACTIVE|DIG-2400069-25-type-2-vinyl-2x27|Dig-2400069-25-type-2-vinyl|HAND-DRAWN-WHITE-AND-GREEN-STRIPES-WALLPAPER-COPIA-1|DW Bespoke Studio|2025-09-02 22:29:51|Y|16|true|true|0
+DIG-2400069-25-type-2-vinyl-2x27|gid://shopify/Product/7664493101107|Hand-Drawn White and Green Stripes Contemporary | Architectural Wallcoverings|hand-drawn-white-and-green-stripes-wallpaper-1|ACTIVE|DIG-2400069-25-type-2-vinyl-2x27|Dig-2400069-25-type-2-vinyl|HAND-DRAWN-WHITE-AND-GREEN-STRIPES-WALLPAPER-1|DW Bespoke Studio|2025-09-02 22:29:58|Y|16|true|true|0
+Dig-2400089-25-type-2-vinyl-Sample|gid://shopify/Product/7664462233651|Blushed Marble Mural Contemporary | Architectural Wallcoverings|blushed-marble-adrian-1|ACTIVE|Dig-2400089-25-type-2-vinyl-Sample|DIG-2400089-25-type-2-vinyl-2x12|BLUSHED-MARBLE-ADRIAN-1|DW Bespoke Studio|2025-09-02 20:44:09|Y|16|true|true|0
+Dig-2400089-25-type-2-vinyl-Sample|gid://shopify/Product/7664462364723|Blush Tide Mural Contemporary | Architectural Wallcoverings|blush-tide-adrian-1|ACTIVE|Dig-2400089-25-type-2-vinyl-Sample|DIG-2400085-25-type-2-vinyl-2x12|BLUSH-TIDE-ADRIAN-1|DW Bespoke Studio|2025-09-02 20:44:31|Y|16|true|true|0
+DIG-2400093|gid://shopify/Product/7589565300787|Playform Mural Contemporary | Architectural Wallcoverings|playform-adrian|ACTIVE|DIG-2400093|DIG-2400093-SAMPLE|PLAYFORM-ADRIAN|DW Bespoke Studio|2025-05-22 13:31:17|Y|2|true|true|0
+DIG-2400093|gid://shopify/Product/7589588402227|Watercolor Dots Mural Scandinavian | Architectural Wallcoverings|watercolor-dots-adrian|ACTIVE|DIG-2400093|DIG-2400093-SAMPLE|WATERCOLOR-DOTS-ADRIAN|DW Bespoke Studio|2025-05-22 13:38:44|Y|2|true|true|0
+Dig-240407-25-type-2-vinyl-Sample|gid://shopify/Product/7664493002803|Minimalist Simple Leaves - Green and Brown | Architectural Wallcoverings|antique-lizard-beige-and-brown-tones-copia-1|ACTIVE|Dig-240407-25-type-2-vinyl-Sample|DIG-2400065-25-type-2-vinyl-2x12|ANTIQUE-LIZARD-BEIGE-AND-BROWN-TONES-COPIA-1|DW Bespoke Studio|2025-09-02 22:29:40|Y|16|true|true|0
+Dig-240407-25-type-2-vinyl-Sample|gid://shopify/Product/7664584884275|Fairfield Happy Days 1970's Retro | Architectural Wallcoverings|authentic-1970s-reproduction-vintage-wallcoverings-dig-74118-1|ACTIVE|Dig-240407-25-type-2-vinyl-Sample|DIG-74118-25-type-2-vinyl-2x12|DIG74118 (SPN#15014213)|DW Bespoke Studio|2025-09-03 01:32:48|Y|16|true|true|0
+Dig-240416-25-type-2-vinyl-Sample|gid://shopify/Product/7664512237619|Boudoir Ladies - Pink - V. 1.0 Art Deco | Architectural Wallcoverings|boudoir-ladies-pink-version-1-0-24-x-22-pattern-design-dig-68000-1|ACTIVE|Dig-240416-25-type-2-vinyl-Sample|DIG-68000-25-type-2-vinyl-2x12|DIG68000 Graphics Completed 8/10/2023|DW Bespoke Studio|2025-09-02 23:28:22|Y|16|true|true|0
+Dig-240416-25-type-2-vinyl-Sample|gid://shopify/Product/7664512663603|Cello Damask - Sepia Beige Traditional | Architectural Wallcoverings|cello-damask-sepia-beige-pattern-design-lab-dig-98621-1|ACTIVE|Dig-240416-25-type-2-vinyl-Sample|DIG-98621-25-type-2-vinyl-2x12|dig-cello1|DW Bespoke Studio|2025-09-02 23:29:34|Y|16|true|true|0
+Dig-240417-25-type-2-vinyl-Sample|gid://shopify/Product/7664489529395|Calm Elegance Watercolor Soft Dreamy Blue Mural Contemporary | Architectural Wallcoverings|calm-elegance-series-soft-dreamy-bluish-1|ACTIVE|Dig-240417-25-type-2-vinyl-Sample|Dig-240416-Sample25-type-2-vinyl-2x12|CALM-ELEGANCE-SERIES-SOFT-DREAMY-BLUISH-1|DW Bespoke Studio|2025-09-02 22:23:54|Y|16|true|true|0
+Dig-240417-25-type-2-vinyl-Sample|gid://shopify/Product/7774188404787|Nocturnal Anthurium Tropical | Architectural Wallcoverings|nocturnal-anthurium-adrian-d-dw-bespoke-studios|ACTIVE|Dig-240417-25-type-2-vinyl-Sample|Dig-240416-Sample25-type-2-vinyl-2x12|NOCTURNAL-ANTHURIUM-ADRIAN-D-DW-BESPOKE-STUDIOS|DW Bespoke Studio|2026-02-08 20:18:54|Y|16|true|true|0
+Dig-240420|gid://shopify/Product/7502400847923|Golden Peaks Majestic Mural (Adrian) Contemporary | Architectural Wallcoverings|golden-peaks-majestic-mural-adrian|ACTIVE|Dig-240420|Dig-240420|GOLDEN-PEAKS-MAJESTIC-MURAL-ADRIAN|DW Bespoke Studio|2025-01-12 21:07:58|Y|2|true|true|0
+Dig-240420|gid://shopify/Product/7502401634355|Lavender Mist Peaks Mural (Adrian) Contemporary | Architectural Wallcoverings|lavender-mist-peaks-mural-adrian|ACTIVE|Dig-240420|Dig-240420|LAVENDER-MIST-PEAKS-MURAL-ADRIAN|DW Bespoke Studio|2025-01-12 21:13:59|Y|2|true|true|0
+DIG-240434-vinyl-2x1-sample|gid://shopify/Product/7663707619379|Rosé Luxe Mural Contemporary | Architectural Wallcoverings|rose-luxe-adrian1|ACTIVE|DIG-240434-vinyl-2x1-sample|DIG-240434-peel-sample-|ROSE-LUXE-ADRIAN1|DW Bespoke Studio|2025-09-01 05:03:24|Y|10|true|true|0
+DIG-240434-vinyl-2x1-sample|gid://shopify/Product/7663711354931|Soft Nude Gradient Mural Contemporary | Architectural Wallcoverings|soft-nude-gradient-adrian1|ACTIVE|DIG-240434-vinyl-2x1-sample|DIG-240434-peel-Sample-|SOFT-NUDE-GRADIENT-ADRIAN1|DW Bespoke Studio|2025-09-01 05:19:56|Y|10|true|true|0
+DIG-240434-vinyl-2x1-sample|gid://shopify/Product/7663711682611|Watercolor Dots Mural Contemporary | Architectural Wallcoverings|watercolor-dots-adrian1|ACTIVE|DIG-240434-vinyl-2x1-sample|DIG-240434-peel-Sample-|WATERCOLOR-DOTS-ADRIAN1|DW Bespoke Studio|2025-09-01 05:27:54|Y|10|true|true|0
+Dig-25-25-type-2-vinyl-Sample|gid://shopify/Product/7664513646643|Deep Reef Mural - Available In Your Colors Contemporary | Architectural Wallcoverings|deep-reef-mural-available-in-your-colors-1|ACTIVE|Dig-25-25-type-2-vinyl-Sample|DIG_10082002-25-type-2-vinyl-2x12|DEEP-REEF-MURAL-AVAILABLE-IN-YOUR-COLORS-1|DW Bespoke Studio|2025-09-02 23:32:53|Y|16|true|true|0
+Dig-25-25-type-2-vinyl-Sample|gid://shopify/Product/7664586686515|Thug Stripe - Cream Gun Wallcovering Cream Traditional | Architectural Wallcoverings|copy-of-thug-stripe-blue-cream-gun-wall-paper-1|ACTIVE|Dig-25-25-type-2-vinyl-Sample|DIG-439241 Sample-25-type-2-vinyl-2x12|COPY-OF-THUG-STRIPE-BLUE-CREAM-GUN-WALL-PAPER-1|DW Bespoke Studio|2025-09-03 01:43:16|Y|16|true|true|0
+DIG-320255-mural|gid://shopify/Product/7547203026995|Royal Lady Frames Gold Mural Pop Art | Architectural Wallcoverings|dig-320255-designerwallcoverings-com|ACTIVE|DIG-320255-mural|DIG-320255|DIG-320255 Royal Lady Final size 144 x 120|DW Bespoke Studio|2025-03-20 22:40:08|Y|2|true|true|0
+DIG-320255-mural|gid://shopify/Product/7548957392947|Royal Lady Frames Gold Mural Half Drop Pop Art | Architectural Wallcoverings|royal-lady-frames-gold-mural-half-drop|ACTIVE|DIG-320255-mural|DIG-320256|ROYAL-LADY-FRAMES-GOLD-MURAL-HALF-DROP|DW Bespoke Studio|2025-03-22 14:49:01|Y|2|true|true|0
+Dig-40021-25-type-2-vinyl-Sample|gid://shopify/Product/7664512073779|Bottles by Jordan Carlyle Contemporary | Architectural Wallcoverings|bottles-by-jordan-carlyle-pattern-design-lab-dig-40021-1|ACTIVE|Dig-40021-25-type-2-vinyl-Sample|DIG-40021-25-type-2-vinyl-2x12|BOTTLES-BY-JORDAN-CARLYLE-PATTERN-DESIGN-LAB-DIG-40021-1|DW Bespoke Studio|2025-09-02 23:27:47|Y|16|true|true|0
+Dig-40021-25-type-2-vinyl-Sample|gid://shopify/Product/7664512434227|Cello Damask - Charcoal Grey Traditional | Architectural Wallcoverings|cello-damask-charcoal-grey-pattern-design-lab-dig-85335-1|ACTIVE|Dig-40021-25-type-2-vinyl-Sample|DIG-85335-25-type-2-vinyl-2x12|CELLO-DAMASK-CHARCOAL-GREY-PATTERN-DESIGN-LAB-DIG-85335-1|DW Bespoke Studio|2025-09-02 23:28:51|Y|16|true|true|0
+DIG-4350959-Periwinkle - Sample|gid://shopify/Product/6707947208755|Cici's Periwinkle Traditional | Architectural Wallcoverings|cicis-authentic-vintage-1940s-reproduction-wallpapers|ACTIVE|DIG-4350959-Periwinkle - Sample|DIG-4350959-Periwinkle - Sample|CICIS-AUTHENTIC-VINTAGE-1940S-REPRODUCTION-WALLPAPERS|DW Bespoke Studio|2022-04-13 16:12:58|Y|1|true|false|0
+DIG-4350959-Periwinkle - Sample|gid://shopify/Product/7801847447603|Cici's Periwinkle Wallcovering | DW Bespoke Studios|cicis-periwinkle-wallcovering-dw-bespoke-studios|ACTIVE|DIG-4350959-Periwinkle - Sample||DIG-4350959-Periwinkle - Sample|DW Bespoke Studio|2026-03-23 18:29:27|Y|1|true|false|0
+DIG-5531287-25-type-2-vinyl-2x27|gid://shopify/Product/7664593338419|Wanda's Wandering Wisteria Authentic Vintage 1950's Mid-Century Modern | Architectural Wallcoverings|wandas-wandering-wisteria-authentic-vintage-1950s-reproduction-wallpapers-5-1|ACTIVE|DIG-5531287-25-type-2-vinyl-2x27|Dig-5531287-25-type-2-vinyl|WANDAS-WANDERING-WISTERIA-AUTHENTIC-VINTAGE-1950S-REPRODUCTION-WALLPAPERS-5-1|DW Bespoke Studio|2025-09-03 02:09:49|Y|16|true|true|0
+DIG-5531287-25-type-2-vinyl-2x27|gid://shopify/Product/7664593371187|Wanda's Wandering Wisteria Authentic Vintage 1950's Floral Mid-Century Modern | Architectural Wallcoverings|wandas-wandering-wisteria-authentic-vintage-1950s-reproduction-wallpapers-4-1|ACTIVE|DIG-5531287-25-type-2-vinyl-2x27|Dig-5531287-25-type-2-vinyl|WANDAS-WANDERING-WISTERIA-AUTHENTIC-VINTAGE-1950S-REPRODUCTION-WALLPAPERS-4-1|DW Bespoke Studio|2025-09-03 02:09:52|Y|16|true|true|0
+DIG-553801-25-type-2-vinyl-2x27|gid://shopify/Product/7664593633331|Rosie's Roses Authentic Vintage 1950's Traditional | Architectural Wallcoverings|rosies-roses-authentic-vintage-1950s-reproduction-wallpapers-1-1|ACTIVE|DIG-553801-25-type-2-vinyl-2x27|Dig-553801-25-type-2-vinyl|ROSIES-ROSES-AUTHENTIC-VINTAGE-1950S-REPRODUCTION-WALLPAPERS-1-1|DW Bespoke Studio|2025-09-03 02:10:31|Y|16|true|true|0
+DIG-553801-25-type-2-vinyl-2x27|gid://shopify/Product/7664629514291|Rosie's Roses 1950's Traditional | Architectural Wallcoverings|dig_55380_vintage_wallpaper_designer_wallcoverings-1|ACTIVE|DIG-553801-25-type-2-vinyl-2x27|Dig-553801-25-type-2-vinyl|DIG_55380|DW Bespoke Studio|2025-09-03 03:49:03|Y|16|true|true|0
+DIG-740017|gid://shopify/Product/6900076249139|Happy Days Revivial - Authentic 1970's Vintage Mid-Century Modern | Architectural Wallcoverings|happy-days-revivial-authentic-1970s-reproduction-vintage-wallcoverings|ACTIVE|DIG-740017|DIG-740017-SAMPLE|HAPPY-DAYS-REVIVIAL-AUTHENTIC-1970S-REPRODUCTION-VINTAGE-WALLCOVERINGS|DW Bespoke Studio|2023-03-13 21:52:00|Y|2|true|true|0
+DIG-740017|gid://shopify/Product/7582541578291|Happy Days Revivial - Authentic 1970'S Vintage Mid-Century Modern | Architectural Wallcoverings|happy-days-revivial-authentic-1970s-reproduction-vintage-wallpapers|ACTIVE|DIG-740017|DIG-740017-SAMPLE|HAPPY-DAYS-REVIVIAL-AUTHENTIC-1970S-REPRODUCTION-VINTAGE-WALLPAPERS|DW Bespoke Studio|2025-05-09 22:39:01|Y|2|true|true|0
+DIG-762124-Sample-25-type-2-vinyl-2x27|gid://shopify/Product/7664598614067|Gregorious Gulls Yellow Coastal | Architectural Wallcoverings|dwh-73101-1|ACTIVE|DIG-762124-Sample-25-type-2-vinyl-2x27|Dig-762124-25-type-2-vinyl|DWH-73101-1|DW Bespoke Studio|2025-09-03 02:20:02|Y|16|true|true|0
+DIG-762124-Sample-25-type-2-vinyl-2x27|gid://shopify/Product/7664616800307|Zepellin Zebras Yellow Traditional Contemporary | Architectural Wallcoverings|dwh-67501-1|ACTIVE|DIG-762124-Sample-25-type-2-vinyl-2x27|Dig-762124-25-type-2-vinyl|DWH-67501-1|DW Bespoke Studio|2025-09-03 03:35:33|Y|16|true|true|0
+Dig-770064-25-type-2-vinyl-2x27|gid://shopify/Product/7664638427187|Hanover 1970's Geometric Mid-Century Modern | Architectural Wallcoverings|happy-1970-s-inspired-patterns-58-1|ACTIVE|Dig-770064-25-type-2-vinyl-2x27|Dig-770064-25-type-2-vinyl|HAPPY-1970-S-INSPIRED-PATTERNS-58-1|DW Bespoke Studio|2025-09-03 04:13:10|Y|16|true|true|0
+Dig-770064-25-type-2-vinyl-2x27|gid://shopify/Product/7664638459955|Bailey Bottles of Booze 1970's Retro | Architectural Wallcoverings|happy-1970-s-inspired-patterns-57-1|ACTIVE|Dig-770064-25-type-2-vinyl-2x27|Dig-770064-25-type-2-vinyl|HAPPY-1970-S-INSPIRED-PATTERNS-57-1|DW Bespoke Studio|2025-09-03 04:13:18|Y|16|true|true|0
+Dig-7700743-25-type-2-vinyl-Sample|gid://shopify/Product/7664488218675|Cranes in the Cherry Blossom Lake Japonisme | Architectural Wallcoverings|cranes-in-the-cherry-blossom-lake-adrian-1|ACTIVE|Dig-7700743-25-type-2-vinyl-Sample|Dig-240426-Sample-25-type-2-vinyl-2x12|CRANES-IN-THE-CHERRY-BLOSSOM-LAKE-ADRIAN-1|DW Bespoke Studio|2025-09-02 22:21:38|Y|16|true|true|0
+Dig-7700743-25-type-2-vinyl-Sample|gid://shopify/Product/7664586915891|Geomino 1970's Geometric Retro | Architectural Wallcoverings|crunkin-authentic-1970s-reproduction-vintage-wallcoverings-1-1|ACTIVE|Dig-7700743-25-type-2-vinyl-Sample|Dig-7700743-25-type-2-vinyl-2x12|CRUNKIN-AUTHENTIC-1970S-REPRODUCTION-VINTAGE-WALLCOVERINGS-1-1|DW Bespoke Studio|2025-09-03 01:44:17|Y|16|true|true|0
+Dig-770089-25-type-2-vinyl-Sample|gid://shopify/Product/7664584851507|Fitzwilliam 1970's Pop Art | Architectural Wallcoverings|authentic-1970s-reproduction-vintage-wallcoverings-dig-740108-1|ACTIVE|Dig-770089-25-type-2-vinyl-Sample|DIG-740108-25-type-2-vinyl-2x12|DIG740108|DW Bespoke Studio|2025-09-03 01:32:41|Y|16|true|true|0
+Dig-770089-25-type-2-vinyl-Sample|gid://shopify/Product/7664636100659|Willington 1940's Branches Chinoiserie | Architectural Wallcoverings|dig_435086_vintage_wallpaper_designer_wallcoverings-1|ACTIVE|Dig-770089-25-type-2-vinyl-Sample|DIG-435086-25-type-2-vinyl-2x12|DIG_435086|DW Bespoke Studio|2025-09-03 04:04:29|Y|15|true|true|0
+DIG-977081-Sample-25-type-2-vinyl-2x27|gid://shopify/Product/7664592814131|Riley'S Rainbow Of Retro Authentic 1970S Design | Architectural Wallcoverings|rileys-rainbow-of-retro-authentic-1970s-wallpaper-design-5-1|ACTIVE|DIG-977081-Sample-25-type-2-vinyl-2x27|Dig-977081-25-type-2-vinyl|RILEYS-RAINBOW-OF-RETRO-AUTHENTIC-1970S-WALLPAPER-DESIGN-5-1|DW Bespoke Studio|2025-09-03 02:07:47|Y|16|true|true|0
+DIG-977081-Sample-25-type-2-vinyl-2x27|gid://shopify/Product/7664592846899|Fremont 1970S Fern Mid-Century Modern | Architectural Wallcoverings|rileys-rainbow-of-retro-authentic-1970s-wallpaper-design-4-1|ACTIVE|DIG-977081-Sample-25-type-2-vinyl-2x27|Dig-977081-25-type-2-vinyl|RILEYS-RAINBOW-OF-RETRO-AUTHENTIC-1970S-WALLPAPER-DESIGN-4-1|DW Bespoke Studio|2025-09-03 02:07:51|Y|16|true|true|0
+DWC-Arte-40323-Sample|gid://shopify/Product/4348475899955|Fringe Double Jute Contemporary Wallcovering|fringe-double-jute-contemporary-wallpaper-5|ACTIVE|DWC-Arte-40323-Sample|DWC-Arte-40323|40323|Arte International|2019-11-15 06:43:17|Y|2|true|true|0
+DWC-Arte-40323-Sample|gid://shopify/Product/4348476653619|Fringe Double Jute Contemporary Wallcovering|fringe-double-jute-contemporary-wallpaper-6|ACTIVE|DWC-Arte-40323-Sample|DWC-Arte-40323|40323|Arte International|2019-11-15 06:43:42|Y|2|true|true|0
+DWK-30522|gid://shopify/Product/7584916308019|Happenstance Curiosity - Steel Blue Commercial Wallcovering | Koroseal|dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-amethyst|ACTIVE|DWK-30522|DWK-30522|HP21-08|Koroseal|2025-05-14 02:42:58|Y|1|true|false|0
+DWK-30522|gid://shopify/Product/7632318464051|Happenstance Curiosity - Steel Blue Commercial Wallcovering | Koroseal|dwk-30522-koroseal-koroseal-type-2-vinyl-hp21-08-happenstance-curiosity|ACTIVE|DWK-30522|DWK-30522|HP21-08|Koroseal|2025-07-08 06:57:42|Y|1|true|false|0
+MIS-18313|gid://shopify/Product/6751726698547|Magic Garden Wallcovering - Blue/Green/Multi|magic-garden-wallpaper-blue-green-multi|ACTIVE|MIS-18313|MIS-18313|MI10313|Missoni Wallpaper|2022-06-09 17:16:46|Y|2|true|true|0
+MIS-18313|gid://shopify/Product/6751727386675|Magic Garden Wallcovering - Cream|magic-garden-wallpaper-cream|ACTIVE|MIS-18313|MIS-18313|MAGIC-GARDEN-WALLPAPER-CREAM|Missoni Wallpaper|2022-06-09 17:21:16|Y|2|true|true|0
+MIS-18366W1|gid://shopify/Product/6751729385523|Chevronette Wallcovering - Pearl|chevronette-wallpaper-pearl|ACTIVE|MIS-18366W1|MIS-18366W1|CHEVRONETTE-WALLPAPER-PEARL|Missoni Wallpaper|2022-06-09 17:34:06|Y|2|true|true|0
+MIS-18366W1|gid://shopify/Product/6751729549363|Chevronette Wallcovering - White|chevronette-wallpaper-white|ACTIVE|MIS-18366W1|MIS-118366W1|CHEVRONETTE-WALLPAPER-WHITE|Missoni Wallpaper|2022-06-09 17:35:24|Y|2|true|true|0
+MIS-18398|gid://shopify/Product/6753061896243|Iconic Shades Ombre Wallcovering - Taupe|iconic-shades-wallpaper-taupe|ACTIVE|MIS-18398|MIS-18398|MI10398|Missoni Wallpaper|2022-06-13 16:10:19|Y|2|true|true|0
+MIS-18398|gid://shopify/Product/6753081589811|Striped Sunset Wallcovering - Brown/Multi|striped-sunset-wallpaper-brown-multi|ACTIVE|MIS-18398|MIS-18398|STRIPED-SUNSET-WALLPAPER-BROWN-MULTI|Missoni Wallpaper|2022-06-13 16:36:52|Y|2|true|true|0
+MTG-403024-Sample|gid://shopify/Product/4469009481779|Apodyterium - Beige Wallcovering | Mind the Gap|apodyterium|ACTIVE|MTG-403024-Sample|MTG-403024|APODYTERIUM|Mind the Gap|2020-03-12 20:33:00|Y|1|true|false|0
+MTG-403024-Sample|gid://shopify/Product/4469009514547|Apodyterium Taupe - Beige Wallcovering | Mind the Gap|apodyterium-taupe|ACTIVE|MTG-403024-Sample|MTG-403024|APODYTERIUM-TAUPE|Mind the Gap|2020-03-12 20:33:03|Y|1|true|false|0
+MTG-403235-Sample|gid://shopify/Product/4469013381171|Exotic Fruit 2|exotic-fruit-2|ACTIVE|MTG-403235-Sample|MTG-403235|EXOTIC-FRUIT-2|Mind the Gap|2020-03-12 20:40:07|Y|1|true|false|0
+MTG-403235-Sample|gid://shopify/Product/4469049786419|Eyes and Circles Blue|eyes-and-circles-blue|ACTIVE|MTG-403235-Sample|MTG-403235|EYES-AND-CIRCLES-BLUE|Mind the Gap|2020-03-12 22:00:40|Y|1|true|false|0
+MTG-403490-Sample|gid://shopify/Product/4469053718579|Neon Kiss - White Wallcovering | Mind the Gap|neon-kiss|ACTIVE|MTG-403490-Sample|MTG-403490|NEON-KISS|Mind the Gap|2020-03-12 22:06:47|Y|1|true|false|0
+MTG-403490-Sample|gid://shopify/Product/4469053751347|Newton Geometry taupe|newton-geometry-taupe|ACTIVE|MTG-403490-Sample|MTG-403490|NEWTON-GEOMETRY-TAUPE|Mind the Gap|2020-03-12 22:06:52|Y|1|true|false|0
+MTG-403723-Sample|gid://shopify/Product/4469024948275|Water Lilies - White Wallcovering | Mind the Gap|water-lilies|ACTIVE|MTG-403723-Sample|MTG-403723|WATER-LILIES|Mind the Gap|2020-03-12 20:55:22|Y|1|true|false|0
+MTG-403723-Sample|gid://shopify/Product/4469057945651|Wilderness - Beige Wallcovering | Mind the Gap|wilderness|ACTIVE|MTG-403723-Sample|MTG-403723|WILDERNESS|Mind the Gap|2020-03-12 22:12:29|Y|1|true|false|0
+PRW-65002-Sample|gid://shopify/Product/7478729867315|Pietro Real Wood Veneer Cedar | Phillipe Romano|prw-65002-designer-wallcoverings-los-angeles|ACTIVE|PRW-65002-Sample|PRW-65002|PRW-65002-Per Yard|Phillipe Romano|2024-12-06 19:12:03|Y|2|true|true|0
+PRW-65002-Sample|gid://shopify/Product/7862994960435|Pietro Real Wood Veneer Cedar Memo Sample | Phillipe Romano|pietro-real-wood-veneer-cedar-memo-sample-phillipe-romano|ACTIVE|PRW-65002-Sample||ORI02|Phillipe Romano|2026-06-16 12:43:47|Y|1|true|false|0
+PRW-65003-Sample|gid://shopify/Product/7478729932851|Pietro Real Wood Veneer Natural | Phillipe Romano|prw-65003-designer-wallcoverings-los-angeles|ACTIVE|PRW-65003-Sample|PRW-65003|PRW-65003-Per Yard|Phillipe Romano|2024-12-06 19:12:09|Y|2|true|true|0
+PRW-65003-Sample|gid://shopify/Product/7862995419187|Pietro Real Wood Veneer Natural Memo Sample | Phillipe Romano|pietro-real-wood-veneer-natural-memo-sample-phillipe-romano|ACTIVE|PRW-65003-Sample||ORI03|Phillipe Romano|2026-06-16 12:43:56|Y|1|true|false|0
+PRW-65016-Sample|gid://shopify/Product/7478730096691|Pietro Real Wood Veneer | Phillipe Romano|prw-65016-designer-wallcoverings-los-angeles|ACTIVE|PRW-65016-Sample|PRW-65016|PRW-65016-Per Yard|Phillipe Romano|2024-12-06 19:12:20|Y|2|true|true|0
+PRW-65016-Sample|gid://shopify/Product/7862995976243|Pietro Real Wood Veneer Memo Sample | Phillipe Romano|pietro-real-wood-veneer-memo-sample-phillipe-romano-2|ACTIVE|PRW-65016-Sample||ORI16|Phillipe Romano|2026-06-16 12:44:04|Y|1|true|false|0
diff --git a/tk10002-phase2b/false-collisions.md b/tk10002-phase2b/false-collisions.md
new file mode 100644
index 00000000..42b8c9cb
--- /dev/null
+++ b/tk10002-phase2b/false-collisions.md
@@ -0,0 +1,32 @@
+| `AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange` | DW Bespoke Studio | 7675395145779 · dw=AIDIG-4350142-25_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange · Piermont 1940's Retro ／ Architectu<br>7675395178547 · dw=AIDIG-4350142-25_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange · Piermont 1940's Cody Retro ／ Archi |
+| `Dig-1100-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664512794675 · dw=DIG-1952-25-type-2-vinyl-2x12 · Classic Cherries Jubilee - Red Gre<br>7664512827443 · dw=Vin-1100-25-type-2-vinyl-2x12 · Classic green floral vintage wallc |
+| `Dig-171053-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664490512435 · dw=DIG-171053-25-type-2-vinyl-2x12 · Charlotte's Authentic Vintage 1910<br>7664490545203 · dw=DIG-171052-25-type-2-vinyl-2x12 · Charlotte's Authentic Vintage 1910 |
+| `DIG-2400069-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664493068339 · dw=Dig-2400069-25-type-2-vinyl · Ethereal Dreamy White Clouds Conte<br>7664493101107 · dw=Dig-2400069-25-type-2-vinyl · Hand-Drawn White and Green Stripes |
+| `Dig-2400089-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664462233651 · dw=DIG-2400089-25-type-2-vinyl-2x12 · Blushed Marble Mural Contemporary <br>7664462364723 · dw=DIG-2400085-25-type-2-vinyl-2x12 · Blush Tide Mural Contemporary ／ Ar |
+| `DIG-2400093` | DW Bespoke Studio | 7589565300787 · dw=DIG-2400093-SAMPLE · Playform Mural Contemporary ／ Arch<br>7589588402227 · dw=DIG-2400093-SAMPLE · Watercolor Dots Mural Scandinavian |
+| `Dig-240407-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664493002803 · dw=DIG-2400065-25-type-2-vinyl-2x12 · Minimalist Simple Leaves - Green a<br>7664584884275 · dw=DIG-74118-25-type-2-vinyl-2x12 · Fairfield Happy Days 1970's Retro |
+| `Dig-240416-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664512237619 · dw=DIG-68000-25-type-2-vinyl-2x12 · Boudoir Ladies - Pink - V. 1.0 Art<br>7664512663603 · dw=DIG-98621-25-type-2-vinyl-2x12 · Cello Damask - Sepia Beige Traditi |
+| `Dig-240417-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664489529395 · dw=Dig-240416-Sample25-type-2-vinyl-2x12 · Calm Elegance Watercolor Soft Drea<br>7774188404787 · dw=Dig-240416-Sample25-type-2-vinyl-2x12 · Nocturnal Anthurium Tropical ／ Arc |
+| `Dig-240420` | DW Bespoke Studio | 7502400847923 · dw=Dig-240420 · Golden Peaks Majestic Mural (Adria<br>7502401634355 · dw=Dig-240420 · Lavender Mist Peaks Mural (Adrian) |
+| `DIG-240434-vinyl-2x1-sample` | DW Bespoke Studio | 7663707619379 · dw=DIG-240434-peel-sample- · Rosé Luxe Mural Contemporary ／ Arc<br>7663711354931 · dw=DIG-240434-peel-Sample- · Soft Nude Gradient Mural Contempor<br>7663711682611 · dw=DIG-240434-peel-Sample- · Watercolor Dots Mural Contemporary |
+| `Dig-25-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664513646643 · dw=DIG_10082002-25-type-2-vinyl-2x12 · Deep Reef Mural - Available In You<br>7664586686515 · dw=DIG-439241 Sample-25-type-2-vinyl-2x12 · Thug Stripe - Cream Gun Wallcoveri |
+| `DIG-320255-mural` | DW Bespoke Studio | 7547203026995 · dw=DIG-320255 · Royal Lady Frames Gold Mural Pop A<br>7548957392947 · dw=DIG-320256 · Royal Lady Frames Gold Mural Half |
+| `Dig-40021-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664512073779 · dw=DIG-40021-25-type-2-vinyl-2x12 · Bottles by Jordan Carlyle Contempo<br>7664512434227 · dw=DIG-85335-25-type-2-vinyl-2x12 · Cello Damask - Charcoal Grey Tradi |
+| `DIG-4350959-Periwinkle - Sample` | DW Bespoke Studio | 6707947208755 · dw=DIG-4350959-Periwinkle - Sample · Cici's Periwinkle Traditional ／ Ar<br>7801847447603 · dw=∅ · Cici's Periwinkle Wallcovering ／ D |
+| `DIG-5531287-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664593338419 · dw=Dig-5531287-25-type-2-vinyl · Wanda's Wandering Wisteria Authent<br>7664593371187 · dw=Dig-5531287-25-type-2-vinyl · Wanda's Wandering Wisteria Authent |
+| `DIG-553801-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664593633331 · dw=Dig-553801-25-type-2-vinyl · Rosie's Roses Authentic Vintage 19<br>7664629514291 · dw=Dig-553801-25-type-2-vinyl · Rosie's Roses 1950's Traditional ／ |
+| `DIG-762124-Sample-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664598614067 · dw=Dig-762124-25-type-2-vinyl · Gregorious Gulls Yellow Coastal ／ <br>7664616800307 · dw=Dig-762124-25-type-2-vinyl · Zepellin Zebras Yellow Traditional |
+| `Dig-770064-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664638427187 · dw=Dig-770064-25-type-2-vinyl · Hanover 1970's Geometric Mid-Centu<br>7664638459955 · dw=Dig-770064-25-type-2-vinyl · Bailey Bottles of Booze 1970's Ret |
+| `Dig-7700743-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664488218675 · dw=Dig-240426-Sample-25-type-2-vinyl-2x12 · Cranes in the Cherry Blossom Lake <br>7664586915891 · dw=Dig-7700743-25-type-2-vinyl-2x12 · Geomino 1970's Geometric Retro ／ A |
+| `Dig-770089-25-type-2-vinyl-Sample` | DW Bespoke Studio | 7664584851507 · dw=DIG-740108-25-type-2-vinyl-2x12 · Fitzwilliam 1970's Pop Art ／ Archi<br>7664636100659 · dw=DIG-435086-25-type-2-vinyl-2x12 · Willington 1940's Branches Chinois |
+| `DIG-977081-Sample-25-type-2-vinyl-2x27` | DW Bespoke Studio | 7664592814131 · dw=Dig-977081-25-type-2-vinyl · Riley'S Rainbow Of Retro Authentic<br>7664592846899 · dw=Dig-977081-25-type-2-vinyl · Fremont 1970S Fern Mid-Century Mod |
+| `MTG-403024-Sample` | Mind the Gap | 4469009481779 · dw=MTG-403024 · Apodyterium - Beige Wallcovering ／<br>4469009514547 · dw=MTG-403024 · Apodyterium Taupe - Beige Wallcove |
+| `MTG-403235-Sample` | Mind the Gap | 4469013381171 · dw=MTG-403235 · Exotic Fruit 2<br>4469049786419 · dw=MTG-403235 · Eyes and Circles Blue |
+| `MTG-403490-Sample` | Mind the Gap | 4469053718579 · dw=MTG-403490 · Neon Kiss - White Wallcovering ／ M<br>4469053751347 · dw=MTG-403490 · Newton Geometry taupe |
+| `MTG-403723-Sample` | Mind the Gap | 4469024948275 · dw=MTG-403723 · Water Lilies - White Wallcovering <br>4469057945651 · dw=MTG-403723 · Wilderness - Beige Wallcovering ／ |
+| `MIS-18313` | Missoni Wallpaper | 6751726698547 · dw=MIS-18313 · Magic Garden Wallcovering - Blue/G<br>6751727386675 · dw=MIS-18313 · Magic Garden Wallcovering - Cream |
+| `MIS-18366W1` | Missoni Wallpaper | 6751729385523 · dw=MIS-18366W1 · Chevronette Wallcovering - Pearl<br>6751729549363 · dw=MIS-118366W1 · Chevronette Wallcovering - White |
+| `MIS-18398` | Missoni Wallpaper | 6753061896243 · dw=MIS-18398 · Iconic Shades Ombre Wallcovering -<br>6753081589811 · dw=MIS-18398 · Striped Sunset Wallcovering - Brow |
+| `PRW-65002-Sample` | Phillipe Romano | 7478729867315 · dw=PRW-65002 · Pietro Real Wood Veneer Cedar ／ Ph<br>7862994960435 · dw=∅ · Pietro Real Wood Veneer Cedar Memo |
+| `PRW-65003-Sample` | Phillipe Romano | 7478729932851 · dw=PRW-65003 · Pietro Real Wood Veneer Natural ／ <br>7862995419187 · dw=∅ · Pietro Real Wood Veneer Natural Me |
+| `PRW-65016-Sample` | Phillipe Romano | 7478730096691 · dw=PRW-65016 · Pietro Real Wood Veneer ／ Phillipe<br>7862995976243 · dw=∅ · Pietro Real Wood Veneer Memo Sampl |
diff --git a/tk10002-phase2b/false-collisions.tsv b/tk10002-phase2b/false-collisions.tsv
new file mode 100644
index 00000000..d46d84ac
--- /dev/null
+++ b/tk10002-phase2b/false-collisions.tsv
@@ -0,0 +1,32 @@
+AIDIG-4350142-25-gold-2x27_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange\tDW Bespoke Studio\t7675395145779::AIDIG-4350142-25_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange::Piermont 1940's Retro | Architectural || 7675395178547::AIDIG-4350142-25_Flame_Scarlet_Orange_&_Autumn_Glaze_Orange::Piermont 1940's Cody Retro | Architect
+Dig-1100-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664512794675::DIG-1952-25-type-2-vinyl-2x12::Classic Cherries Jubilee - Red Green W || 7664512827443::Vin-1100-25-type-2-vinyl-2x12::Classic green floral vintage wallcover
+Dig-171053-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664490512435::DIG-171053-25-type-2-vinyl-2x12::Charlotte's Authentic Vintage 1910's R || 7664490545203::DIG-171052-25-type-2-vinyl-2x12::Charlotte's Authentic Vintage 1910's R
+DIG-2400069-25-type-2-vinyl-2x27\tDW Bespoke Studio\t7664493068339::Dig-2400069-25-type-2-vinyl::Ethereal Dreamy White Clouds Contempor || 7664493101107::Dig-2400069-25-type-2-vinyl::Hand-Drawn White and Green Stripes Con
+Dig-2400089-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664462233651::DIG-2400089-25-type-2-vinyl-2x12::Blushed Marble Mural Contemporary | Ar || 7664462364723::DIG-2400085-25-type-2-vinyl-2x12::Blush Tide Mural Contemporary | Archit
+DIG-2400093\tDW Bespoke Studio\t7589565300787::DIG-2400093-SAMPLE::Playform Mural Contemporary | Architec || 7589588402227::DIG-2400093-SAMPLE::Watercolor Dots Mural Scandinavian | A
+Dig-240407-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664493002803::DIG-2400065-25-type-2-vinyl-2x12::Minimalist Simple Leaves - Green and B || 7664584884275::DIG-74118-25-type-2-vinyl-2x12::Fairfield Happy Days 1970's Retro | Ar
+Dig-240416-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664512237619::DIG-68000-25-type-2-vinyl-2x12::Boudoir Ladies - Pink - V. 1.0 Art Dec || 7664512663603::DIG-98621-25-type-2-vinyl-2x12::Cello Damask - Sepia Beige Traditional
+Dig-240417-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664489529395::Dig-240416-Sample25-type-2-vinyl-2x12::Calm Elegance Watercolor Soft Dreamy B || 7774188404787::Dig-240416-Sample25-type-2-vinyl-2x12::Nocturnal Anthurium Tropical | Archite
+Dig-240420\tDW Bespoke Studio\t7502400847923::Dig-240420::Golden Peaks Majestic Mural (Adrian) C || 7502401634355::Dig-240420::Lavender Mist Peaks Mural (Adrian) Con
+DIG-240434-vinyl-2x1-sample\tDW Bespoke Studio\t7663707619379::DIG-240434-peel-sample-::Rosé Luxe Mural Contemporary | Archite || 7663711354931::DIG-240434-peel-Sample-::Soft Nude Gradient Mural Contemporary || 7663711682611::DIG-240434-peel-Sample-::Watercolor Dots Mural Contemporary | A
+Dig-25-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664513646643::DIG_10082002-25-type-2-vinyl-2x12::Deep Reef Mural - Available In Your Co || 7664586686515::DIG-439241 Sample-25-type-2-vinyl-2x12::Thug Stripe - Cream Gun Wallcovering C
+DIG-320255-mural\tDW Bespoke Studio\t7547203026995::DIG-320255::Royal Lady Frames Gold Mural Pop Art | || 7548957392947::DIG-320256::Royal Lady Frames Gold Mural Half Drop
+Dig-40021-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664512073779::DIG-40021-25-type-2-vinyl-2x12::Bottles by Jordan Carlyle Contemporary || 7664512434227::DIG-85335-25-type-2-vinyl-2x12::Cello Damask - Charcoal Grey Tradition
+DIG-4350959-Periwinkle - Sample\tDW Bespoke Studio\t6707947208755::DIG-4350959-Periwinkle - Sample::Cici's Periwinkle Traditional | Archit || 7801847447603::∅::Cici's Periwinkle Wallcovering | DW Be
+DIG-5531287-25-type-2-vinyl-2x27\tDW Bespoke Studio\t7664593338419::Dig-5531287-25-type-2-vinyl::Wanda's Wandering Wisteria Authentic V || 7664593371187::Dig-5531287-25-type-2-vinyl::Wanda's Wandering Wisteria Authentic V
+DIG-553801-25-type-2-vinyl-2x27\tDW Bespoke Studio\t7664593633331::Dig-553801-25-type-2-vinyl::Rosie's Roses Authentic Vintage 1950's || 7664629514291::Dig-553801-25-type-2-vinyl::Rosie's Roses 1950's Traditional | Arc
+DIG-762124-Sample-25-type-2-vinyl-2x27\tDW Bespoke Studio\t7664598614067::Dig-762124-25-type-2-vinyl::Gregorious Gulls Yellow Coastal | Arch || 7664616800307::Dig-762124-25-type-2-vinyl::Zepellin Zebras Yellow Traditional Con
+Dig-770064-25-type-2-vinyl-2x27\tDW Bespoke Studio\t7664638427187::Dig-770064-25-type-2-vinyl::Hanover 1970's Geometric Mid-Century M || 7664638459955::Dig-770064-25-type-2-vinyl::Bailey Bottles of Booze 1970's Retro |
+Dig-7700743-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664488218675::Dig-240426-Sample-25-type-2-vinyl-2x12::Cranes in the Cherry Blossom Lake Japo || 7664586915891::Dig-7700743-25-type-2-vinyl-2x12::Geomino 1970's Geometric Retro | Archi
+Dig-770089-25-type-2-vinyl-Sample\tDW Bespoke Studio\t7664584851507::DIG-740108-25-type-2-vinyl-2x12::Fitzwilliam 1970's Pop Art | Architect || 7664636100659::DIG-435086-25-type-2-vinyl-2x12::Willington 1940's Branches Chinoiserie
+DIG-977081-Sample-25-type-2-vinyl-2x27\tDW Bespoke Studio\t7664592814131::Dig-977081-25-type-2-vinyl::Riley'S Rainbow Of Retro Authentic 197 || 7664592846899::Dig-977081-25-type-2-vinyl::Fremont 1970S Fern Mid-Century Modern
+MTG-403024-Sample\tMind the Gap\t4469009481779::MTG-403024::Apodyterium - Beige Wallcovering | Min || 4469009514547::MTG-403024::Apodyterium Taupe - Beige Wallcovering
+MTG-403235-Sample\tMind the Gap\t4469013381171::MTG-403235::Exotic Fruit 2 || 4469049786419::MTG-403235::Eyes and Circles Blue
+MTG-403490-Sample\tMind the Gap\t4469053718579::MTG-403490::Neon Kiss - White Wallcovering | Mind || 4469053751347::MTG-403490::Newton Geometry taupe
+MTG-403723-Sample\tMind the Gap\t4469024948275::MTG-403723::Water Lilies - White Wallcovering | Mi || 4469057945651::MTG-403723::Wilderness - Beige Wallcovering | Mind
+MIS-18313\tMissoni Wallpaper\t6751726698547::MIS-18313::Magic Garden Wallcovering - Blue/Green || 6751727386675::MIS-18313::Magic Garden Wallcovering - Cream
+MIS-18366W1\tMissoni Wallpaper\t6751729385523::MIS-18366W1::Chevronette Wallcovering - Pearl || 6751729549363::MIS-118366W1::Chevronette Wallcovering - White
+MIS-18398\tMissoni Wallpaper\t6753061896243::MIS-18398::Iconic Shades Ombre Wallcovering - Tau || 6753081589811::MIS-18398::Striped Sunset Wallcovering - Brown/Mu
+PRW-65002-Sample\tPhillipe Romano\t7478729867315::PRW-65002::Pietro Real Wood Veneer Cedar | Philli || 7862994960435::∅::Pietro Real Wood Veneer Cedar Memo Sam
+PRW-65003-Sample\tPhillipe Romano\t7478729932851::PRW-65003::Pietro Real Wood Veneer Natural | Phil || 7862995419187::∅::Pietro Real Wood Veneer Natural Memo S
+PRW-65016-Sample\tPhillipe Romano\t7478730096691::PRW-65016::Pietro Real Wood Veneer | Phillipe Rom || 7862995976243::∅::Pietro Real Wood Veneer Memo Sample |
diff --git a/tk10002-phase2b/verify-truedupes.js b/tk10002-phase2b/verify-truedupes.js
new file mode 100644
index 00000000..87f38d82
--- /dev/null
+++ b/tk10002-phase2b/verify-truedupes.js
@@ -0,0 +1,37 @@
+#!/usr/bin/env node
+// TK-10002 Phase-2b: LIVE read-only verification of the 3 true-dupe merge candidates.
+// READ-ONLY. Confirms each product's live status, handle, variant SKUs, image presence.
+const fs = require('fs');
+for (const line of fs.readFileSync('/Users/macstudio3/Projects/secrets-manager/.env','utf8').split('\n')) {
+ const m = line.match(/^([A-Z0-9_]+)=(.*)$/); if (m) process.env[m[1]] = m[2].replace(/^["']|["']$/g,'');
+}
+const fetch = globalThis.fetch;
+const STORE = process.env.SHOPIFY_STORE_DOMAIN || 'designer-laboratory-sandbox.myshopify.com';
+const TOKEN = process.env.SHOPIFY_ADMIN_TOKEN;
+const API='2024-10';
+async function gql(query,variables={}){
+ const r=await fetch(`https://${STORE}/admin/api/${API}/graphql.json`,{method:'POST',
+ headers:{'Content-Type':'application/json','X-Shopify-Access-Token':TOKEN},body:JSON.stringify({query,variables})});
+ return r.json();
+}
+const groups={
+ 'DIG-740017':['6900076249139','7582541578291'],
+ 'DWC-Arte-40323-Sample':['4348475899955','4348476653619'],
+ 'DWK-30522':['7584916308019','7632318464051'],
+};
+(async()=>{
+ for(const [g,ids] of Object.entries(groups)){
+ console.log(`\n### GROUP ${g}`);
+ for(const id of ids){
+ const d=await gql(`query($id:ID!){ product(id:$id){ id title handle status
+ featuredImage{url} images(first:1){nodes{id}}
+ variants(first:20){nodes{sku title price inventoryItem{tracked}}} } }`,{id:`gid://shopify/Product/${id}`});
+ const p=d.data&&d.data.product;
+ if(!p){console.log(` ${id} -> NOT FOUND / ${JSON.stringify(d.errors||d)}`);continue;}
+ const skus=p.variants.nodes.map(v=>`${v.sku||'∅'}$${v.price}`).join(', ');
+ console.log(` ${id} | ${p.status} | img=${p.featuredImage?'Y':'N'} | ${p.handle}`);
+ console.log(` title="${p.title}" variants[${p.variants.nodes.length}]: ${skus}`);
+ await new Promise(r=>setTimeout(r,300));
+ }
+ }
+})();
← 5389ccb1 TK-10002 Phase-2a: pre-flight found all 8 target collisions
·
back to Ticket System
·
TK-10002 Phase-2b: apply 3 true-duplicate merges (archives l 8ccef832 →