[object Object]

← back to Designer Wallcoverings

backfill: add daisy_bennett_v2_stage fallback + --unstamped resume; 136/136 done

afe590fb194c1402301919d59e6e5c73de6ffcec · 2026-07-21 13:38:56 -0700 · Steve

Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>

Files touched

Diff

commit afe590fb194c1402301919d59e6e5c73de6ffcec
Author: Steve <steve@designerwallcoverings.com>
Date:   Tue Jul 21 13:38:56 2026 -0700

    backfill: add daisy_bennett_v2_stage fallback + --unstamped resume; 136/136 done
    
    Co-Authored-By: Claude Fable 5 <noreply@anthropic.com>
---
 scripts/wallquest-refresh/backfill-specs-0717-batch.cjs | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/scripts/wallquest-refresh/backfill-specs-0717-batch.cjs b/scripts/wallquest-refresh/backfill-specs-0717-batch.cjs
index 23cd36b9..4db8a97c 100644
--- a/scripts/wallquest-refresh/backfill-specs-0717-batch.cjs
+++ b/scripts/wallquest-refresh/backfill-specs-0717-batch.cjs
@@ -49,6 +49,7 @@ const esc = s => (s || '').replace(/'/g, "''");
     FROM shopify_products
     WHERE vendor='Phillipe Romano' AND created_at_shopify::date='2026-07-17' AND status='ACTIVE'
       AND variant_sku NOT LIKE '%-Sample'
+      ${args.includes('--unstamped') ? 'AND fm_specs_at IS NULL' : ''}
     ORDER BY 2`);
   console.log(`batch: ${batch.length} products`);
 
@@ -76,6 +77,7 @@ const esc = s => (s || '').replace(/'/g, "''");
     { t: 'daisy_bennett_catalog',    cols: "mfr_sku, coalesce(src_pattern,pattern_name) AS src_pattern, color_name, material, width, length, repeat_v, match_type, backing, specs::text, color_hex, ai_styles::text, '' AS bolt_yards, coalesce(settlement_status,'') AS sflag" },
     { t: 'phillipe_romano_catalog',  cols: "mfr_sku, pattern_name AS src_pattern, coalesce(color_name,dw_color) AS color_name, material, width, length, repeat_v, match_type, '' AS backing, null::text AS specs, coalesce(color_hex,dominant_color_hex,'') AS color_hex, ai_styles::text, '' AS bolt_yards, '' AS sflag" },
     { t: 'wallquest_catalog',        cols: "mfr_sku, pattern_name AS src_pattern, color_name, material, width, length, repeat_v, match_type, '' AS backing, null::text AS specs, '' AS color_hex, null::text AS ai_styles, '' AS bolt_yards, '' AS sflag" },
+    { t: 'daisy_bennett_v2_stage',   cols: "mfr_sku, pattern AS src_pattern, color AS color_name, material, width, '' AS length, repeat_v, '' AS match_type, '' AS backing, null::text AS specs, '' AS color_hex, null::text AS ai_styles, '' AS bolt_yards, coalesce(settlement,'') AS sflag" },
   ];
   const staged = {};
   for (const { t, cols } of tables) {

← fe7c3722 auto-save: 2026-07-21T13:37:45 (1 files) — scripts/wallquest  ·  back to Designer Wallcoverings  ·  chore: v1.2.3 — 0717 backfill map artifact + version bump (s 2495cb81 →