japan: loader creates vendor_never_on_shopify if missing (canonical lacks it, unlike the mirror) — keep_offline insert no longer errors

a3d28d9355a31012f9f4c55a4944c83da9b6c2e2 · 2026-07-06 17:48:42 -0700 · Steve

Files touched

M db/load-distributor-lines.js

Diff

commit a3d28d9355a31012f9f4c55a4944c83da9b6c2e2
Author: Steve <steve@designerwallcoverings.com>
Date:   Mon Jul 6 17:48:42 2026 -0700

    japan: loader creates vendor_never_on_shopify if missing (canonical lacks it, unlike the mirror) — keep_offline insert no longer errors
---
 db/load-distributor-lines.js | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/db/load-distributor-lines.js b/db/load-distributor-lines.js
index f6dcb51..36ff1b1 100644
--- a/db/load-distributor-lines.js
+++ b/db/load-distributor-lines.js
@@ -26,6 +26,9 @@ const ALLOWED = 'ACEGHIJKLOPQRTUWXYZ'.split(''); // no B,D,S,F,M,N,V (hard to he
   // an ACCESS EXCLUSIVE lock and was queue-blocking the live app). CREATE TABLE is independent.
   await db.query(`create table if not exists vendor_ai_flags (
     vendor_code text primary key, use_for_ai boolean default true, added_at timestamptz default now())`);
+  // keep_offline tracker — exists on the mirror but not always canonical; create if missing.
+  await db.query(`create table if not exists vendor_never_on_shopify (
+    vendor_code text primary key, reason text, added_at timestamptz default now())`);
 
   // fleet-wide unique prefix pool + current range high-water mark
   const used = new Set((await db.query("select distinct upper(sku_prefix) p from vendor_registry where sku_prefix is not null")).rows.map((r) => r.p));

← 23c5514 japan: use_for_ai via side table vendor_ai_flags (NO ALTER o · back to Japan Enrich · japan: Store-API crawler finds full Sangetsu-Goodrich catalo f05a2b5 →