← back to Mfr Recovery 2026 08 23

TK-10677: verify 24 Zoffany recoverable (/bin/zsh join), mark stale/mirror-only SQL, add verified CSV

fc2116ff5604aa26c34156b17eaab5f8d5c7f094 · 2026-08-24 19:39:29 -0700 · Steve Abrams

Files touched

• M novasuede_mfr_recovery_APPLY.sql
• A zoffany_24_verified_20260824.csv
• M zoffany_mfr_recovery_APPLY.sql

Diff

commit fc2116ff5604aa26c34156b17eaab5f8d5c7f094
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Mon Aug 24 19:39:29 2026 -0700

    TK-10677: verify 24 Zoffany recoverable (/bin/zsh join), mark stale/mirror-only SQL, add verified CSV
---
 novasuede_mfr_recovery_APPLY.sql |  3 +++
 zoffany_24_verified_20260824.csv | 25 +++++++++++++++++++++++++
 zoffany_mfr_recovery_APPLY.sql   |  3 +++
 3 files changed, 31 insertions(+)

diff --git a/novasuede_mfr_recovery_APPLY.sql b/novasuede_mfr_recovery_APPLY.sql
index 1a72eba..237dccc 100644
--- a/novasuede_mfr_recovery_APPLY.sql
+++ b/novasuede_mfr_recovery_APPLY.sql
@@ -1,3 +1,6 @@
+-- ⚠️ STALE — DO NOT RUN (verified 2026-08-24 TK-10677): only 1 of these is still recoverable
+-- current truth: 12 Novasuede ACTIVE null-mfr, 1 recoverable (novasuede™-mist-luxury-suede-copy). Re-derive before any apply.
+
 -- APPLY (not dry-run): Novasuede mfr_sku recovery — 14 products (of 22; 8 not in catalog)
 -- Ticket: TK-10677 / TK-10794
 -- Approved: <APPROVAL_DATE>
diff --git a/zoffany_24_verified_20260824.csv b/zoffany_24_verified_20260824.csv
new file mode 100644
index 0000000..04afd38
--- /dev/null
+++ b/zoffany_24_verified_20260824.csv
@@ -0,0 +1,25 @@
+shopify_id,handle,dw_sku,mfr_sku
+2140770,watered-silk-antique-bronze-dwzf-187023,DWZF-187023,ZRHW312914
+2140772,spark-310993-sapphire-dwzf-187024,DWZF-187024,ZQUA310993
+2140774,kensington-grasscloth-mineral-dwzf-187027,DWZF-187027,ZHIW313004
+2140835,abstract-1928-taupe-dwzf-187029,DWZF-187029,ZRHW312889
+2140837,watered-silk-platinum-grey-dwzf-187032,DWZF-187032,ZRHW312916
+2140839,persian-tulip-blue-stone-dwzf-187034,DWZF-187034,ZHIW312997
+2140983,ormonde-stripe-la-seine-dwzf-187041,DWZF-187041,ZFOW312941
+2140985,ormonde-stripe-mushroom-dwzf-187042,DWZF-187042,ZFOW312943
+2140987,eleonora-dwzf-187049,DWZF-187049,ZGUV08004
+3932515,abstract-1928-mineral-dwzf-187011,DWZF-187011,ZRHW312890
+3947353,conway-sahara-dwzf-187003,DWZF-187003,ZTOT312747
+3960437,hawksmoor-antique-bronze-dwzf-187007,DWZF-187007,ZPHA312595
+3985836,persian-tulip-poison-dwzf-187001,DWZF-187001,ZHIW312996
+3994071,shagreen-como-blue-dwzf-187012,DWZF-187012,ZRHW312906
+3994072,shagreen-oyster-dwzf-187006,DWZF-187006,ZRHW312910
+3994073,shagreen-zinc-dwzf-187000,DWZF-187000,ZRHW312907
+3996321,spun-silk-antique-copper-dwzf-187004,DWZF-187004,ZRHW312899
+4005303,weathered-stone-plain-bluestone-dwzf-187005,DWZF-187005,ZKEM312641
+4090315,guinea-blue-stone-dwzf-187016,DWZF-187016,ZKEM312648
+4096773,kensington-grasscloth-paris-grey-dwzf-187021,DWZF-187021,ZHIW313003
+4110599,moresque-glaze-indigo-dwzf-187019,DWZF-187019,ZHIW312994
+4116816,persian-tulip-quartz-grey-dwzf-187015,DWZF-187015,ZHIW312995
+4127314,spun-silk-antique-bronze-dwzf-187014,DWZF-187014,ZRHW312897
+4127316,spun-silk-paris-grey-dwzf-187017,DWZF-187017,ZRHW312903
diff --git a/zoffany_mfr_recovery_APPLY.sql b/zoffany_mfr_recovery_APPLY.sql
index 05af41d..7efc962 100644
--- a/zoffany_mfr_recovery_APPLY.sql
+++ b/zoffany_mfr_recovery_APPLY.sql
@@ -1,3 +1,6 @@
+-- ⚠️ MIRROR-ONLY — NOT DURABLE (2026-08-24 TK-10677): shopify_products is Kamatera-canonical;
+-- a Mac2 mirror write reverts on next sync. Use verified CSV + Kamatera+Shopify path in the pending-approval memo instead.
+
 -- APPLY (not dry-run): Zoffany mfr_sku recovery — 24 products
 -- Ticket: TK-10677 / TK-10794
 -- Approved: <APPROVAL_DATE>

← 3cc4ec0 add pending-approval memo for dw_unified write — awaiting St  ·  back to Mfr Recovery 2026 08 23  ·  TK-10677: add push-mfr-to-shopify.mjs (dry-run default; sets 31981a9 →