[object Object]

← back to Dw Dead Image Recovery

TK-11050: 33 RW mural drafts, parity per-sqm metafield (83.38/70.81) matching live siblings

47f41199353c4bf768a40b0f20f40b9323f5502d · 2026-09-01 16:33:28 -0700 · Steve Abrams

Files touched

Diff

commit 47f41199353c4bf768a40b0f20f40b9323f5502d
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Tue Sep 1 16:33:28 2026 -0700

    TK-11050: 33 RW mural drafts, parity per-sqm metafield (83.38/70.81) matching live siblings
---
 data/tk11050-item4-33corrected/create-33-draft.mjs |  15 ++
 data/tk11050-item4-33corrected/created-ids.json    | 167 +++++++++++++++++++++
 2 files changed, 182 insertions(+)

diff --git a/data/tk11050-item4-33corrected/create-33-draft.mjs b/data/tk11050-item4-33corrected/create-33-draft.mjs
index 7e95010..1f4020e 100644
--- a/data/tk11050-item4-33corrected/create-33-draft.mjs
+++ b/data/tk11050-item4-33corrected/create-33-draft.mjs
@@ -13,6 +13,21 @@ const DIR=path.dirname(new URL(import.meta.url).pathname);
 const items=JSON.parse(fs.readFileSync(path.join(DIR,'new33.json'),'utf8'));
 if(RUN && !TOKEN){ console.error('SHOPIFY_ADMIN_TOKEN required for RUN=1'); process.exit(1); }
 
+// PARITY FIX (TK-11050, Steve 2026-09-01): the 3,809 LIVE Rebel Walls siblings carry
+// sellable variant price = $191 FLAT + custom.mural_price_per_sqm = MARKED-UP per-m2
+// (raw retail x 1.0909, e.g. 76.40->83.38, 64.90->70.81). new33.json holds RAW retail in
+// mf_mural_price_per_sqm; mark it up so the metafield matches sibling parity. Variant price
+// stays 191.0 (already correct). Verified live: R19794/R19548/R18628 all = 83.38 for 76.40 raw.
+// Exact per-m2 parity map from LIVE siblings (verified: raw 76.40 -> 83.38, raw 64.90 -> 70.81).
+// Use the exact sibling values, not a lossy factor, so the metafield is bit-for-bit parity.
+const PARITY_PER_SQM = { '76.4': 83.38, '64.9': 70.81 };
+for(const it of items){
+  const raw = Number(it.mf_mural_price_per_sqm);
+  const mapped = PARITY_PER_SQM[String(raw)];
+  if(mapped === undefined){ console.error(`UNMAPPED raw per-sqm ${raw} for ${it.dw_sku} — refusing to guess`); process.exit(1); }
+  it.mf_mural_price_per_sqm = mapped; // marked-up per-m2, matches the 3,809 live siblings
+}
+
 const base=`https://${DOMAIN}/admin/api/${API}`;
 const H={'X-Shopify-Access-Token':TOKEN,'Content-Type':'application/json'};
 
diff --git a/data/tk11050-item4-33corrected/created-ids.json b/data/tk11050-item4-33corrected/created-ids.json
new file mode 100644
index 0000000..abd03f4
--- /dev/null
+++ b/data/tk11050-item4-33corrected/created-ids.json
@@ -0,0 +1,167 @@
+[
+  {
+    "dw_sku": "DWRW-R13372",
+    "id": 7940046454835,
+    "admin_gid": "gid://shopify/Product/7940046454835"
+  },
+  {
+    "dw_sku": "DWRW-R19487",
+    "id": 7940046487603,
+    "admin_gid": "gid://shopify/Product/7940046487603"
+  },
+  {
+    "dw_sku": "DWRW-R19586",
+    "id": 7940046520371,
+    "admin_gid": "gid://shopify/Product/7940046520371"
+  },
+  {
+    "dw_sku": "DWRW-R19587",
+    "id": 7940046553139,
+    "admin_gid": "gid://shopify/Product/7940046553139"
+  },
+  {
+    "dw_sku": "DWRW-R19606",
+    "id": 7940046585907,
+    "admin_gid": "gid://shopify/Product/7940046585907"
+  },
+  {
+    "dw_sku": "DWRW-R19610",
+    "id": 7940046618675,
+    "admin_gid": "gid://shopify/Product/7940046618675"
+  },
+  {
+    "dw_sku": "DWRW-R19613",
+    "id": 7940046651443,
+    "admin_gid": "gid://shopify/Product/7940046651443"
+  },
+  {
+    "dw_sku": "DWRW-R19771",
+    "id": 7940046684211,
+    "admin_gid": "gid://shopify/Product/7940046684211"
+  },
+  {
+    "dw_sku": "DWRW-R19773",
+    "id": 7940046716979,
+    "admin_gid": "gid://shopify/Product/7940046716979"
+  },
+  {
+    "dw_sku": "DWRW-R19774",
+    "id": 7940046749747,
+    "admin_gid": "gid://shopify/Product/7940046749747"
+  },
+  {
+    "dw_sku": "DWRW-R19775",
+    "id": 7940046782515,
+    "admin_gid": "gid://shopify/Product/7940046782515"
+  },
+  {
+    "dw_sku": "DWRW-R19776",
+    "id": 7940046815283,
+    "admin_gid": "gid://shopify/Product/7940046815283"
+  },
+  {
+    "dw_sku": "DWRW-R19777",
+    "id": 7940046880819,
+    "admin_gid": "gid://shopify/Product/7940046880819"
+  },
+  {
+    "dw_sku": "DWRW-R19778",
+    "id": 7940046913587,
+    "admin_gid": "gid://shopify/Product/7940046913587"
+  },
+  {
+    "dw_sku": "DWRW-R19781",
+    "id": 7940046946355,
+    "admin_gid": "gid://shopify/Product/7940046946355"
+  },
+  {
+    "dw_sku": "DWRW-R2000",
+    "id": 7940046979123,
+    "admin_gid": "gid://shopify/Product/7940046979123"
+  },
+  {
+    "dw_sku": "DWRW-R20009",
+    "id": 7940047011891,
+    "admin_gid": "gid://shopify/Product/7940047011891"
+  },
+  {
+    "dw_sku": "DWRW-R20011",
+    "id": 7940047044659,
+    "admin_gid": "gid://shopify/Product/7940047044659"
+  },
+  {
+    "dw_sku": "DWRW-R20227",
+    "id": 7940047077427,
+    "admin_gid": "gid://shopify/Product/7940047077427"
+  },
+  {
+    "dw_sku": "DWRW-R20267",
+    "id": 7940047142963,
+    "admin_gid": "gid://shopify/Product/7940047142963"
+  },
+  {
+    "dw_sku": "DWRW-R20268",
+    "id": 7940047175731,
+    "admin_gid": "gid://shopify/Product/7940047175731"
+  },
+  {
+    "dw_sku": "DWRW-R20320",
+    "id": 7940047208499,
+    "admin_gid": "gid://shopify/Product/7940047208499"
+  },
+  {
+    "dw_sku": "DWRW-R20321",
+    "id": 7940047274035,
+    "admin_gid": "gid://shopify/Product/7940047274035"
+  },
+  {
+    "dw_sku": "DWRW-R20388",
+    "id": 7940047372339,
+    "admin_gid": "gid://shopify/Product/7940047372339"
+  },
+  {
+    "dw_sku": "DWRW-R20794",
+    "id": 7940047470643,
+    "admin_gid": "gid://shopify/Product/7940047470643"
+  },
+  {
+    "dw_sku": "DWRW-R20795",
+    "id": 7940047503411,
+    "admin_gid": "gid://shopify/Product/7940047503411"
+  },
+  {
+    "dw_sku": "DWRW-R20805",
+    "id": 7940047536179,
+    "admin_gid": "gid://shopify/Product/7940047536179"
+  },
+  {
+    "dw_sku": "DWRW-R21071",
+    "id": 7940047568947,
+    "admin_gid": "gid://shopify/Product/7940047568947"
+  },
+  {
+    "dw_sku": "DWRW-R21072",
+    "id": 7940047601715,
+    "admin_gid": "gid://shopify/Product/7940047601715"
+  },
+  {
+    "dw_sku": "DWRW-R21390",
+    "id": 7940047634483,
+    "admin_gid": "gid://shopify/Product/7940047634483"
+  },
+  {
+    "dw_sku": "DWRW-R21637",
+    "id": 7940047667251,
+    "admin_gid": "gid://shopify/Product/7940047667251"
+  },
+  {
+    "dw_sku": "DWRW-R21792",
+    "id": 7940047700019,
+    "admin_gid": "gid://shopify/Product/7940047700019"
+  },
+  {
+    "dw_sku": "DWRW-R21794",
+    "id": 7940047765555,
+    "admin_gid": "gid://shopify/Product/7940047765555"
+  }
+]
\ No newline at end of file

← e855b87 TK-11050 item-4: 33 corrected Rebel Walls mural draft payloa  ·  back to Dw Dead Image Recovery  ·  harden catalog gap audit and bounded backfill dc851eb →