auto-data-snapshot: 2026-08-24T11:44:27 (1 data files) — DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql

4aba82c2a6e9d5980ad9a64e67053f8cfd0085d3 · 2026-08-24 11:45:47 -0700 · auto-commit-fleet

Files touched

M DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql

Diff

commit 4aba82c2a6e9d5980ad9a64e67053f8cfd0085d3
Author: auto-commit-fleet <steve@designerwallcoverings.com>
Date:   Mon Aug 24 11:45:47 2026 -0700

    auto-data-snapshot: 2026-08-24T11:44:27 (1 data files) — DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
---
 DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql b/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
index caff4909..36203686 100644
--- a/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
+++ b/DW-Agents/vendor-command-center/cost-backfill-2026-08-22-APPLY.sql
@@ -33,7 +33,7 @@ SET cost_price=jd.cost, cost_source='justin_david_pricing_2026.our_cost_yd backf
 FROM jd WHERE sp.status='ACTIVE' AND (sp.cost_price IS NULL OR sp.cost_price::numeric=0)
   AND jd.k=upper(regexp_replace(sp.mfr_sku::text,'[^A-Za-z0-9]','','g'));
 
-SELECT count(*) FILTER (WHERE cost_source LIKE '%backfill 2026-08-22%') AS total_backfilled,
+SELECT count(*) FILTER (WHERE cost_source LIKE '%backfill 2026-08-2%') AS total_backfilled,
        round(100.0*count(*) FILTER (WHERE cost_price IS NOT NULL AND cost_price::numeric>0)/count(*),1) AS pct_with_cost
 FROM shopify_products WHERE status='ACTIVE';
 COMMIT;

← 7a2091d0 fabricut-activate: same image-less-activation guard as daily · back to Designer Wallcoverings · TK-10817: stage Carnegie 57 blank-description backfill artif 21e1e69a →