← back to Dw Sku Integrity
TK-10900 plan remaining staging-link recoveries
b5e1d1858b4380f989cad50466b471f3b8ed0939 · 2026-08-31 12:18:02 -0700 · codex-10896
Files touched
M apply-plans-staging-link/China Seas/apply.sqlM apply-plans-staging-link/China Seas/restore-map.jsonM apply-plans-staging-link/China Seas/undo.sqlA apply-plans-staging-link/Phillipe Romano/apply.sqlA apply-plans-staging-link/Phillipe Romano/restore-map.jsonA apply-plans-staging-link/Phillipe Romano/undo.sqlA apply-plans-staging-link/SUMMARY-Phillipe Romano.jsonA evidence/TK-10900-post-program-a-plan-2026-08-31.jsonM staging-link-gen.mjs
Diff
commit b5e1d1858b4380f989cad50466b471f3b8ed0939
Author: codex-10896 <steve@designerwallcoverings.com>
Date: Mon Aug 31 12:18:02 2026 -0700
TK-10900 plan remaining staging-link recoveries
---
apply-plans-staging-link/China Seas/apply.sql | 34 ++---
.../China Seas/restore-map.json | 142 ++++++++++-----------
apply-plans-staging-link/China Seas/undo.sql | 34 ++---
apply-plans-staging-link/Phillipe Romano/apply.sql | 3 +
.../Phillipe Romano/restore-map.json | 1 +
apply-plans-staging-link/Phillipe Romano/undo.sql | 3 +
.../SUMMARY-Phillipe Romano.json | 15 +++
.../TK-10900-post-program-a-plan-2026-08-31.json | 48 +++++++
staging-link-gen.mjs | 6 +-
9 files changed, 180 insertions(+), 106 deletions(-)
diff --git a/apply-plans-staging-link/China Seas/apply.sql b/apply-plans-staging-link/China Seas/apply.sql
index 928315a..86c3848 100644
--- a/apply-plans-staging-link/China Seas/apply.sql
+++ b/apply-plans-staging-link/China Seas/apply.sql
@@ -1,30 +1,30 @@
-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Staging-link recovery: mfr_sku -> catalog dw_sku (existing code, no mint). TK-10896.
-UPDATE shopify_products SET dw_sku='DWCH-510599' WHERE shopify_id='gid://shopify/Product/6604507119667' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510622' WHERE shopify_id='gid://shopify/Product/6604508594227' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510627' WHERE shopify_id='gid://shopify/Product/6604508790835' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510610' WHERE shopify_id='gid://shopify/Product/6604507840563' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510616' WHERE shopify_id='gid://shopify/Product/6604508037171' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510626' WHERE shopify_id='gid://shopify/Product/6604508758067' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510615' WHERE shopify_id='gid://shopify/Product/6604508004403' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510601' WHERE shopify_id='gid://shopify/Product/6604507185203' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510617' WHERE shopify_id='gid://shopify/Product/6604508069939' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510607' WHERE shopify_id='gid://shopify/Product/6604507381811' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510606' WHERE shopify_id='gid://shopify/Product/6604507349043' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510604' WHERE shopify_id='gid://shopify/Product/6604507283507' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510614' WHERE shopify_id='gid://shopify/Product/6604507971635' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510610' WHERE shopify_id='gid://shopify/Product/6604507840563' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510624' WHERE shopify_id='gid://shopify/Product/6604508659763' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510599' WHERE shopify_id='gid://shopify/Product/6604507119667' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510608' WHERE shopify_id='gid://shopify/Product/6604507414579' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510616' WHERE shopify_id='gid://shopify/Product/6604508037171' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510603' WHERE shopify_id='gid://shopify/Product/6604507250739' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510626' WHERE shopify_id='gid://shopify/Product/6604508758067' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510609' WHERE shopify_id='gid://shopify/Product/6604507807795' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510628' WHERE shopify_id='gid://shopify/Product/6604508823603' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510621' WHERE shopify_id='gid://shopify/Product/6604508561459' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510611' WHERE shopify_id='gid://shopify/Product/6604507873331' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510604' WHERE shopify_id='gid://shopify/Product/6604507283507' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510612' WHERE shopify_id='gid://shopify/Product/6604507906099' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510619' WHERE shopify_id='gid://shopify/Product/6604508495923' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510605' WHERE shopify_id='gid://shopify/Product/6604507316275' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510611' WHERE shopify_id='gid://shopify/Product/6604507873331' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510609' WHERE shopify_id='gid://shopify/Product/6604507807795' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510601' WHERE shopify_id='gid://shopify/Product/6604507185203' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510617' WHERE shopify_id='gid://shopify/Product/6604508069939' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510623' WHERE shopify_id='gid://shopify/Product/6604508626995' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510621' WHERE shopify_id='gid://shopify/Product/6604508561459' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510607' WHERE shopify_id='gid://shopify/Product/6604507381811' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510614' WHERE shopify_id='gid://shopify/Product/6604507971635' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510622' WHERE shopify_id='gid://shopify/Product/6604508594227' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510619' WHERE shopify_id='gid://shopify/Product/6604508495923' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510627' WHERE shopify_id='gid://shopify/Product/6604508790835' AND (dw_sku IS NULL OR btrim(dw_sku)='');
+UPDATE shopify_products SET dw_sku='DWCH-510603' WHERE shopify_id='gid://shopify/Product/6604507250739' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510625' WHERE shopify_id='gid://shopify/Product/6604508692531' AND (dw_sku IS NULL OR btrim(dw_sku)='');
-UPDATE shopify_products SET dw_sku='DWCH-510615' WHERE shopify_id='gid://shopify/Product/6604508004403' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510620' WHERE shopify_id='gid://shopify/Product/6604508528691' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510600' WHERE shopify_id='gid://shopify/Product/6604507152435' AND (dw_sku IS NULL OR btrim(dw_sku)='');
UPDATE shopify_products SET dw_sku='DWCH-510613' WHERE shopify_id='gid://shopify/Product/6604507938867' AND (dw_sku IS NULL OR btrim(dw_sku)='');
diff --git a/apply-plans-staging-link/China Seas/restore-map.json b/apply-plans-staging-link/China Seas/restore-map.json
index 69a5604..2d37410 100644
--- a/apply-plans-staging-link/China Seas/restore-map.json
+++ b/apply-plans-staging-link/China Seas/restore-map.json
@@ -1,52 +1,59 @@
[
{
- "shopify_id": "gid://shopify/Product/6604507119667",
- "mfr_sku": "749521",
+ "shopify_id": "gid://shopify/Product/6604508037171",
+ "mfr_sku": "752221",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510599"
+ "new": "DWCH-510616"
},
{
- "shopify_id": "gid://shopify/Product/6604508594227",
- "mfr_sku": "753821",
+ "shopify_id": "gid://shopify/Product/6604508758067",
+ "mfr_sku": "754221",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510622"
+ "new": "DWCH-510626"
},
{
- "shopify_id": "gid://shopify/Product/6604508790835",
- "mfr_sku": "754321",
+ "shopify_id": "gid://shopify/Product/6604508004403",
+ "mfr_sku": "752121",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510627"
+ "new": "DWCH-510615"
},
{
- "shopify_id": "gid://shopify/Product/6604507840563",
- "mfr_sku": "751621",
+ "shopify_id": "gid://shopify/Product/6604507185203",
+ "mfr_sku": "749721",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510610"
+ "new": "DWCH-510601"
},
{
- "shopify_id": "gid://shopify/Product/6604507349043",
- "mfr_sku": "750221",
+ "shopify_id": "gid://shopify/Product/6604508069939",
+ "mfr_sku": "752321",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510606"
+ "new": "DWCH-510617"
},
{
- "shopify_id": "gid://shopify/Product/6604507283507",
- "mfr_sku": "750021",
+ "shopify_id": "gid://shopify/Product/6604507381811",
+ "mfr_sku": "750321",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510604"
+ "new": "DWCH-510607"
},
{
- "shopify_id": "gid://shopify/Product/6604507971635",
- "mfr_sku": "752021",
+ "shopify_id": "gid://shopify/Product/6604507349043",
+ "mfr_sku": "750221",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510614"
+ "new": "DWCH-510606"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507840563",
+ "mfr_sku": "751621",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510610"
},
{
"shopify_id": "gid://shopify/Product/6604508659763",
@@ -55,6 +62,13 @@
"old": null,
"new": "DWCH-510624"
},
+ {
+ "shopify_id": "gid://shopify/Product/6604507119667",
+ "mfr_sku": "749521",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510599"
+ },
{
"shopify_id": "gid://shopify/Product/6604507414579",
"mfr_sku": "750421",
@@ -63,46 +77,46 @@
"new": "DWCH-510608"
},
{
- "shopify_id": "gid://shopify/Product/6604508037171",
- "mfr_sku": "752221",
+ "shopify_id": "gid://shopify/Product/6604507807795",
+ "mfr_sku": "751521",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510616"
+ "new": "DWCH-510609"
},
{
- "shopify_id": "gid://shopify/Product/6604507250739",
- "mfr_sku": "749921",
+ "shopify_id": "gid://shopify/Product/6604508823603",
+ "mfr_sku": "754421",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510603"
+ "new": "DWCH-510628"
},
{
- "shopify_id": "gid://shopify/Product/6604508758067",
- "mfr_sku": "754221",
+ "shopify_id": "gid://shopify/Product/6604508561459",
+ "mfr_sku": "753721",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510626"
+ "new": "DWCH-510621"
},
{
- "shopify_id": "gid://shopify/Product/6604508823603",
- "mfr_sku": "754421",
+ "shopify_id": "gid://shopify/Product/6604507873331",
+ "mfr_sku": "751721",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510628"
+ "new": "DWCH-510611"
},
{
- "shopify_id": "gid://shopify/Product/6604507906099",
- "mfr_sku": "751821",
+ "shopify_id": "gid://shopify/Product/6604507283507",
+ "mfr_sku": "750021",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510612"
+ "new": "DWCH-510604"
},
{
- "shopify_id": "gid://shopify/Product/6604508495923",
- "mfr_sku": "753521",
+ "shopify_id": "gid://shopify/Product/6604507906099",
+ "mfr_sku": "751821",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510619"
+ "new": "DWCH-510612"
},
{
"shopify_id": "gid://shopify/Product/6604507316275",
@@ -112,53 +126,46 @@
"new": "DWCH-510605"
},
{
- "shopify_id": "gid://shopify/Product/6604507873331",
- "mfr_sku": "751721",
- "column": "dw_sku",
- "old": null,
- "new": "DWCH-510611"
- },
- {
- "shopify_id": "gid://shopify/Product/6604507807795",
- "mfr_sku": "751521",
+ "shopify_id": "gid://shopify/Product/6604508626995",
+ "mfr_sku": "753921",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510609"
+ "new": "DWCH-510623"
},
{
- "shopify_id": "gid://shopify/Product/6604507185203",
- "mfr_sku": "749721",
+ "shopify_id": "gid://shopify/Product/6604507971635",
+ "mfr_sku": "752021",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510601"
+ "new": "DWCH-510614"
},
{
- "shopify_id": "gid://shopify/Product/6604508069939",
- "mfr_sku": "752321",
+ "shopify_id": "gid://shopify/Product/6604508594227",
+ "mfr_sku": "753821",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510617"
+ "new": "DWCH-510622"
},
{
- "shopify_id": "gid://shopify/Product/6604508626995",
- "mfr_sku": "753921",
+ "shopify_id": "gid://shopify/Product/6604508495923",
+ "mfr_sku": "753521",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510623"
+ "new": "DWCH-510619"
},
{
- "shopify_id": "gid://shopify/Product/6604508561459",
- "mfr_sku": "753721",
+ "shopify_id": "gid://shopify/Product/6604508790835",
+ "mfr_sku": "754321",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510621"
+ "new": "DWCH-510627"
},
{
- "shopify_id": "gid://shopify/Product/6604507381811",
- "mfr_sku": "750321",
+ "shopify_id": "gid://shopify/Product/6604507250739",
+ "mfr_sku": "749921",
"column": "dw_sku",
"old": null,
- "new": "DWCH-510607"
+ "new": "DWCH-510603"
},
{
"shopify_id": "gid://shopify/Product/6604508692531",
@@ -167,13 +174,6 @@
"old": null,
"new": "DWCH-510625"
},
- {
- "shopify_id": "gid://shopify/Product/6604508004403",
- "mfr_sku": "752121",
- "column": "dw_sku",
- "old": null,
- "new": "DWCH-510615"
- },
{
"shopify_id": "gid://shopify/Product/6604508528691",
"mfr_sku": "753621",
diff --git a/apply-plans-staging-link/China Seas/undo.sql b/apply-plans-staging-link/China Seas/undo.sql
index 3a2818a..e728451 100644
--- a/apply-plans-staging-link/China Seas/undo.sql
+++ b/apply-plans-staging-link/China Seas/undo.sql
@@ -1,30 +1,30 @@
-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
-- Staging-link recovery: mfr_sku -> catalog dw_sku (existing code, no mint). TK-10896.
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507119667' AND dw_sku='DWCH-510599';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508594227' AND dw_sku='DWCH-510622';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508790835' AND dw_sku='DWCH-510627';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507840563' AND dw_sku='DWCH-510610';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508037171' AND dw_sku='DWCH-510616';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508758067' AND dw_sku='DWCH-510626';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508004403' AND dw_sku='DWCH-510615';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507185203' AND dw_sku='DWCH-510601';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508069939' AND dw_sku='DWCH-510617';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507381811' AND dw_sku='DWCH-510607';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507349043' AND dw_sku='DWCH-510606';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507283507' AND dw_sku='DWCH-510604';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507971635' AND dw_sku='DWCH-510614';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507840563' AND dw_sku='DWCH-510610';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508659763' AND dw_sku='DWCH-510624';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507119667' AND dw_sku='DWCH-510599';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507414579' AND dw_sku='DWCH-510608';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508037171' AND dw_sku='DWCH-510616';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507250739' AND dw_sku='DWCH-510603';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508758067' AND dw_sku='DWCH-510626';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507807795' AND dw_sku='DWCH-510609';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508823603' AND dw_sku='DWCH-510628';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508561459' AND dw_sku='DWCH-510621';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507873331' AND dw_sku='DWCH-510611';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507283507' AND dw_sku='DWCH-510604';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507906099' AND dw_sku='DWCH-510612';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508495923' AND dw_sku='DWCH-510619';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507316275' AND dw_sku='DWCH-510605';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507873331' AND dw_sku='DWCH-510611';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507807795' AND dw_sku='DWCH-510609';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507185203' AND dw_sku='DWCH-510601';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508069939' AND dw_sku='DWCH-510617';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508626995' AND dw_sku='DWCH-510623';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508561459' AND dw_sku='DWCH-510621';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507381811' AND dw_sku='DWCH-510607';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507971635' AND dw_sku='DWCH-510614';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508594227' AND dw_sku='DWCH-510622';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508495923' AND dw_sku='DWCH-510619';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508790835' AND dw_sku='DWCH-510627';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507250739' AND dw_sku='DWCH-510603';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508692531' AND dw_sku='DWCH-510625';
-UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508004403' AND dw_sku='DWCH-510615';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604508528691' AND dw_sku='DWCH-510620';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507152435' AND dw_sku='DWCH-510600';
UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507938867' AND dw_sku='DWCH-510613';
diff --git a/apply-plans-staging-link/Phillipe Romano/apply.sql b/apply-plans-staging-link/Phillipe Romano/apply.sql
new file mode 100644
index 0000000..2dd39ec
--- /dev/null
+++ b/apply-plans-staging-link/Phillipe Romano/apply.sql
@@ -0,0 +1,3 @@
+-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
+-- Staging-link recovery: mfr_sku -> catalog dw_sku (existing code, no mint). TK-10896.
+
diff --git a/apply-plans-staging-link/Phillipe Romano/restore-map.json b/apply-plans-staging-link/Phillipe Romano/restore-map.json
new file mode 100644
index 0000000..fe51488
--- /dev/null
+++ b/apply-plans-staging-link/Phillipe Romano/restore-map.json
@@ -0,0 +1 @@
+[]
diff --git a/apply-plans-staging-link/Phillipe Romano/undo.sql b/apply-plans-staging-link/Phillipe Romano/undo.sql
new file mode 100644
index 0000000..2dd39ec
--- /dev/null
+++ b/apply-plans-staging-link/Phillipe Romano/undo.sql
@@ -0,0 +1,3 @@
+-- GATED -- canonical Kamatera dw_unified write. Do NOT run automatically.
+-- Staging-link recovery: mfr_sku -> catalog dw_sku (existing code, no mint). TK-10896.
+
diff --git a/apply-plans-staging-link/SUMMARY-Phillipe Romano.json b/apply-plans-staging-link/SUMMARY-Phillipe Romano.json
new file mode 100644
index 0000000..6c1b375
--- /dev/null
+++ b/apply-plans-staging-link/SUMMARY-Phillipe Romano.json
@@ -0,0 +1,15 @@
+{
+ "ticket": "TK-10896",
+ "vendor": "Phillipe Romano",
+ "catalog": "greenland_catalog",
+ "kam_blank_mfr_rows": 122,
+ "linked": 0,
+ "statements": 0,
+ "skipped": {
+ "no_map": 122,
+ "bad_shape": 0,
+ "minted_residue": 0,
+ "no_shopify_id": 0
+ },
+ "note": "NOTHING executed. apply.sql is a GATED draft."
+}
diff --git a/evidence/TK-10900-post-program-a-plan-2026-08-31.json b/evidence/TK-10900-post-program-a-plan-2026-08-31.json
new file mode 100644
index 0000000..5d09596
--- /dev/null
+++ b/evidence/TK-10900-post-program-a-plan-2026-08-31.json
@@ -0,0 +1,48 @@
+{
+ "generated_by": "dwsku-backlog-scan.mjs",
+ "ticket": "TK-10896",
+ "psql_prefix": "ssh root@45.61.58.125 psql dw_unified",
+ "source_note": "CUSTOM (verify which DB)",
+ "active_code_count": 80713,
+ "active_blank_dwsku": 7313,
+ "by_class": {
+ "RESCRAPE": 7117,
+ "STAGING_LINK": 146,
+ "PROVENANCE_REVIEW": 42,
+ "SELF_COPY_COLLISION": 7,
+ "SELF_COPY_SOURCE": 1
+ },
+ "by_recovery_group": {
+ "rescrape_program_TK10900": 7117,
+ "recoverable_now_staging_link": 146,
+ "provenance_review_TK10896": 42,
+ "dedup_gated_TK10649": 7,
+ "recoverable_now_self_copy": 1
+ },
+ "self_copy_provenance": {
+ "with_real_mfr_sku_cross_verifiable": 0,
+ "sku_only_no_independent_check": 1
+ },
+ "within_batch_shared_candidates": {
+ "note": "BENIGN: same-pattern sellable+sample rows resolving to one shared dw_sku (dw_sku is intentionally non-unique per pattern). These are NOT collisions; an apply step must upsert, not assume per-row uniqueness. True cross-product collisions are counted under *_COLLISION classes.",
+ "shared_candidate_groups": 0,
+ "rows_in_shared_groups": 0
+ },
+ "rescrape_cohorts_top": {
+ "Phillipe Romano": 2899,
+ "Maharam": 1429,
+ "Carnegie": 1176,
+ "Knoll": 492,
+ "CMO Paris": 344,
+ "Hollywood Wallcoverings": 286,
+ "Fentucci Naturals": 213,
+ "Majilite": 160,
+ "Pixels": 52,
+ "Novasuede": 25,
+ "Steve Abrams Studios": 13,
+ "Jeffrey Stevens": 12,
+ "Fabricut": 5,
+ "Thibaut": 4,
+ "Graduate Collection UK": 4
+ }
+}
diff --git a/staging-link-gen.mjs b/staging-link-gen.mjs
index 840fc4d..5ff9b99 100644
--- a/staging-link-gen.mjs
+++ b/staging-link-gen.mjs
@@ -17,6 +17,7 @@ import { execFileSync } from 'node:child_process';
import { readFileSync, writeFileSync, mkdirSync, existsSync, rmSync } from 'node:fs';
import { join, dirname } from 'node:path';
import { fileURLToPath } from 'node:url';
+import { baseCode } from './match-helpers.mjs';
const HERE = dirname(fileURLToPath(import.meta.url));
const US = '\x1f', RS = '\x1e';
@@ -45,7 +46,10 @@ const kamRows = run(KAM,
const map = new Map();
for (const [mfr, dw] of run(['psql', '-h', '/tmp', '-d', 'dw_unified'],
`SELECT btrim(mfr_sku), btrim(dw_sku) FROM ${CATALOG} WHERE dw_sku IS NOT NULL AND btrim(dw_sku)<>'';`)) {
- if (!map.has(mfr)) map.set(mfr, dw);
+ // Canonical dw_sku is the shared base identity; staging catalogs can carry
+ // sell-unit suffixes such as -Sample. Normalize before planning so verify and
+ // undo agree with canonical storage.
+ if (!map.has(mfr)) map.set(mfr, baseCode(dw));
}
// 3. Reverted-mint ledger codes (safety exclude).
← f8b6e9a TK-10900 capture canonical post-run scan
·
back to Dw Sku Integrity
·
auto-data-snapshot: 2026-08-31T13:13:14 (5 data files) — app 35e1c25 →