Add palette enrichment (5928 SKUs, full hex+pct) + dry-run-verified Shopify publisher

7b70ec16964ba9b34be2d901bb95e1856c7e799d · 2026-07-22 09:07:27 -0700 · Steve Abrams

Files touched

M publish_shopify.py

Diff

commit 7b70ec16964ba9b34be2d901bb95e1856c7e799d
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Wed Jul 22 09:07:27 2026 -0700

    Add palette enrichment (5928 SKUs, full hex+pct) + dry-run-verified Shopify publisher
---
 publish_shopify.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/publish_shopify.py b/publish_shopify.py
index 8086ac0..97c5041 100644
--- a/publish_shopify.py
+++ b/publish_shopify.py
@@ -38,7 +38,8 @@ def q(sql):
 def products_for(cls):
     # group gate-passing sellable SKUs by parent pattern-application
     rows = q(f"""SELECT parent_sku, pattern_name, product_type, type_suffix, collection_tag,
-        max(body_html), max(product_url), array_agg(dw_sku ORDER BY color_number),
+        max(regexp_replace(coalesce(body_html,''), E'[\\n\\r\\t]+', ' ', 'g')),
+        max(product_url), array_agg(dw_sku ORDER BY color_number),
         array_agg(color_number ORDER BY color_number), array_agg(price ORDER BY color_number),
         array_agg(coalesce(color_tags[1],'') ORDER BY color_number),
         array_agg(coalesce(local_image,'') ORDER BY color_number),

← f07e7fc auto-save: 2026-07-22T08:12:31 (3 files) — enrich_palette.py · back to Carnegie Import · publish_shopify: add paginated dedup guard so re-runs skip a 084d704 →