[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

73a7b19c9b1cead1ff8318118e030decf30af5a3 · 2026-07-31 14:58:50 -0700 · Steve Abrams

Files touched

Diff

commit 73a7b19c9b1cead1ff8318118e030decf30af5a3
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]);

← 2673366c 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 4e064b17 →