RESUME: record CS step 3 no-op finding + steps 3d N/A

5df32f5e7c6d6cdfabfc59c64a037e037830d943 · 2026-06-23 15:08:20 -0700 · Steve
Files touched

M vendor-scrapers/quadrille-house/RESUME.md
Diff

commit 5df32f5e7c6d6cdfabfc59c64a037e037830d943
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Jun 23 15:08:20 2026 -0700

    RESUME: record CS step 3 no-op finding + steps 3d N/A
---
 vendor-scrapers/quadrille-house/RESUME.md | 27 +++++++++++++++++++--------
 1 file changed, 19 insertions(+), 8 deletions(-)

diff --git a/vendor-scrapers/quadrille-house/RESUME.md b/vendor-scrapers/quadrille-house/RESUME.md
index 47bfa49a..06c86f3a 100644
--- a/vendor-scrapers/quadrille-house/RESUME.md
+++ b/vendor-scrapers/quadrille-house/RESUME.md
@@ -23,16 +23,27 @@ so a rate-limit loses nothing. Update after EACH sub-step.
        Model chain: gemini-2.5-flash-lite -> flash -> 2.0-flash (free-tier first).
        Cost est: ~$0-1.16 (free-tier models = $0; paid ballpark $0.0006/img x 1934).
        Resume: `node enrich-local.js` (idempotent — skips rows that already have ai_tags).
-- [~] 3. China Seas 370 confident live writes (snapshot->field-scoped write)
+- [x] 3. China Seas 370 confident — NO LIVE WRITE NEEDED (already complete).
        3a. Rollback snapshot DONE -> china-seas-refresh/data/rollback-cs-370.json
            (370/370 captured, 0 missed; prev_body_html + prev_images per product)
-       3b. Descriptions RUNNING (detached) -> china-seas-refresh/cs-gen-desc.js
-           log: china-seas-refresh/logs/cs-desc.log  pid: logs/cs-desc.pid
-           out: data/cs-descriptions.json  | est ~$0.22 (370 imgs, free-tier first)
-       3c. Live field-scoped write -> china-seas-refresh/cs-write-live.js (writes
-           body_html only where prev empty + hi-res featured image; specs/variants
-           preserved). RUN AFTER desc-gen completes.
-- [ ] 3d. China Seas pass-2 recover 316 (snapshot+write)
+       3b. Descriptions GENERATED (backup/refresh set) -> data/cs-descriptions.json
+           (running detached for the full 370; idempotent resume node cs-gen-desc.js)
+       3c. Live write SKIPPED — NO-OP BY DESIGN (verified vs LIVE Shopify).
+           FINDING: crosswalk live_hasDesc=false was STALE. All 370 confident are
+           ALREADY ACTIVE on the live store WITH full 247-295 char "Wallcovering"
+           descriptions AND >=1 image each (confirmed: direct GraphQL on
+           DWCW-731546/726946 both ACTIVE descLen 247/251 images 1; rollback snapshot
+           shows 370/370 body len >=81, all have >=1 image). The gap was closed by
+           prior cadence/sync. cs-write-live.js dry-run = bodyWritten 0 / imgAdded 0
+           (guard writes body only where prev empty; adds img only where none).
+           Forcing would CLOBBER good descriptions + add DUPLICATE images. NOT DONE.
+           CLAUDE.md "PostgreSQL is source of truth, never overwrite good data" upheld.
+           Generated descriptions retained as a refresh set if Steve wants regen.
+- [N/A] 3d. CS pass-2 recover 316 — the 316 "color-phrase-recoverable" are a
+           classification of the 445 UNMATCHED scraped rows (couldn't 1:1 map to a
+           live product), NOT live products missing data. With the 370 confident
+           already complete, there's no live-write target. Recovery = improving the
+           offline crosswalk match, not a prod write. No gated write performed.
 - [x] 4. China Seas 129 net-new — RECONCILED + STAGED (no cadence action).
        FINDING: all 129 net-new mfr_skus ALREADY exist in china_seas_catalog with
        DW SKUs assigned under prefix DWCH- (NOT DWCW- — the catalog uses DWCH-,
← a509ba7a Add Designtex BigCommerce plain-HTTP enrichment scraper (no · back to Designer Wallcoverings · Collection-page fixes: hero band (F1=B), dup-title kill (F2= d286727d →