auto-save: 2026-08-01T11:36:26 (1 files) — DW-Agents/vendor-command-center/server.js

63944705ae34a1dacc50284bf3a4e59e888c03f5 · 2026-08-01 11:36:33 -0700 · Steve Abrams

Files touched

M DW-Agents/vendor-command-center/server.js

Diff

commit 63944705ae34a1dacc50284bf3a4e59e888c03f5
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Sat Aug 1 11:36:33 2026 -0700

    auto-save: 2026-08-01T11:36:26 (1 files) — DW-Agents/vendor-command-center/server.js
---
 DW-Agents/vendor-command-center/server.js | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/DW-Agents/vendor-command-center/server.js b/DW-Agents/vendor-command-center/server.js
index d75b69b3..8405ca9c 100644
--- a/DW-Agents/vendor-command-center/server.js
+++ b/DW-Agents/vendor-command-center/server.js
@@ -2223,6 +2223,9 @@ async function syncVendorCounts() {
       FROM shopify_products
       WHERE status NOT IN ('DELETED_FROM_SHOPIFY','DUPLICATE_IMPORT')
       GROUP BY vendor`);
+    // NOTE: does not honor SQL's \_ escape — a pattern needing a LITERAL underscore
+    // would need this extended. with_img/draft/arch sums also rely on the
+    // shopify_products.shopify_id UNIQUE constraint (rows == distinct ids).
     const ilikeToRegex = (p) => new RegExp('^' + String(p)
       .replace(/[.*+?^${}()|[\]\\]/g, '\\$&')
       .replace(/%/g, '.*').replace(/_/g, '.') + '$', 'i');

← 917e7d7d auto-save: 2026-08-01T11:06:15 (2 files) — DW-Agents/vendor- · back to Designer Wallcoverings · auto-save: 2026-08-01T16:38:01 (1 files) — shopify/scripts/a 24d3b4a6 →