fix DWTT73434 (recordId 536611) Mfr Pattern AT79129->AT79126 + fill mfr pattern number (AT79129 belongs to 73436 Silver)

94f5487ead2b81dd49f91394ad98cf4fa56b52b8 · 2026-07-01 15:45:46 -0700 · Steve Abrams

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>

Files touched

A scripts/fix-dwtt73434-mfr.mjs

Diff

commit 94f5487ead2b81dd49f91394ad98cf4fa56b52b8
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Jul 1 15:45:46 2026 -0700

    fix DWTT73434 (recordId 536611) Mfr Pattern AT79129->AT79126 + fill mfr pattern number (AT79129 belongs to 73436 Silver)
    
    Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
---
 scripts/fix-dwtt73434-mfr.mjs | 47 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 47 insertions(+)

diff --git a/scripts/fix-dwtt73434-mfr.mjs b/scripts/fix-dwtt73434-mfr.mjs
new file mode 100644
index 0000000..d6ce4d8
--- /dev/null
+++ b/scripts/fix-dwtt73434-mfr.mjs
@@ -0,0 +1,47 @@
+// One-off: fix wrong mfr pattern on WALLPAPER recordId 536611 (DWTT73434, Baxter Aqua and Taupe).
+// "Mfr Pattern" was "AT79129" (that code belongs to 73436 Silver); correct = "AT79126"
+// per dw_unified.thibaut_catalog. Also fills "mfr pattern number" (was empty).
+// Usage: node scripts/fix-dwtt73434-mfr.mjs [--commit]   (default = dry-run diff)
+
+import { readFileSync } from 'node:fs';
+import { fileURLToPath } from 'node:url';
+import { dirname, join } from 'node:path';
+
+const __dir = dirname(fileURLToPath(import.meta.url));
+for (const line of readFileSync(join(__dir, '..', '.env'), 'utf8').split('\n')) {
+  const m = line.match(/^([A-Z_]+)=(.*)$/);
+  if (m && !process.env[m[1]]) process.env[m[1]] = m[2];
+}
+
+const { getRecord, updateRecord } = await import('../src/fm-client.js');
+
+const DB = 'WALLPAPER';
+const LAYOUT = '*List Wallpapers - Shopify Detail Database';
+const RECORD_ID = '536611';
+const commit = process.argv.includes('--commit');
+
+// sanity guard: make sure we're editing the record we think we are
+const rec = await getRecord(DB, LAYOUT, RECORD_ID);
+if (rec.fieldData['combo sku'] !== 'DWTT73434') {
+  console.error(`ABORT: record ${RECORD_ID} combo sku is ${rec.fieldData['combo sku']}, expected DWTT73434`);
+  process.exit(2);
+}
+console.log('BEFORE:', JSON.stringify({
+  'combo sku': rec.fieldData['combo sku'],
+  'Mfr Pattern': rec.fieldData['Mfr Pattern'],
+  'mfr pattern number': rec.fieldData['mfr pattern number'],
+}, null, 1));
+
+const res = await updateRecord(DB, LAYOUT, RECORD_ID, {
+  'Mfr Pattern': 'AT79126',
+  'mfr pattern number': 'AT79126',
+}, { dryRun: !commit });
+console.log(commit ? 'COMMITTED:' : 'DRY RUN DIFF:', JSON.stringify(res, null, 1));
+
+if (commit) {
+  const after = await getRecord(DB, LAYOUT, RECORD_ID);
+  console.log('VERIFY:', JSON.stringify({
+    'Mfr Pattern': after.fieldData['Mfr Pattern'],
+    'mfr pattern number': after.fieldData['mfr pattern number'],
+  }, null, 1));
+}

← 9bad19a create 3 missing DWTT Baxter WALLPAPER masters (73433 Navy/7 · back to Filemaker Mcp · invoice 102374 repair script: split Otto's collapsed 4-sampl 10f7a19 →