`tasks/deferred/42_refresh-romo-images.md`

40 lines
# Refresh Romo Images

**Context:** 45 Romo products in `vendor_catalog` (not on Shopify) have stale `cdn.shopify.com` URLs from an old Shopify store that no longer hosts these files.

**Goal:** Get fresh image URLs for 45 Romo products, likely from romointernational.com or the Romo group website.

## Approach

1. **Target set:**
   ```sql
   SELECT id, mfr_sku, pattern_name, image_url
   FROM vendor_catalog 
   WHERE vendor_code='romo' 
     AND shopify_product_id IS NULL
     AND (image_url IS NULL OR image_url LIKE '%cdn.shopify.com%')
   ORDER BY mfr_sku;
   ```

2. **Existing scrapers:**
   ```bash
   ls /root/DW-Agents/vendor-scrapers/ | grep -i romo
   ```
   Existing: `scrape-romo-group-wallcoverings.js`, `romo-group-scraper.py`, `enrich-romo-specs.js`

3. **Run the existing scraper:**
   ```bash
   cd /root/DW-Agents/vendor-scrapers && timeout 1800 node scrape-romo-group-wallcoverings.js
   ```
   This should refresh `romo_catalog`. Then sync any new URLs into `vendor_catalog`.

4. **Enrichment:**
   ```bash
   cd /root/DW-Agents/vendor-scrapers && timeout 900 node enrich-ai-tags.js romo --limit 50
   ```

## Report

- URL refresh count
- Enrichment success count