[object Object]

← back to Designer Wallcoverings

auto-save: 2026-07-31T14:58:42 (3 files) — DW-Agents/vendor-command-center/delete-all-drafts.js DW-Agents/vendor-command-center/delete-drafts-parallel.js DW-Agents/vendor-command-center/discontinuation-validator.js

1298783609407c447230b33f51e427b725100ea5 · 2026-07-31 14:58:50 -0700 · Steve Abrams

Files touched

Diff

commit 1298783609407c447230b33f51e427b725100ea5
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Fri Jul 31 14:58:50 2026 -0700

    auto-save: 2026-07-31T14:58:42 (3 files) — DW-Agents/vendor-command-center/delete-all-drafts.js DW-Agents/vendor-command-center/delete-drafts-parallel.js DW-Agents/vendor-command-center/discontinuation-validator.js
---
 DW-Agents/vendor-command-center/delete-all-drafts.js         | 1 +
 DW-Agents/vendor-command-center/delete-drafts-parallel.js    | 1 +
 DW-Agents/vendor-command-center/discontinuation-validator.js | 1 +
 3 files changed, 3 insertions(+)

diff --git a/DW-Agents/vendor-command-center/delete-all-drafts.js b/DW-Agents/vendor-command-center/delete-all-drafts.js
index cb99091e..ed711d54 100644
--- a/DW-Agents/vendor-command-center/delete-all-drafts.js
+++ b/DW-Agents/vendor-command-center/delete-all-drafts.js
@@ -52,6 +52,7 @@ async function run() {
       SELECT shopify_id, title, dw_sku, mfr_sku
       FROM shopify_products
       WHERE vendor = $1 AND UPPER(status) = 'DRAFT'
+        AND shopify_id LIKE 'gid://%'
       ORDER BY title ASC
     `, [vendorName]);
 
diff --git a/DW-Agents/vendor-command-center/delete-drafts-parallel.js b/DW-Agents/vendor-command-center/delete-drafts-parallel.js
index 165a3d4f..7d0a41b2 100644
--- a/DW-Agents/vendor-command-center/delete-drafts-parallel.js
+++ b/DW-Agents/vendor-command-center/delete-drafts-parallel.js
@@ -51,6 +51,7 @@ async function processVendor(vendorName, workerNum) {
     SELECT shopify_id, title, dw_sku, mfr_sku
     FROM shopify_products
     WHERE vendor = $1 AND UPPER(status) = 'DRAFT'
+      AND shopify_id LIKE 'gid://%'
     ORDER BY title ASC
   `, [vendorName]);
 
diff --git a/DW-Agents/vendor-command-center/discontinuation-validator.js b/DW-Agents/vendor-command-center/discontinuation-validator.js
index 3918a34b..406a8420 100644
--- a/DW-Agents/vendor-command-center/discontinuation-validator.js
+++ b/DW-Agents/vendor-command-center/discontinuation-validator.js
@@ -203,6 +203,7 @@ async function validateVendor(vendorCode, options = {}) {
     FROM shopify_products
     WHERE vendor ILIKE $2
       AND UPPER(status) = UPPER($3)
+      AND shopify_id LIKE 'gid://%'
     ORDER BY title ASC
     LIMIT $4
   `, [vendorCode, vendor.vendor_name, statusFilter, limit]);

← 535779d0 auto-save: 2026-07-31T12:27:46 (1 files) — DW-Agents/vendor-  ·  back to Designer Wallcoverings  ·  auto-save: 2026-07-31T16:59:39 (2 files) — shopify/scripts/a aafa1b73 →