← back to Dw Sku Integrity
auto-data-snapshot: 2026-08-31T02:00:54 (4 data files) — apply-plans-staging-link/China Seas/apply.sql apply-plans-staging-link/China Seas/restore-map.json apply-plans-staging-link/China Seas/undo.sql apply-plans-staging-link/SUMMARY-China Seas.json
688c25dab2c114179c69bc83f94fbfd9bb4483c8 · 2026-08-31 02:00:58 -0700 · auto-commit-fleet
Files touched
A apply-plans-staging-link/China Seas/apply.sqlA apply-plans-staging-link/China Seas/restore-map.jsonA apply-plans-staging-link/China Seas/undo.sqlA apply-plans-staging-link/SUMMARY-China Seas.json
Diff
commit 688c25dab2c114179c69bc83f94fbfd9bb4483c8
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date: Mon Aug 31 02:00:58 2026 -0700
auto-data-snapshot: 2026-08-31T02:00:54 (4 data files) — apply-plans-staging-link/China Seas/apply.sql apply-plans-staging-link/China Seas/restore-map.json apply-plans-staging-link/China Seas/undo.sql apply-plans-staging-link/SUMMARY-China Seas.json
---
apply-plans-staging-link/China Seas/apply.sql | 31 ++++
.../China Seas/restore-map.json | 205 +++++++++++++++++++++
apply-plans-staging-link/China Seas/undo.sql | 31 ++++
apply-plans-staging-link/SUMMARY-China Seas.json | 15 ++
4 files changed, 282 insertions(+)
diff --git a/apply-plans-staging-link/China Seas/apply.sql b/apply-plans-staging-link/China Seas/apply.sql
new file mode 100644
index 0000000..928315a
--- /dev/null
+++ b/apply-plans-staging-link/China Seas/apply.sql
@@ -0,0 +1,31 @@
+-- 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-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-510624' WHERE shopify_id='gid://shopify/Product/6604508659763' 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-510628' WHERE shopify_id='gid://shopify/Product/6604508823603' 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-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)='');
+UPDATE shopify_products SET dw_sku='DWCH-510602' WHERE shopify_id='gid://shopify/Product/6604507217971' 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
new file mode 100644
index 0000000..69a5604
--- /dev/null
+++ b/apply-plans-staging-link/China Seas/restore-map.json
@@ -0,0 +1,205 @@
+[
+ {
+ "shopify_id": "gid://shopify/Product/6604507119667",
+ "mfr_sku": "749521",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510599"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508594227",
+ "mfr_sku": "753821",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510622"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508790835",
+ "mfr_sku": "754321",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510627"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507840563",
+ "mfr_sku": "751621",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510610"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507349043",
+ "mfr_sku": "750221",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510606"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507283507",
+ "mfr_sku": "750021",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510604"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507971635",
+ "mfr_sku": "752021",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510614"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508659763",
+ "mfr_sku": "754021",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510624"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507414579",
+ "mfr_sku": "750421",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510608"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508037171",
+ "mfr_sku": "752221",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510616"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507250739",
+ "mfr_sku": "749921",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510603"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508758067",
+ "mfr_sku": "754221",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510626"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508823603",
+ "mfr_sku": "754421",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510628"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507906099",
+ "mfr_sku": "751821",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510612"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508495923",
+ "mfr_sku": "753521",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510619"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507316275",
+ "mfr_sku": "750121",
+ "column": "dw_sku",
+ "old": null,
+ "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",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510609"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507185203",
+ "mfr_sku": "749721",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510601"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508069939",
+ "mfr_sku": "752321",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510617"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508626995",
+ "mfr_sku": "753921",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510623"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508561459",
+ "mfr_sku": "753721",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510621"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507381811",
+ "mfr_sku": "750321",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510607"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604508692531",
+ "mfr_sku": "754121",
+ "column": "dw_sku",
+ "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",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510620"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507152435",
+ "mfr_sku": "749621",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510600"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507938867",
+ "mfr_sku": "751921",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510613"
+ },
+ {
+ "shopify_id": "gid://shopify/Product/6604507217971",
+ "mfr_sku": "749821",
+ "column": "dw_sku",
+ "old": null,
+ "new": "DWCH-510602"
+ }
+]
diff --git a/apply-plans-staging-link/China Seas/undo.sql b/apply-plans-staging-link/China Seas/undo.sql
new file mode 100644
index 0000000..3a2818a
--- /dev/null
+++ b/apply-plans-staging-link/China Seas/undo.sql
@@ -0,0 +1,31 @@
+-- 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/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/6604508659763' AND dw_sku='DWCH-510624';
+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/6604508823603' AND dw_sku='DWCH-510628';
+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/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';
+UPDATE shopify_products SET dw_sku=NULL WHERE shopify_id='gid://shopify/Product/6604507217971' AND dw_sku='DWCH-510602';
diff --git a/apply-plans-staging-link/SUMMARY-China Seas.json b/apply-plans-staging-link/SUMMARY-China Seas.json
new file mode 100644
index 0000000..505e6d0
--- /dev/null
+++ b/apply-plans-staging-link/SUMMARY-China Seas.json
@@ -0,0 +1,15 @@
+{
+ "ticket": "TK-10896",
+ "vendor": "China Seas",
+ "catalog": "china_seas_catalog",
+ "kam_blank_mfr_rows": 29,
+ "linked": 29,
+ "statements": 29,
+ "skipped": {
+ "no_map": 0,
+ "bad_shape": 0,
+ "minted_residue": 0,
+ "no_shopify_id": 0
+ },
+ "note": "NOTHING executed. apply.sql is a GATED draft."
+}
← 584b4e1 TK-10900: harden content-match to strict 1:1 (pattern,color,
·
back to Dw Sku Integrity
·
TK-10900/A: content-match-gen.mjs — schema-adaptive catalog 0aa462b →