← back to Dw Unbuyable Recovery Pilot
TK-10978: Scalamandre content-match reconciliation — 133 recoverable (dry-run)
c815a74fae1022238486d2a788fbe8dd2c3d98f2 · 2026-08-30 16:54:30 -0700 · Steve Abrams
Bridged the DWA↔DWSC SKU-identity gap via pattern+color content-match. 133/474 unique
high-precision matches (8/8 spot-verified exact); live-confirmed all sample-only =>
add-roll recovery. 38 ambiguous + 303 no-match held. Gated memo drafted to pending-approval.
Dry-run list: data/scalamandre-reconcile-dryrun.csv. No writes.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
A data/scalamandre-reconcile-dryrun.csvA data/scalamandre-reconcile.md
Diff
commit c815a74fae1022238486d2a788fbe8dd2c3d98f2
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Sun Aug 30 16:54:30 2026 -0700
TK-10978: Scalamandre content-match reconciliation — 133 recoverable (dry-run)
Bridged the DWA↔DWSC SKU-identity gap via pattern+color content-match. 133/474 unique
high-precision matches (8/8 spot-verified exact); live-confirmed all sample-only =>
add-roll recovery. 38 ambiguous + 303 no-match held. Gated memo drafted to pending-approval.
Dry-run list: data/scalamandre-reconcile-dryrun.csv. No writes.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
data/scalamandre-reconcile-dryrun.csv | 134 ++++++++++++++++++++++++++++++++++
data/scalamandre-reconcile.md | 37 ++++++++++
2 files changed, 171 insertions(+)
diff --git a/data/scalamandre-reconcile-dryrun.csv b/data/scalamandre-reconcile-dryrun.csv
new file mode 100644
index 0000000..35e8d7b
--- /dev/null
+++ b/data/scalamandre-reconcile-dryrun.csv
@@ -0,0 +1,134 @@
+shopify_sku,title,catalog_dw_sku,pattern_name,color_name,price_trade,computed_retail
+DWA-88958-Sample,Abyssal - Mural - Ocean | Scalamandre,DWSC-112284,ABYSSAL - MURAL,OCEAN,1582.00,2863.35
+DWA-89268-Sample,Adelaide Beaded Sisal - Burnished Gold | Scalamandre,DWSC-112417,ADELAIDE BEADED SISAL,BURNISHED GOLD,228.00,412.67
+DWA-89269-Sample,Adelaide Beaded Sisal - Ivory | Scalamandre,DWSC-112418,ADELAIDE BEADED SISAL,IVORY,228.00,412.67
+DWA-89267-Sample,Adelaide Beaded Sisal - Pewter | Scalamandre,DWSC-112419,ADELAIDE BEADED SISAL,PEWTER,228.00,412.67
+DWA-89246-Sample,Andrew Jackson Floral - Countryside | Scalamandre,DWSC-112327,ANDREW JACKSON FLORAL,COUNTRYSIDE,154.00,278.73
+DWA-89245-Sample,Andrew Jackson Floral - Riviera | Scalamandre,DWSC-112326,ANDREW JACKSON FLORAL,RIVIERA,154.00,278.73
+DWA-89244-Sample,Andrew Jackson Floral - Skylight | Scalamandre,DWSC-112328,ANDREW JACKSON FLORAL,SKYLIGHT,154.00,278.73
+DWA-89447-Sample,Aprile - Beige | Scalamandre,DWSC-112396,APRILE - VINYL WALLCOVERING,BEIGE,330.00,597.29
+DWA-89445-Sample,Aprile - Celeste | Scalamandre,DWSC-112398,APRILE - VINYL WALLCOVERING,CELESTE,330.00,597.29
+DWA-89448-Sample,Aprile - Magnolia | Scalamandre,DWSC-112395,APRILE - VINYL WALLCOVERING,MAGNOLIA,330.00,597.29
+DWA-89446-Sample,Aprile - Verde | Scalamandre,DWSC-112397,APRILE - VINYL WALLCOVERING,VERDE,330.00,597.29
+DWA-89326-Sample,Baldwin Bamboo - Cream & Blue On Lettuce | Scalamandre,DWSC-113238,BALDWIN BAMBOO,CREAM & BLUE ON LETTUCE,168.00,304.07
+DWA-89325-Sample,Baldwin Bamboo - Cream & Red On Aqua | Scalamandre,DWSC-113239,BALDWIN BAMBOO,CREAM & RED ON AQUA,168.00,304.07
+DWA-82597-Sample,Balinese Peacock - Alabaster | Scalamandre,DWSC-112821,BALINESE PEACOCK,ALABASTER,168.00,304.07
+DWA-82596-Sample,Balinese Peacock - Indigo | Scalamandre,DWSC-112826,BALINESE PEACOCK,INDIGO,168.00,304.07
+DWA-89287-Sample,Balinese Peacock - Lavender | Scalamandre,DWSC-112823,BALINESE PEACOCK,LAVENDER,168.00,304.07
+DWA-89286-Sample,Balinese Peacock - Mandarin | Scalamandre,DWSC-112825,BALINESE PEACOCK,MANDARIN,168.00,304.07
+DWA-89441-Sample,Bamboo - Cielo | Scalamandre,DWSC-112401,BAMBOO - WALLCOVERING,CIELO,245.00,443.44
+DWA-89440-Sample,Bamboo - Giallo | Scalamandre,DWSC-112402,BAMBOO - WALLCOVERING,GIALLO,245.00,443.44
+DWA-89443-Sample,Bamboo - Grigio | Scalamandre,DWSC-112399,BAMBOO - WALLCOVERING,GRIGIO,245.00,443.44
+DWA-89439-Sample,Bamboo - Mela | Scalamandre,DWSC-112403,BAMBOO - WALLCOVERING,MELA,245.00,443.44
+DWA-89442-Sample,Bamboo - Nebbia | Scalamandre,DWSC-112400,BAMBOO - WALLCOVERING,NEBBIA,245.00,443.44
+DWA-89110-Sample,Belize - Ivory | Scalamandre,DWSC-112455,BELIZE,IVORY,142.00,257.01
+DWA-89109-Sample,Belize - Sunlit | Scalamandre,DWSC-112454,BELIZE,SUNLIT,142.00,257.01
+DWA-89093-Sample,Bent Wood - Dark Brown | Scalamandre,DWSC-112322,BENT WOOD,DARK BROWN,26.25,47.51
+DWA-89160-Sample,Canyon - Gilt | Scalamandre,DWSC-112549,CANYON,GILT,138.00,249.77
+DWA-89162-Sample,Canyon - Ice | Scalamandre,DWSC-112547,CANYON,ICE,138.00,249.77
+DWA-89161-Sample,Canyon - Mineral | Scalamandre,DWSC-112548,CANYON,MINERAL,138.00,249.77
+DWA-89159-Sample,Canyon - Taupe & Silver | Scalamandre,DWSC-112550,CANYON,TAUPE & SILVER,138.00,249.77
+DWA-89303-Sample,Ch'In Ling - Jade | Scalamandre,DWSC-112457,CH'IN LING,JADE,298.00,539.37
+DWA-89304-Sample,Ch'In Ling - Multicolor On Ivory | Scalamandre,DWSC-112458,CH'IN LING,MULTICOLOR ON IVORY,298.00,539.37
+DWA-89334-Sample,Chinoise Exotique - Ecru | Scalamandre,DWSC-113273,CHINOISE EXOTIQUE,ECRU,225.00,407.24
+DWA-89335-Sample,Chinoise Exotique - Tomato | Scalamandre,DWSC-113272,CHINOISE EXOTIQUE,TOMATO,225.00,407.24
+DWA-89152-Sample,Crosscurrent - White Sand | Scalamandre,DWSC-112552,CROSSCURRENT,WHITE SAND,46.88,84.85
+DWA-89321-Sample,Daphne - Antique White | Scalamandre,DWSC-113216,DAPHNE,ANTIQUE WHITE,126.00,228.05
+DWA-89319-Sample,Daphne - Canton Blue | Scalamandre,DWSC-113214,DAPHNE,CANTON BLUE,126.00,228.05
+DWA-89320-Sample,Daphne - Swedish Blue | Scalamandre,DWSC-113217,DAPHNE,SWEDISH BLUE,126.00,228.05
+DWA-89462-Sample,East India - Bianco / Beige | Scalamandre,DWSC-112876,EAST INDIA - VINYL,BIANCO / BEIGE,210.00,380.09
+DWA-89464-Sample,East India - Bianco / Nero | Scalamandre,DWSC-112875,EAST INDIA - VINYL,BIANCO / NERO,210.00,380.09
+DWA-88356-Sample,Edwin'S Covey - Grisaille | Scalamandre,DWSC-112331,EDWIN'S COVEY,GRISAILLE,154.00,278.73
+DWA-88355-Sample,Edwin'S Covey - Prairie | Scalamandre,DWSC-112330,EDWIN'S COVEY,PRAIRIE,154.00,278.73
+DWA-89242-Sample,Edwin'S Covey - Woodlawn | Scalamandre,DWSC-112333,EDWIN'S COVEY,WOODLAWN,154.00,278.73
+DWA-89114-Sample,Falk Manor House Sisal - Ecru | Scalamandre,DWSC-112421,FALK MANOR HOUSE SISAL,ECRU,117.00,211.76
+DWA-89113-Sample,Falk Manor House Sisal - Pearl | Scalamandre,DWSC-112422,FALK MANOR HOUSE SISAL,PEARL,117.00,211.76
+DWA-88972-Sample,Festival - Mural - Multico | Scalamandre,DWSC-112448,FESTIVAL - MURAL,MULTICO,1614.00,2921.27
+DWA-89143-Sample,Glacier - Champagne | Scalamandre,DWSC-112553,GLACIER,CHAMPAGNE,43.88,79.42
+DWA-89430-Sample,Gru - Grigio | Scalamandre,DWSC-111184,GRU MAGNUS - GRASSCLOTH,GRIGIO,140.00,253.39
+DWA-89045-Sample,Imperio - White | Scalamandre,DWSC-112338,IMPERIO - VINYL,WHITE,50.63,91.64
+DWA-88359-Sample,Lanai - Lagoon | Scalamandre,DWSC-112335,LANAI,LAGOON,154.00,278.73
+DWA-88358-Sample,Lanai - Passionfruit | Scalamandre,DWSC-112334,LANAI,PASSIONFRUIT,154.00,278.73
+DWA-89091-Sample,Lanai - Silver Mist | Scalamandre,DWSC-112336,LANAI,SILVER MIST,154.00,278.73
+DWA-89107-Sample,Luoyang Garden Sisal - Document | Scalamandre,DWSC-112465,LUOYANG GARDEN SISAL,DOCUMENT,192.00,347.51
+DWA-89106-Sample,Luoyang Garden Sisal - Sky | Scalamandre,DWSC-112466,LUOYANG GARDEN SISAL,SKY,1536.00,2780.09
+DWA-89438-Sample,Marble - Botticino | Scalamandre,DWSC-112878,MARBLE - WALLCOVERING,BOTTICINO,645.00,1167.42
+DWA-89434-Sample,Marble - Emperador | Scalamandre,DWSC-112877,MARBLE - WALLCOVERING,EMPERADOR,645.00,1167.42
+DWA-89454-Sample,Marly - Bleu | Scalamandre,DWSC-111164,MARLY - VINYL WALLCOVERING,BLEU,330.00,597.29
+DWA-89453-Sample,Marly - Grigio | Scalamandre,DWSC-111165,MARLY - VINYL WALLCOVERING,GRIGIO,330.00,597.29
+DWA-89456-Sample,Marly - Verde | Scalamandre,DWSC-111163,MARLY - VINYL WALLCOVERING,VERDE,330.00,597.29
+DWA-88382-Sample,Mason Plain - Tan | Scalamandre,DWSC-112325,MASON PLAIN,TAN,26.25,47.51
+DWA-89406-Sample,Melograno Unito - Beige | Scalamandre,DWSC-111200,MELOGRANO UNITO - VINYL,BEIGE,290.00,524.89
+DWA-89405-Sample,Melograno Unito - Celeste | Scalamandre,DWSC-111206,MELOGRANO UNITO - VINYL,CELESTE,290.00,524.89
+DWA-89407-Sample,Melograno Unito - Cielo | Scalamandre,DWSC-111205,MELOGRANO UNITO - VINYL,CIELO,290.00,524.89
+DWA-89410-Sample,Melograno Unito - Giallino | Scalamandre,DWSC-111202,MELOGRANO UNITO - VINYL,GIALLINO,290.00,524.89
+DWA-89403-Sample,Melograno Unito - Grigio | Scalamandre,DWSC-111208,MELOGRANO UNITO - VINYL,GRIGIO,290.00,524.89
+DWA-89411-Sample,Melograno Unito - Magnolia | Scalamandre,DWSC-111201,MELOGRANO UNITO - VINYL,MAGNOLIA,290.00,524.89
+DWA-89409-Sample,Melograno Unito - Rosso | Scalamandre,DWSC-111203,MELOGRANO UNITO - VINYL,ROSSO,290.00,524.89
+DWA-89408-Sample,Melograno Unito - Tea | Scalamandre,DWSC-111204,MELOGRANO UNITO - VINYL,TEA,290.00,524.89
+DWA-89404-Sample,Melograno Unito - Verde | Scalamandre,DWSC-111207,MELOGRANO UNITO - VINYL,VERDE,290.00,524.89
+DWA-89341-Sample,Mikonos - Blue & Green | Scalamandre,DWSC-113267,MIKONOS,BLUE & GREEN,424.00,767.42
+DWA-89342-Sample,Mikonos - Blue & Yellow | Scalamandre,DWSC-113266,MIKONOS,BLUE & YELLOW,424.00,767.42
+DWA-89339-Sample,Mikonos - Green & Eggshell | Scalamandre,DWSC-113269,MIKONOS,GREEN & EGGSHELL,424.00,767.42
+DWA-89340-Sample,Mikonos - Ochres & Aqua | Scalamandre,DWSC-113268,MIKONOS,OCHRES & AQUA,424.00,767.42
+DWA-89338-Sample,Mikonos - Rust & Blue | Scalamandre,DWSC-113270,MIKONOS,RUST & BLUE,424.00,767.42
+DWA-89330-Sample,Ming Circus - Multi On Beige | Scalamandre,DWSC-113259,MING CIRCUS,MULTI ON BEIGE,504.00,912.22
+DWA-89329-Sample,Ming Circus - Multi On Pollen | Scalamandre,DWSC-113260,MING CIRCUS,MULTI ON POLLEN,504.00,912.22
+DWA-82594-Sample,Ming Fretwork - Alabaster | Scalamandre,DWSC-112834,MING FRETWORK WALLCOVERING,ALABASTER,88.00,159.28
+DWA-82593-Sample,Ming Fretwork - Aquamarine | Scalamandre,DWSC-112836,MING FRETWORK WALLCOVERING,AQUAMARINE,88.00,159.28
+DWA-82592-Sample,Ming Fretwork - Silver | Scalamandre,DWSC-112838,MING FRETWORK WALLCOVERING,SILVER - PEARLESCENT,88.00,159.28
+DWA-89105-Sample,Monroe Embroidered Grasscloth - Glacier | Scalamandre,DWSC-112425,MONROE EMBROIDERED GRASSCLOTH,GLACIER,168.00,304.07
+DWA-89104-Sample,Monroe Embroidered Grasscloth - Papyrus | Scalamandre,DWSC-112426,MONROE EMBROIDERED GRASSCLOTH,PAPYRUS,168.00,304.07
+DWA-89156-Sample,Pacific Stripe - Champagne | Scalamandre,DWSC-112555,PACIFIC STRIPE,CHAMPAGNE,130.00,235.29
+DWA-89157-Sample,Pacific Stripe - Ice | Scalamandre,DWSC-112556,PACIFIC STRIPE,ICE,130.00,235.29
+DWA-89155-Sample,Pacific Stripe - Sky | Scalamandre,DWSC-112557,PACIFIC STRIPE,SKY,130.00,235.29
+DWA-89154-Sample,Pacific Stripe - Taupe & Silver | Scalamandre,DWSC-112558,PACIFIC STRIPE,TAUPE & SILVER,130.00,235.29
+DWA-89119-Sample,Primavera - French Grey | Scalamandre,DWSC-112468,PRIMAVERA,FRENCH GREY,70.00,126.70
+DWA-89145-Sample,Rainshadow - Blue Ice | Scalamandre,DWSC-112562,RAINSHADOW,BLUE ICE,130.00,235.29
+DWA-89146-Sample,Rainshadow - Champagne | Scalamandre,DWSC-112560,RAINSHADOW,CHAMPAGNE,130.00,235.29
+DWA-89147-Sample,Rainshadow - Silver | Scalamandre,DWSC-112561,RAINSHADOW,SILVER,130.00,235.29
+DWA-89428-Sample,Sagano - Beige | Scalamandre,DWSC-112408,SAGANO - GRASSCLOTH,BEIGE,140.00,253.39
+DWA-89427-Sample,Sagano - Bronzo | Scalamandre,DWSC-112409,SAGANO - GRASSCLOTH,BRONZO,140.00,253.39
+DWA-89426-Sample,Sagano - Giallo | Scalamandre,DWSC-112410,SAGANO - GRASSCLOTH,GIALLO,140.00,253.39
+DWA-89425-Sample,Sagano - Grigio | Scalamandre,DWSC-112411,SAGANO - GRASSCLOTH,GRIGIO,140.00,253.39
+DWA-89424-Sample,Sagano - Verde | Scalamandre,DWSC-112412,SAGANO - GRASSCLOTH,VERDE,140.00,253.39
+DWA-89332-Sample,Shanghai - Multi On Tea Stain | Scalamandre,DWSC-113255,SHANGHAI WALLCOVERING,MULTI ON TEA STAIN,295.00,533.94
+DWA-89331-Sample,Shanghai - Multi On Tea Stain | Scalamandre,DWSC-113255,SHANGHAI WALLCOVERING,MULTI ON TEA STAIN,295.00,533.94
+DWA-89118-Sample,Shantung Garden - Bloom | Scalamandre,DWSC-112470,SHANTUNG GARDEN,BLOOM,142.00,257.01
+DWA-89382-Sample,Sisal - Acorn | Scalamandre,DWSC-112618,SISAL,ACORN,282.00,510.41
+DWA-89374-Sample,Sisal - Azure | Scalamandre,DWSC-112625,SISAL,AZURE,282.00,510.41
+DWA-89384-Sample,Sisal - Biscuit | Scalamandre,DWSC-112616,SISAL,BISCUIT,282.00,510.41
+DWA-89310-Sample,Sisal - Blue Heather | Scalamandre,DWSC-112640,SISAL,BLUE HEATHER,282.00,510.41
+DWA-89176-Sample,Sisal - Blush | Scalamandre,DWSC-112643,SISAL,BLUSH,282.00,510.41
+DWA-89175-Sample,Sisal - Brass | Scalamandre,DWSC-112644,SISAL,BRASS,282.00,510.41
+DWA-89178-Sample,Sisal - Caribbean | Scalamandre,DWSC-112639,SISAL,CARIBBEAN,282.00,510.41
+DWA-89179-Sample,Sisal - Celestial | Scalamandre,DWSC-112638,SISAL,CELESTIAL,282.00,510.41
+DWA-89368-Sample,Sisal - Cilantro | Scalamandre,DWSC-112631,SISAL,CILANTRO,282.00,510.41
+DWA-89372-Sample,Sisal - Cottage | Scalamandre,DWSC-112627,SISAL,COTTAGE,282.00,510.41
+DWA-89309-Sample,Sisal - Dusk | Scalamandre,DWSC-112641,SISAL,DUSK,282.00,510.41
+DWA-89365-Sample,Sisal - Imperial | Scalamandre,DWSC-112633,SISAL,IMPERIAL,282.00,510.41
+DWA-89385-Sample,Sisal - Meringue | Scalamandre,DWSC-112615,SISAL,MERINGUE,282.00,510.41
+DWA-89379-Sample,Sisal - Oxide | Scalamandre,DWSC-112620,SISAL,OXIDE,282.00,510.41
+DWA-89311-Sample,Sisal - Pale Jade | Scalamandre,DWSC-112637,SISAL,PALE JADE,282.00,510.41
+DWA-89366-Sample,Sisal - Royalty | Scalamandre,DWSC-112632,SISAL,ROYALTY,282.00,510.41
+DWA-89381-Sample,Sisal - Sequoia | Scalamandre,DWSC-112619,SISAL,SEQUOIA,282.00,510.41
+DWA-89376-Sample,Sisal - Steeple | Scalamandre,DWSC-112623,SISAL,STEEPLE,282.00,510.41
+DWA-89383-Sample,Sisal - Wheat | Scalamandre,DWSC-112617,SISAL,WHEAT,282.00,510.41
+DWA-89377-Sample,Sisal - Whisper | Scalamandre,DWSC-112622,SISAL,WHISPER,282.00,510.41
+DWA-89423-Sample,Sogi - Avorio | Scalamandre,DWSC-112414,SOGI - VINYL WALLCOVERING,AVORIO,265.00,479.64
+DWA-89419-Sample,Sogi - Blu | Scalamandre,DWSC-112416,SOGI - VINYL WALLCOVERING,BLU,265.00,479.64
+DWA-89420-Sample,Sogi - Rosso | Scalamandre,DWSC-112415,SOGI - VINYL WALLCOVERING,ROSSO,265.00,479.64
+DWA-89418-Sample,Sogi - Verde | Scalamandre,DWSC-112413,SOGI - VINYL WALLCOVERING,VERDE,265.00,479.64
+DWA-82591-Sample,Summer Palace - Porcelain | Scalamandre,DWSC-112840,SUMMER PALACE,PORCELAIN,144.00,260.63
+DWA-89116-Sample,Surat Sisal - Burnished Gold On Mineral | Scalamandre,DWSC-112429,SURAT SISAL,BURNISHED GOLD ON MINERAL,104.00,188.24
+DWA-89133-Sample,Suzhou Lattice - Alabaster | Scalamandre,DWSC-111305,SUZHOU LATTICE,ALABASTER,24.75,44.80
+DWA-89131-Sample,Suzhou Lattice - Aquamarine | Scalamandre,DWSC-111304,SUZHOU LATTICE,AQUAMARINE,24.75,44.80
+DWA-89274-Sample,Suzhou Lattice - French Grey | Scalamandre,DWSC-111306,SUZHOU LATTICE,FRENCH GREY,24.75,44.80
+DWA-89128-Sample,Suzhou Lattice Raffia Weave - Straw | Scalamandre,,SUZHOU LATTICE RAFFIA WEAVE,STRAW,857.00,1551.13
+DWA-89126-Sample,Suzhou Lattice Sisal - Mineral | Scalamandre,DWSC-112435,SUZHOU LATTICE SISAL,MINERAL,104.00,188.24
+DWA-89272-Sample,Suzhou Lattice Sisal - Silver On Pewter | Scalamandre,DWSC-112436,SUZHOU LATTICE SISAL,SILVER ON PEWTER,104.00,188.24
+DWA-89139-Sample,Tortoiseshell - Champagne | Scalamandre,DWSC-112564,TORTOISESHELL,CHAMPAGNE,138.00,249.77
+DWA-89138-Sample,Tortoiseshell - Pewter | Scalamandre,DWSC-112563,TORTOISESHELL,PEWTER,138.00,249.77
+DWA-89101-Sample,Veronica Beaded Grasscloth - Burnished Gold | Scalamandre,DWSC-112438,VERONICA BEADED GRASSCLOTH,BURNISHED GOLD,370.00,669.68
+DWA-89265-Sample,Veronica Beaded Grasscloth - Carbon | Scalamandre,DWSC-112440,VERONICA BEADED GRASSCLOTH,CARBON,370.00,669.68
+DWA-89346-Sample,Zebras - Black & Silver | Scalamandre Wallcovering | Scalamandre,DWSC-112183,ZEBRAS | VINYL,BLACK & SILVER,316.00,571.95
diff --git a/data/scalamandre-reconcile.md b/data/scalamandre-reconcile.md
new file mode 100644
index 0000000..870d204
--- /dev/null
+++ b/data/scalamandre-reconcile.md
@@ -0,0 +1,37 @@
+# TK-10978 — Scalamandre identity-reconciliation (read-only feasibility) · 2026-08-30
+
+The Scalamandre live line (`DWA-*`, mfr `wp#####`) and `scalamandre_catalog` (`DWSC-*`,
+mfr `SCWP#####`) have divergent SKU identities, so the SKU-join yields 0 (unlike Wolf
+Gordon). But the catalog carries clean `pattern_name` + `color_name`, and the live titles
+carry `Pattern - Color` — so a **semantic (content) match** bridges the gap.
+
+## Method
+Normalize live title → (pattern = before first ` - `, color = last segment before ` | `);
+match against catalog wallcovering rows (excl. pillows) on pattern⊇ + color⊇; keep only
+UNIQUE (n=1) matches. Retail = `price_trade / 0.65 / 0.85`.
+
+## Result (474 unbuyable Scalamandre)
+| Bucket | Count | % | Disposition |
+|---|---:|---:|---|
+| **Unique match** | **133** | 28% | recoverable — high precision (**8/8 spot-checks exact**) |
+| Ambiguous (multi-match) | 38 | 8% | needs disambiguation (multiple colorways) |
+| No match | 303 | 64% | not in the costed catalog → cost-sourcing |
+
+## Verified facts
+- **Precision**: 8/8 sampled unique matches were exact (Suzhou Lattice/Aquamarine,
+ Sisal/Wheat, Mikonos/Blue & Green, Chinoise Exotique/Tomato, …).
+- **Recovery action = ADD-ROLL** (not restructure): live Shopify GET on 3 confirmed all
+ 133 are genuinely **sample-only** ($4.25 lone Sample) → add a "Sold Per Roll" variant at
+ the reconciled cost, keep the $4.25 Sample. (Different from WG, which was the RR-defect.)
+- Dry-run match list: `data/scalamandre-reconcile-dryrun.csv` (133 rows,
+ shopify_sku → catalog_dw_sku → price_trade → computed_retail).
+
+## Residual risk (fold this into any execution)
+The match uses substring `LIKE` — only 8 of 133 were eyeballed. A wrong colorway match =
+a wrong customer-facing price. Before pricing: tighten substring→**exact** normalized
+match, and **live-verify each product + its match** (VERIFY-BEFORE-ACT). Recommend a small
+pilot (≈20) first, like the WG rollout.
+
+**Status:** feasibility PROVEN + gated recovery drafted to pending-approval (route
+vp-dw-commerce). Not executed. 38 ambiguous + 303 no-match remain (disambiguation /
+cost-sourcing).
← 4f00877 TK-10875: next-cohort scan — WG was the only bounded recover
·
back to Dw Unbuyable Recovery Pilot
·
auto-data-snapshot: 2026-08-30T17:49:20 (1 data files) — dat 8408ecf →