Step 5: 1,942 net-new dw_sku assigned (0 collision); HELD structurally enforced (not in vendors.js + cost=0 -> cadence skips); update execution-resume with both DTD verdicts

a3179cd0adc990095aa44dfe2b6afa83127eb30f · 2026-06-23 15:02:38 -0700 · Steve

Files touched

M shopify/tres-tintas-room-backups/_regen.ledger
M vendor-scrapers/quadrille-house/EXECUTION-RESUME.md

Diff

commit a3179cd0adc990095aa44dfe2b6afa83127eb30f
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Jun 23 15:02:38 2026 -0700

    Step 5: 1,942 net-new dw_sku assigned (0 collision); HELD structurally enforced (not in vendors.js + cost=0 -> cadence skips); update execution-resume with both DTD verdicts
---
 shopify/tres-tintas-room-backups/_regen.ledger     |  7 +++++
 .../quadrille-house/EXECUTION-RESUME.md            | 31 ++++++++++++++++++----
 2 files changed, 33 insertions(+), 5 deletions(-)

diff --git a/shopify/tres-tintas-room-backups/_regen.ledger b/shopify/tres-tintas-room-backups/_regen.ledger
index 0d58bb26..3e96e503 100644
--- a/shopify/tres-tintas-room-backups/_regen.ledger
+++ b/shopify/tres-tintas-room-backups/_regen.ledger
@@ -432,3 +432,10 @@
 7866353713203
 7866353745971
 7866353778739
+7866353811507
+7866353844275
+7866353909811
+7866353942579
+7866353975347
+7866354008115
+7866354040883
diff --git a/vendor-scrapers/quadrille-house/EXECUTION-RESUME.md b/vendor-scrapers/quadrille-house/EXECUTION-RESUME.md
index 505053de..e3c0fa85 100644
--- a/vendor-scrapers/quadrille-house/EXECUTION-RESUME.md
+++ b/vendor-scrapers/quadrille-house/EXECUTION-RESUME.md
@@ -21,8 +21,29 @@ so a rate-limit can't lose state. Each step flips to DONE when its commit lands.
   china_seas_catalog = same-house shared SKU schemes, NOT dups (diff brand+prefix).
 
 ## Steps
-- [ ] 1. Registry prefixes (LOCAL) — 8 new + Quadrille DWQC align
-- [ ] 2. Enrich 1,942 net-new (Gemini desc + tags) — est $2.14
-- [ ] 3. China Seas live writes: 370 confident (snapshot->write), pass-2 recover 316
-- [ ] 4. China Seas 129 net-new — dedup-confirm, stage DWCW- via cadence (priced)
-- [ ] 5. Net-new 1,942 — assign DW SKUs, stage; cadence creates DRAFT/HELD (no cost)
+- [x] 1. Registry prefixes (LOCAL) — 8 new INSERTed + Quadrille DWIY->DWQC repointed. commit 2908741a
+- [~] 2. Enrich 1,942 net-new (Gemini vision: desc+tags+colors, ONE call/row). Local runner
+        enrich-local.js (canonical script is Kamatera-only; table is local-mirror-only).
+        Free-tier gemini-2.5-flash-lite => ~$0/run (paid ceiling ~$1.17). RUNNING in bg, resumable
+        (only NULL ai_tags rows; 503-retry + model-failover added). ~126/1942 at checkpoint.
+- [x] 3. China Seas: DTD VERDICT A. Premise (370 had EMPTY body/old img) was FALSE — all 370 +
+        12 pass-2-recovered ALREADY populated live (good AI desc + shopify-CDN img). Stale MIRROR
+        caused false premise. => NO live overwrite (avoided regression: external S3 hotlink swap).
+        Snapshots: data/rollback-cs-370.json (370) + data/rollback-cs-pass2-12.json (12). Refreshed
+        local mirror body_html for 368+12 to match live truth. Pass-2 strict matcher recovered only
+        12 high-confidence 1:1 (not loose 316). commit (china seas verdict A).
+- [x] 4. China Seas net-new: DTD VERDICT A. 26 confirmed-absent patterns (101 colorway records),
+        dedup vs ALL-status China Seas titles. NO cost/price source exists (china_seas_catalog has
+        no cost col; live CS is SAMPLE-ONLY $4.25, no roll variant/price). Cadence skips cost<=0.
+        => flagged china_seas_catalog.staging_status='NET_NEW_HELD_NO_COST', NOT created. Business
+        dependency surfaced. data/china-seas-netnew-held.json. commit (china seas step 4).
+- [x] 5. Net-new 1,942: dw_sku assigned (1,942/1,942 distinct, 0 collision vs live). HELD is
+        STRUCTURALLY enforced — the 9 lines are NOT in vendors.js (no costExpr) AND cost_price=0,
+        so the metered cadence's `costExpr>0` filter skips them => NEVER created/DRAFT/published.
+        Staged = catalog data only (this IS "Staged for New"). Adding to vendors.js requires a real
+        trade cost = gated business action, out of scope. NO burst. 0 products created.
+
+## KEY DECISIONS (both DTD 3/3 unanimous, verdict A)
+- 370+12 China Seas: approval premise FALSE -> skip live write, fix mirror. NOTHING overwritten live.
+- 26 CS net-new: no cost/price exists -> HELD as data, not created. Trade-cost = business dependency.
+## NET RESULT: 0 live Shopify writes/creates. All work = local mirror + catalog staging + enrich.

← 1ad6d3c1 China Seas Step 4: DTD verdict A — 26 confirmed-absent net-n · back to Designer Wallcoverings · RESUME: add mid-flight resume instructions + CS live-write/r dfed2390 →