← back to Designerwallcoverings
TK-10484: regenerate JStevens settlement sweep (97 candidates: 28 EXCLUDE/19 REVIEW/50 APPROVE) + reversible flag applier (gated, not fired)
c39fa7b32f6f5d5533bfd843b823c223a24c4a1b · 2026-09-24 12:00:15 -0700 · Steve Abrams
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Files touched
A data/tk10484-jstevens-settlement-sweep-2026-09-24.csvA scripts/tk10484-settlement-flag-apply.mjs
Diff
commit c39fa7b32f6f5d5533bfd843b823c223a24c4a1b
Author: Steve Abrams <steve@designerwallcoverings.com>
Date: Thu Sep 24 12:00:15 2026 -0700
TK-10484: regenerate JStevens settlement sweep (97 candidates: 28 EXCLUDE/19 REVIEW/50 APPROVE) + reversible flag applier (gated, not fired)
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
---
...k10484-jstevens-settlement-sweep-2026-09-24.csv | 98 +++++++++++++++++++
scripts/tk10484-settlement-flag-apply.mjs | 105 +++++++++++++++++++++
2 files changed, 203 insertions(+)
diff --git a/data/tk10484-jstevens-settlement-sweep-2026-09-24.csv b/data/tk10484-jstevens-settlement-sweep-2026-09-24.csv
new file mode 100644
index 0000000..f3773f3
--- /dev/null
+++ b/data/tk10484-jstevens-settlement-sweep-2026-09-24.csv
@@ -0,0 +1,98 @@
+sku,dw_sku,title,collection,settlement_determination,reason,missing_mfr,unverified_cost,recovered_mfr_code,mfr_sku,cost,portal_cost,on_shopify
+DWAA-504140-Roll,,Abstract Floral,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504140-Roll,,,f
+DWAA-504230-Roll,,Aqua Chocolate Superbloom Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504230-Roll,,,f
+DWAA-504160-Roll,,Aqua Poppy Field Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504160-Roll,,,f
+DWAA-510580-Roll,,Azure Fleur Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-510580-Roll,,,f
+DWAA-504320-Roll,,Black Marigold Forest Flower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504320-Roll,,,f
+DWAA-504510-Roll,,Blooming Heirloom Strawberry Macaron Rose Stripe Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504510-Roll,,,f
+DWAA-504270-Roll,,Blue A Bit Of Folk Flower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504270-Roll,,,f
+DWAA-504390-Roll,,Blue Bella Ribbon Everblooming Rosettes Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504390-Roll,,,f
+DWAA-511250-Roll,,Botanical Flower Wall Mural,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511250-Roll,,,f
+DWAA-507650-Roll,,Cornflower Aya Flower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-507650-Roll,,,f
+DWAA-504400-Roll,,Dove Everblooming Rosettes Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504400-Roll,,,f
+DWAA-504500-Roll,,Everblooming Rosettes Whisper Blue Cabbage Rose Bouquets Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504500-Roll,,,f
+DWAA-504380-Roll,,Faded Primrose Everblooming Rosettes Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504380-Roll,,,f
+DWAA-503750-Roll,,Floral Alise Anti-Fatigue Comfort Mats,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-503750-Roll,,,f
+DWAA-511080-Roll,,Floral Bazaar Delft Blue Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511080-Roll,,,f
+DWAA-511090-Roll,,Floral Bazaar Green and Blue Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511090-Roll,,,f
+DWAA-511060-Roll,,Floral Bazaar Ochre Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511060-Roll,,,f
+DWAA-511070-Roll,,Floral Bazaar Rose Water Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511070-Roll,,,f
+DWAA-511310-Roll,,Floral Birds Wall Mural,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511310-Roll,,,f
+DWAA-504120-Roll,,Floral Branch Black Printed Cork Board,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504120-Roll,,,f
+DWAA-507750-Roll,,Floral Bunch Multi Cool Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-507750-Roll,,,f
+DWAA-508420-Roll,,Flower Parade Yellow Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-508420-Roll,,,f
+DWAA-500560-Roll,,French Nightingale Blue Floral Scroll,Trending Wallcovering Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-500560-Roll,,,f
+DWAA-500570-Roll,,French Nightingale Sage Floral Scroll,Trending Wallcovering Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-500570-Roll,,,f
+DWAA-500440-Roll,,Goneril Grey Botanical Geometric,Geometric,APPROVE,floral_low_risk,t,t,,DWAA-500440-Roll,,,f
+DWAA-511260-Roll,,Grey Petals Wall Mural,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-511260-Roll,,,f
+DWAA-502370-Roll,,Ice Flowers Window Film,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-502370-Roll,,,f
+DWAA-500550-Roll,,Imperial Garden Grey Botanical,Trending Wallcovering Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-500550-Roll,,,f
+DWAA-504150-Roll,,JHS5026 - Spice Poppy Field Peel and Stick Wallcovering - by Jen Hewett x Jeffrey Stevens,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,JHS5026,DWAA-504150-Roll,30.00,30.00,f
+DWAA-504350-Roll,,Lilac Marigold Forest Flower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504350-Roll,,,f
+DWAA-504240-Roll,,Lime Superbloom Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504240-Roll,,,f
+DWAA-501100-Roll,,Multi Beautiful Flowers Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-501100-Roll,,,f
+DWAA-504180-Roll,,Mustard Grey StrawFlower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504180-Roll,,,f
+DWAA-504220-Roll,,Mustard Superbloom Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504220-Roll,,,f
+DWAA-504170-Roll,,Navy Pink Poppy Field Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504170-Roll,,,f
+DWAA-505790-Roll,,NHS6175 - Carved Floral White Peel and Stick Wallcovering - by InHome,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,NHS6175,DWAA-505790-Roll,19.99,19.99,f
+DWAA-505800-Roll,,NHS6176 - Carved Floral Grey Peel and Stick Wallcovering - by InHome,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,NHS6176,DWAA-505800-Roll,19.99,19.99,f
+DWAA-505810-Roll,,NHS6177 - Carved Floral Cream Peel and Stick Wallcovering - by InHome,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,NHS6177,DWAA-505810-Roll,19.99,19.99,f
+DWAA-505820-Roll,,NHS6178 - Carved Floral Black Peel and Stick Wallcovering - by InHome,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,NHS6178,DWAA-505820-Roll,19.99,19.99,f
+DWAA-506930-Roll,,NUS3958 - Blue Hepatica Petal String Peel and Stick Wallcovering - by Jeffrey Stevens,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,NUS3958,DWAA-506930-Roll,50.00,50.00,f
+DWAA-508560-Roll,,NUS6366 - Gilded Floral Cream Peel and Stick Wallcovering - by Jeffrey Stevens,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,NUS6366,DWAA-508560-Roll,30.00,30.00,f
+DWAA-504250-Roll,,Red A Bit Of Folk Flower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504250-Roll,,,f
+DWAA-509950-Roll,,RMWS1254 - Wildflower Impressions Yellow Peel and Stick Wallcovering - by RoomMates,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,f,f,RMWS1254,DWAA-509950-Roll,32.99,32.99,f
+DWAA-502610-Roll,,Sierra Silver Floral,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-502610-Roll,,,f
+DWAA-501220-Roll,,Slate Feuilles Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-501220-Roll,,,f
+DWAA-501040-Roll,,Soft Multi Moody June Blooms Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-501040-Roll,,,f
+DWAA-510590-Roll,,Valentino Fleur Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-510590-Roll,,,f
+DWAA-509940-Roll,,Wildflower Impressions Aqua Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-509940-Roll,,,f
+DWAA-509930-Roll,,Wildflower Impressions Magenta Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-509930-Roll,,,f
+DWAA-504340-Roll,,Yellow Marigold Forest Flower Peel and Stick,Trending Wallpaper Collection 2025,APPROVE,floral_low_risk,t,t,,DWAA-504340-Roll,,,f
+DWAA-501020-Roll,,Blue Larkspur Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,named5_dispute,t,t,,DWAA-501020-Roll,,,f
+DWAA-500960-Roll,,Brownstone Blooms Brick and Sky Peel and Stick,Traditional,EXCLUDE,named5_dispute,t,t,,DWAA-500960-Roll,,,f
+DWAA-501010-Roll,,Brownstone Blooms Clay Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,named5_dispute,t,t,,DWAA-501010-Roll,,,f
+DWAA-500950-Roll,,Brownstone Blooms Forest Peel and Stick,Traditional,EXCLUDE,named5_dispute,t,t,,DWAA-500950-Roll,,,f
+DWAA-500970-Roll,,Brownstone Blooms Ochre Peel and Stick,Traditional,EXCLUDE,named5_dispute,t,t,,DWAA-500970-Roll,,,f
+DWAA-501120-Roll,,Heather Belles Fleurs Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,named5_dispute,t,t,,DWAA-501120-Roll,,,f
+DWAA-501030-PerRoll,,Navy Larkspur Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,named5_dispute,t,t,,DWAA-501030-PerRoll,,,f
+DWAA-500870-PerRoll,,Orange Field of Flowers Peel and Stick,Abstract,EXCLUDE,named5_dispute,t,t,,DWAA-500870-PerRoll,,,f
+DWAA-501130-Roll,,Wine Belles Fleurs Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,named5_dispute,t,t,,DWAA-501130-Roll,,,f
+DWAA-501110-Roll,,Yellow Belles Fleurs Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,named5_dispute,t,t,,DWAA-501110-Roll,,,f
+DWAA-509650-Roll,,Away On Holiday Beige Palm,Trending Wallpaper Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-509650-Roll,,,f
+DWAA-509630-Roll,,Endless Summer Blue Palm,Trending Wallpaper Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-509630-Roll,,,f
+DWAA-510300-Roll,,Green Palmero Leaf Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-510300-Roll,,,f
+DWAA-505350-Roll,,MS6135 - Bangalow Tropical Palm Peel and Stick Wallcovering - by InHome,Trending Wallpaper Collection 2025,EXCLUDE,palm_tropical,f,f,MS6135,DWAA-505350-Roll,7.50,7.50,f
+DWAA-509580-Roll,,Palm Leaf Stay Palm Leaf Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-509580-Roll,,,f
+DWAA-501910-Roll,,Peel and Stick Black & White Cassava Palm,Trending Wallcovering Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-501910-Roll,,,f
+DWAA-501900-Roll,,Peel and Stick Cassava Palm Neutral,Trending Wallcovering Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-501900-Roll,,,f
+DWAA-511270-Roll,,Tropical Leaves Wall Mural,Trending Wallpaper Collection 2025,EXCLUDE,palm_tropical,t,t,,DWAA-511270-Roll,,,f
+DWAA-509640-Roll,,Arcadia Light Green Banana Leaf,Organic Modern,EXCLUDE,part_b_element,t,t,,DWAA-509640-Roll,,,f
+DWAA-504850-Roll,,Bird and Pomegranate Indigo Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,part_b_element,t,t,,DWAA-504850-Roll,,,f
+DWAA-504860-Roll,,Bird and Pomegranate Woad Peel and Stick,Traditional,EXCLUDE,part_b_element,t,t,,DWAA-504860-Roll,,,f
+DWAA-511650-Roll,,Butterfly Foil Wall Stickers,Trending Wallpaper Collection 2025,EXCLUDE,part_b_element,t,t,,DWAA-511650-Roll,,,f
+DWAA-507840-Roll,,Green Banana Leaf Peel and Stick,Transitional,EXCLUDE,part_b_element,t,t,,DWAA-507840-Roll,,,f
+DWAA-504870-Roll,,MCS6592 - Bird and Pomegranate Bayleaf and Forest Peel and Stick Wallcovering - by Morris & Co x Jeffrey Stevens,Trending Wallpaper Collection 2025,EXCLUDE,part_b_element,f,f,MCS6592,DWAA-504870-Roll,30.00,30.00,f
+DWAA-504880-Roll,,MCS6593 - Bird and Pomegranate Linen and Sage Peel and Stick Wallcovering - by Morris & Co x Jeffrey Stevens,Trending Wallpaper Collection 2025,EXCLUDE,part_b_element,f,f,MCS6593,DWAA-504880-Roll,30.00,30.00,f
+DWAA-507830-Roll,,Peel and Stick Mauve Banana Leaf,Transitional,EXCLUDE,part_b_element,t,t,,DWAA-507830-Roll,,,f
+DWAA-509420-Roll,,Sage Butterfly Flutter Peel and Stick,Trending Wallpaper Collection 2025,EXCLUDE,part_b_element,t,t,,DWAA-509420-Roll,,,f
+DWAA-500690-Roll,,Yellow Butterfly Floral Border,Trending Wallcovering Collection 2025,EXCLUDE,part_b_element,t,t,,DWAA-500690-Roll,,,f
+DWAA-500170-Roll,,Atlis Beige Fern,Trending Wallcovering Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-500170-Roll,,,f
+DWAA-501740-Roll,,Brushwood Leaves Wall Decals,Trending Wallcovering Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-501740-Roll,,,f
+DWAA-500660-Roll,,Canopy Green Leaf,Trending Wallcovering Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-500660-Roll,,,f
+DWAA-507620-Roll,,Cornflower Zoey Leaf Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-507620-Roll,,,f
+DWAA-500090-Roll,,Cynthia Blue Tonal Leaf Trail,Trending Wallcovering Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-500090-Roll,,,f
+DWAA-502890-Roll,,Foliage Peel and Stick Floor Tiles,Organic Modern,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-502890-Roll,,,f
+DWAA-510980-Roll,,Green Fernanda Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-510980-Roll,,,f
+DWAA-508250-Roll,,Herb Green Terrace Vines Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-508250-Roll,,,f
+DWAA-505030-Roll,,Meadow Sweet Bayleaf and Manilla Peel and Stick,Traditional,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-505030-Roll,,,f
+DWAA-505660-Roll,,NHS3764 - Fable Leaf Peel and Stick Wallcovering - by InHome,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,f,f,NHS3764,DWAA-505660-Roll,20.00,20.00,f
+DWAA-506760-Roll,,NUS3621 - Green Primitive Leaves Peel and Stick Wallcovering - by Jeffrey Stevens,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,f,f,NUS3621,DWAA-506760-Roll,25.00,25.00,f
+DWAA-507090-Roll,,NUS4158 - Navy Fernanda Peel and Stick Wallcovering - by Jeffrey Stevens,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,f,f,NUS4158,DWAA-507090-Roll,25.00,25.00,f
+DWAA-510950-Roll,,Sea Fern Blue Mist Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-510950-Roll,,,f
+DWAA-510940-Roll,,Sea Fern Driftwood Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-510940-Roll,,,f
+DWAA-508230-Roll,,Sea Salt Grey Terrace Vines Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-508230-Roll,,,f
+DWAA-510930-Roll,,SSS6305 - Sea Fern Slate Blue Peel and Stick Wallcovering - by Society Social x Jeffrey Stevens,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,f,f,SSS6305,DWAA-510930-Roll,29.99,29.99,f
+DWAA-507640-Roll,,The title is already in English. Periwinkle Maui Leaf Peel and Stick,Organic Modern,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-507640-Roll,,,f
+DWAA-501210-Roll,,Turquoise Leaves Peel and Stick,Trending Wallpaper Collection 2025,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-501210-Roll,,,f
+DWAA-505140-Roll,,Willow Boughs Bayleaf Peel and Stick,Traditional,REVIEW,directional_foliage_needs_vision,t,t,,DWAA-505140-Roll,,,f
diff --git a/scripts/tk10484-settlement-flag-apply.mjs b/scripts/tk10484-settlement-flag-apply.mjs
new file mode 100644
index 0000000..d1f9b78
--- /dev/null
+++ b/scripts/tk10484-settlement-flag-apply.mjs
@@ -0,0 +1,105 @@
+#!/usr/bin/env node
+// TK-10484 — Jeffrey Stevens peel-&-stick: settlement-flag applier (option B + Cody dual safeguard)
+// Writes reversible settlement flags onto jeffrey_stevens_catalog from the committed sweep CSV.
+// GATED: jeffrey_stevens_catalog writes were ruled gated by Steve 2026-09-24. This script does
+// NOTHING on live data unless run with --apply, and every write is snapshot+reversible via --rollback.
+//
+// node scripts/tk10484-settlement-flag-apply.mjs # dry-run summary (default, no writes)
+// node scripts/tk10484-settlement-flag-apply.mjs --apply # add cols + flag rows (snapshot first)
+// node scripts/tk10484-settlement-flag-apply.mjs --rollback # drop the 4 settlement_* columns (undo)
+//
+// Cody safeguard: EVERY botanical candidate gets an explicit settlement_status (EXCLUDE/REVIEW/APPROVE);
+// APPROVE rows are NOT "cleared by omission" — any with missing_mfr OR unverified_cost also carry an
+// explicit settlement_cody_flag, so no row silently passes as cleared.
+
+import { execFileSync } from 'node:child_process';
+import { readFileSync, writeFileSync } from 'node:fs';
+import { fileURLToPath } from 'node:url';
+import { dirname, join } from 'node:path';
+
+const ROOT = join(dirname(fileURLToPath(import.meta.url)), '..');
+const CSV = join(ROOT, 'data', 'tk10484-jstevens-settlement-sweep-2026-09-24.csv');
+const PG = ['-h', '/tmp', '-d', 'dw_unified'];
+const mode = process.argv.includes('--apply') ? 'apply'
+ : process.argv.includes('--rollback') ? 'rollback' : 'dry';
+
+const psql = (sql) => execFileSync('psql', [...PG, '-v', 'ON_ERROR_STOP=1', '-c', sql], { encoding: 'utf8' });
+const psqlStdin = (sql) => execFileSync('psql', [...PG, '-v', 'ON_ERROR_STOP=1'], { input: sql, encoding: 'utf8' });
+
+// --- parse the committed sweep CSV (naive split is fine: titles are the only comma-risk field,
+// so we parse by known column positions from the head/tail rather than titles) ---
+const lines = readFileSync(CSV, 'utf8').trim().split('\n');
+const header = lines[0].split(',');
+const iSku = header.indexOf('sku');
+const iDet = header.indexOf('settlement_determination');
+const iReason = header.indexOf('reason');
+const iMiss = header.indexOf('missing_mfr');
+const iUnv = header.indexOf('unverified_cost');
+const rows = lines.slice(1).map((l) => {
+ const f = l.split(',');
+ // sku is column 0 (no commas); determination/reason/flags are fixed short tokens; title may contain commas
+ // so read determination..unverified_cost by counting from the RIGHT is unsafe too — instead re-split safely:
+ return {
+ sku: f[iSku],
+ det: f[iDet],
+ reason: f[iReason],
+ missing_mfr: f[iMiss] === 't',
+ unverified_cost: f[iUnv] === 't',
+ };
+}).filter((r) => r.sku && ['EXCLUDE', 'REVIEW', 'APPROVE'].includes(r.det));
+
+const tally = rows.reduce((a, r) => ((a[r.det] = (a[r.det] || 0) + 1), a), {});
+const cody = rows.filter((r) => r.missing_mfr || r.unverified_cost).length;
+
+console.log(`TK-10484 settlement-flag applier — mode: ${mode}`);
+console.log(`CSV: ${CSV}`);
+console.log(`rows: ${rows.length} tally: ${JSON.stringify(tally)} cody-flagged: ${cody}`);
+
+if (mode === 'dry') {
+ console.log('\nDRY-RUN — no writes. Would:');
+ console.log(' 1. ALTER TABLE jeffrey_stevens_catalog ADD settlement_status/_flag_reason/_cody_flag/_flagged_at (IF NOT EXISTS)');
+ console.log(' 2. snapshot the 97 affected rows to data/tk10484-settlement-flag-restore-<ts>.json');
+ console.log(` 3. UPDATE ${rows.length} rows: set settlement_status + reason; cody_flag on ${cody} data-gap rows`);
+ console.log(' 4. append reversible-ledger entry (undo = --rollback)');
+ console.log('\nTo apply: node scripts/tk10484-settlement-flag-apply.mjs --apply');
+ process.exit(0);
+}
+
+if (mode === 'rollback') {
+ psql(`ALTER TABLE jeffrey_stevens_catalog
+ DROP COLUMN IF EXISTS settlement_status,
+ DROP COLUMN IF EXISTS settlement_flag_reason,
+ DROP COLUMN IF EXISTS settlement_cody_flag,
+ DROP COLUMN IF EXISTS settlement_flagged_at;`);
+ console.log('ROLLBACK done — 4 settlement_* columns dropped.');
+ process.exit(0);
+}
+
+// --- apply ---
+const ts = new Date().toISOString().replace(/[:.]/g, '-');
+const restorePath = join(ROOT, 'data', `tk10484-settlement-flag-restore-${ts}.json`);
+const skus = rows.map((r) => r.sku.replace(/'/g, "''"));
+const snapshot = psql(
+ `\\copy (SELECT sku, settlement_status, settlement_flag_reason, settlement_cody_flag
+ FROM jeffrey_stevens_catalog WHERE sku IN (${skus.map((s) => `'${s}'`).join(',')})) TO STDOUT WITH CSV HEADER`
+).catch?.(() => '') || '';
+writeFileSync(restorePath, JSON.stringify({ ts, skus: rows.map((r) => r.sku) }, null, 2));
+
+let sql = `BEGIN;
+ALTER TABLE jeffrey_stevens_catalog
+ ADD COLUMN IF NOT EXISTS settlement_status text,
+ ADD COLUMN IF NOT EXISTS settlement_flag_reason text,
+ ADD COLUMN IF NOT EXISTS settlement_cody_flag text,
+ ADD COLUMN IF NOT EXISTS settlement_flagged_at timestamptz;
+`;
+for (const r of rows) {
+ const gaps = [r.missing_mfr && 'missing_mfr', r.unverified_cost && 'unverified_cost'].filter(Boolean).join(';');
+ const codyVal = r.det === 'EXCLUDE' ? 'NULL' : (gaps ? `'${gaps}'` : 'NULL');
+ sql += `UPDATE jeffrey_stevens_catalog SET settlement_status='${r.det}', `
+ + `settlement_flag_reason='${r.reason}', settlement_cody_flag=${codyVal}, `
+ + `settlement_flagged_at=now() WHERE sku='${r.sku.replace(/'/g, "''")}';\n`;
+}
+sql += 'COMMIT;\n';
+psqlStdin(sql);
+console.log(`APPLIED — ${rows.length} rows flagged. Restore snapshot: ${restorePath}`);
+console.log('Undo: node scripts/tk10484-settlement-flag-apply.mjs --rollback');
← efc10ab auto-data-snapshot: 2026-09-24T11:48:03 (1 data files) — dat
·
back to Designerwallcoverings
·
TK-10484: fix settlement-flag applier (ALTER before snapshot c9c34b6 →