[object Object]

← back to Designer Wallcoverings

Carl Robinson: fix publish-channels to anchor on carl_robinson_catalog (registry re-keyed off DWCR-)

2347c1e642fa03f6d6d12d74df807297f0d2a1f5 · 2026-07-06 12:28:29 -0700 · steve@designerwallcoverings.com

Files touched

Diff

commit 2347c1e642fa03f6d6d12d74df807297f0d2a1f5
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Mon Jul 6 12:28:29 2026 -0700

    Carl Robinson: fix publish-channels to anchor on carl_robinson_catalog (registry re-keyed off DWCR-)
---
 scripts/wallquest-refresh/publish-channels-carl-robinson.cjs | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/scripts/wallquest-refresh/publish-channels-carl-robinson.cjs b/scripts/wallquest-refresh/publish-channels-carl-robinson.cjs
index 31d5441a..7e32bf3a 100644
--- a/scripts/wallquest-refresh/publish-channels-carl-robinson.cjs
+++ b/scripts/wallquest-refresh/publish-channels-carl-robinson.cjs
@@ -32,7 +32,8 @@ function gql(query, variables) {
 
   // 2) load the 67 product ids
   const db = new Client({ connectionString: CONN }); await db.connect();
-  const { rows } = await db.query("SELECT dw_sku, shopify_product_id FROM dw_sku_registry WHERE dw_sku LIKE 'DWCR-%' AND shopify_product_id IS NOT NULL ORDER BY dw_sku");
+  // anchor on carl_robinson_catalog (stable) — registry SKUs have been re-keyed away from DWCR-
+  const { rows } = await db.query("SELECT dw_sku, shopify_product_id FROM carl_robinson_catalog WHERE shopify_product_id IS NOT NULL ORDER BY dw_sku");
   console.log(`activating + publishing ${rows.length} products to ${pubs.length} channels…`);
 
   let act = 0, pub = 0, err = 0;

← 2faa01a5 Carl Robinson: harden Shopify SKU update — key on product-id  ·  back to Designer Wallcoverings  ·  Carl Robinson: push material-inclusive titles (City Material 5d6aa242 →