worker-guard: verify backfill table correct (launch-pad gate reads unified vendor_catalog); record prod deploy

3a8a8504986fc9dbe3cfd556c8009a60bd01bb11 · 2026-06-12 09:17:34 -0700 · SteveStudio2

Files touched

M shopify/scripts/worker-guard/DEPLOY.md

Diff

commit 3a8a8504986fc9dbe3cfd556c8009a60bd01bb11
Author: SteveStudio2 <steve@designerwallcoverings.com>
Date:   Fri Jun 12 09:17:34 2026 -0700

    worker-guard: verify backfill table correct (launch-pad gate reads unified vendor_catalog); record prod deploy
---
 shopify/scripts/worker-guard/DEPLOY.md | 16 ++++++++++++----
 1 file changed, 12 insertions(+), 4 deletions(-)

diff --git a/shopify/scripts/worker-guard/DEPLOY.md b/shopify/scripts/worker-guard/DEPLOY.md
index 95827eca..df264c46 100644
--- a/shopify/scripts/worker-guard/DEPLOY.md
+++ b/shopify/scripts/worker-guard/DEPLOY.md
@@ -38,9 +38,17 @@ git diff --no-index worker.js.prod worker.js.patched
 4. Flip to `DEDUP_GUARD=on` (default) once dry output looks correct → guard actively skips+backfills.
 5. Rollback at any point: `DEDUP_GUARD=off` (no-op) or restore `worker.js.bak` + restart.
 
-## Review notes / open questions for Steve
-- Backfill targets the unified `vendor_catalog` (same table + `dw_sku` key the worker's own
-  post-success backfill uses at line ~751). If a vendor's gate reads its **per-vendor** catalog
-  (e.g. `schumacher_catalog`) instead, we may also want to backfill there — flag if so.
+## Review notes
+- **Backfill table — VERIFIED CORRECT (2026-06-12).** The launch-pad/graphic-agent create path
+  (the worker's main net-new create source) gates on the unified `vendor_catalog`
+  (graphic-agent/server.js:418,1166). The guard backfills exactly that table on `dw_sku` — the
+  same table+key the worker's own post-success backfill uses (worker.js:751). So the guard closes
+  the loop for the worker path with no per-vendor backfill needed. The OTHER create path
+  (Mac2 cadence-import, which reads per-vendor catalogs) has its own guard that backfills the
+  per-vendor catalog (commit ca70f41). Both paths fully + consistently covered.
 - One extra Shopify read per CREATE job (creates are low-volume + variant-ceiling-gated, so cost is
   negligible). Updates/metafields/sku-less creates are untouched (guard returns null fast).
+
+## DEPLOYED 2026-06-12
+Live on prod under pm2 `shopify-queue-worker`, `DEDUP_GUARD=on` (code also defaults to 'on' if env
+lost). `worker.js.bak-20260612` kept on prod for rollback. Base checksum verified pre-swap (no drift).

← 7c8eaf1b vendors: wire Newwall (6 confirmed lines, cost=trade_net*0.8 · back to Designer Wallcoverings · Add scan-active-dups.js: reusable read-only both-active dupl f486e785 →