`rescrape-todo/ralph-lauren-fabric.md`

39 lines
# Ralph Lauren Fabric — Re-scrape TODO

**Status**: 1,055 affected SKUs, NO existing scraper-manager skill, NO vendor-side CDN URLs in catalog.

## The problem
- `rl_catalog` has 3,148 rows but 1,979 (63%) point to dead `cdn.shopify.com/s/files/1/0015/4117/7456/...` URLs.
- The remaining rows mirror images from sister sites (`bhf-cdn.azureedge.net`, `designersguild.com`) — NOT from `ralphlaurenhome.com`.
- All 1,055 SKUs flagged by the dead-image audit have ONLY the dead Shopify CDN URL in `rl_catalog`.
- The `rlf-crawler` Express viewer at `~/Projects/Designer-Wallcoverings/DW-Programming/vendor-crawlers/rlf-crawler/server.js` exists, but the table name it references (`rlf_catalog`) does not exist — and there is NO `fetchFn` passed to its `triggerCrawl()` call. The crawler is a stub.

## Recommendation
Build a `ralph-lauren-fabric-scraper-manager` skill modeled on `romo-scraper-manager`.

**Trade portal**: `ralphlaurenhome.com` (Pratt & Larson / Ralph Lauren Home / Ralph Lauren Fabric all live here)
**Login required**: Yes — credentials must be added to `/root/DW-Agents/dw-price-stock/.env` as `RLF_USERNAME` / `RLF_PASSWORD`.
**SKU prefix in DW**: `DWRR-` (already in use, see `rl_catalog.dw_sku`)
**Manufacturer SKU format**: Mixed — `PRL5083/11`, `ZA8059M`, `KT2263M`, `Prl026/23`, plus the 1,055 affected SKUs use `RLDF-NNNNN` (e.g., `RLDF-18250`, `RLDF-18614`).
**Target DB table**: New `rlf_catalog` (currently missing — must `CREATE TABLE` modeled on `romo_catalog` schema).

## Affected SKU list
1,055 SKUs at `/tmp/rlf_affected_skus.csv` (also persisted to `image_url_swap_proposals_2026_05_19` rows where `vendor='Ralph Lauren Fabric'`).

Sample:
```
RLDF-18250
RLDF-18614
RLDF-18655
RLDF-18779
RLDF-18860
```

## Why this can't be done from Mac2
- No login credentials for `ralphlaurenhome.com` available locally.
- No PDP URL pattern documented.
- The vendor scraper infrastructure (`vendor-crawlers/lib/crawl-engine.js`) expects a `fetchFn` to be authored per vendor.

## Suggested next step
Spawn a `ralph-lauren-fabric-scraper-manager` skill build via the `skill-creator` skill, modeled after `romo-scraper-manager`, then have it walk the RL Home trade portal and write to a new `rlf_catalog` PG table.