← back to Carnegie Import

README.md

18 lines

# carnegie-import

Feed-first onboarding of **Carnegie Fabrics** (contract Type II/III wallcovering + textile house)
into `dw_unified.carnegie_catalog`.

- **Method:** Magento 2 GraphQL feed (`/graphql`, `products(search:"")`), $0 — no browser, no AI, no paid API.
- **Scope:** 573 configurable products → 5,928 sellable colorway SKUs (per-color variants).
- **Classification** (`dw_class`) from Carnegie's own category taxonomy (authoritative):
  - `Wallcovering` = categories ∋ `Wallcoverings` or `Xorel Cruise - IMO Wallcovering`
  - `Wall Panel`   = categories ∋ `Upholstered Walls/Panels` (acoustic Xorel wall panels — surfaced separately for Steve's call)
  - `Fabric`       = upholstery / windows / dividers / privacy / museum / outdoor drapery / furniture
- **Dedup:** NEVER-DUPLICATE — `mfr_sku` UNIQUE, upsert `ON CONFLICT`.

Run: `python3 scrape_carnegie.py`

STAGE-ONLY. Live push to Shopify collection `carnegie-wallcoverings` is Steve-gated
(see ~/.claude/yolo-queue/pending-approval/).