imageless-rescue: live-state diagnosis (37 already fixed, 1 attached, 11 need crawl) + status tables

46a3e7c8c90028e069c14859a08818f826704f6d · 2026-06-20 03:49:48 -0700 · SteveStudio2
Files touched

A .gitignore
A README.md
A data/live_state.json
A data/load_items.sql
A data/source.sql
A data/status-table.json
Diff

commit 46a3e7c8c90028e069c14859a08818f826704f6d
Author: SteveStudio2 <stevestudio2@SteveStacStudio.lan>
Date:   Sat Jun 20 03:49:48 2026 -0700

    imageless-rescue: live-state diagnosis (37 already fixed, 1 attached, 11 need crawl) + status tables
---
 .gitignore             |   8 +
 README.md              |  29 +++
 data/live_state.json   | 394 +++++++++++++++++++++++++++++++++++++++
 data/load_items.sql    |  53 ++++++
 data/source.sql        |  36 ++++
 data/status-table.json | 492 +++++++++++++++++++++++++++++++++++++++++++++++++
 6 files changed, 1012 insertions(+)

diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..1924158
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1,8 @@
+node_modules/
+.env*
+tmp/
+*.log
+.DS_Store
+dist/
+build/
+.next/
diff --git a/README.md b/README.md
new file mode 100644
index 0000000..b016b67
--- /dev/null
+++ b/README.md
@@ -0,0 +1,29 @@
+# imageless-rescue
+
+Rescue the 49 drafted imageless DW products (list:
+`~/.claude/yolo-queue/pending-approval/imageless-active-20260616-2321.json`).
+
+Source-of-truth note: the local `dw_unified` mirror (`shopify_products`) was
+STALE (frozen ~2026-06-16). The authoritative state is LIVE Shopify, fetched
+via the Admin API. `data/live_state.json` holds the true per-product status.
+
+## Findings (2026-06-20)
+- **37 of 49 already fixed** (active + imaged) since the snapshot — Anna French
+  23, Versace 9, Gaston 3, LA Walls 2. No action needed.
+- **1 imaged this session** — Scalamandre "Parlor Velvet Pillow Lumbar 14X22
+  Nougat" (draft, null mfr_sku). Attached the exact lumbar+colorway match from
+  `scalamandre_pillows` (`SCLBDK273240001`, scene7) → Shopify ingested 1200x954.
+  Stayed DRAFT (gate respected).
+- **11 still draft + imageless** — no good local image; all already tagged
+  `Needs-Image`. Need a vendor crawl (see per-vendor plan in the session report).
+
+## Files
+- `data/load_items.sql` — loads the 49 into a temp table (generated from JSON).
+- `data/source.sql` — per-item vendor-catalog image sourcing query.
+- `data/live_state.json` — TRUE live Shopify status (status + image count) per id.
+- `data/status-table.json` — final per-product status + resolution, grouped.
+
+## Gates honored
+- Image SOURCING + ATTACHING to DRAFTs = SAFE (done directly).
+- NO active flip, NO dw_unified write (mirror is read-only).
+- Republish of the now-imaged Scalamandre draft = GATED → officer memo.
diff --git a/data/live_state.json b/data/live_state.json
new file mode 100644
index 0000000..50774b8
--- /dev/null
+++ b/data/live_state.json
@@ -0,0 +1,394 @@
+[
+ {
+  "handle": "versace-370507-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709508659",
+  "mfr_sku": "370507",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-791361-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709738035",
+  "mfr_sku": "791361",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65601designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086153267",
+  "mfr_sku": "AT34136",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "ala-scalapini-printed-sisal-grs-9031",
+  "vendor": "Phillipe Romano",
+  "shopify_id": "gid://shopify/Product/1496811044976",
+  "mfr_sku": "GRS-9031",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "beverly-hills-damask-wallpaper-pink-1",
+  "vendor": "Fentucci",
+  "shopify_id": "gid://shopify/Product/7664585080883",
+  "mfr_sku": "BEVERLY-HILLS-DAMASK-WALLPAPER-PINK-1",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "dwta-65629designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087169075",
+  "mfr_sku": "AT34157",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65631designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087234611",
+  "mfr_sku": "AT34154",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65610designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086448179",
+  "mfr_sku": "AT34104",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "beverly-hills-damask-wallpaper-pink",
+  "vendor": "Designer Wallcoverings",
+  "shopify_id": "gid://shopify/Product/6577176674355",
+  "mfr_sku": "BEVERLY-HILLS-DAMASK-WALLPAPER-PINK",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "chanel-grass-on-metal-grs-3609",
+  "vendor": "Phillipe Romano",
+  "shopify_id": "gid://shopify/Product/1495175725168",
+  "mfr_sku": "GRS-3609",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "custom-print-the-set-decorator",
+  "vendor": "The Set Decorator",
+  "shopify_id": "gid://shopify/Product/7832963088435",
+  "mfr_sku": null,
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "versace-366924-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709475891",
+  "mfr_sku": "366924",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-370551-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709541427",
+  "mfr_sku": "370551",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-791755-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709770803",
+  "mfr_sku": "791755",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-935834-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709803571",
+  "mfr_sku": "935834",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-791333-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709606963",
+  "mfr_sku": "791333",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-791351-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709672499",
+  "mfr_sku": "791351",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "versace-791352-wallcovering-versace",
+  "vendor": "Versace",
+  "shopify_id": "gid://shopify/Product/7821709705267",
+  "mfr_sku": "791352",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65622designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086874163",
+  "mfr_sku": "AT34130",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "parlor-velvet-pillow-lumbar-14x22-nougat-scalamandre",
+  "vendor": "Scalamandre",
+  "shopify_id": "gid://shopify/Product/7832784764979",
+  "mfr_sku": null,
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "dwta-65651designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087922739",
+  "mfr_sku": "AT1407",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65599designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086054963",
+  "mfr_sku": "AT34110",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65607designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086349875",
+  "mfr_sku": "AT34103",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65616designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086644787",
+  "mfr_sku": "AT34148",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65637designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087463987",
+  "mfr_sku": "AT34152",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65648designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087824435",
+  "mfr_sku": "AT1452",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "tattiana-tightweave-jute-grs-9026",
+  "vendor": "Designer Wallcoverings",
+  "shopify_id": "gid://shopify/Product/1495215571056",
+  "mfr_sku": "SH5027",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "dwta-65639designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087529523",
+  "mfr_sku": "AT34122",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65630designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087201843",
+  "mfr_sku": "AT34158",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65633designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087332915",
+  "mfr_sku": "AT34156",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65632designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087300147",
+  "mfr_sku": "AT34155",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65638designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087496755",
+  "mfr_sku": "AT34151",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "pradera-pink-vintage-floral-wallpaper-cgs-83513",
+  "vendor": "LA Walls",
+  "shopify_id": "gid://shopify/Product/1498737344624",
+  "mfr_sku": "83513",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "barcelona-maroon-paisley-wallpaper-cgs-83509",
+  "vendor": "LA Walls",
+  "shopify_id": "gid://shopify/Product/1498736459888",
+  "mfr_sku": "83509",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65619designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086775859",
+  "mfr_sku": "AT34126",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65625designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087005235",
+  "mfr_sku": "AT34138",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65635designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087398451",
+  "mfr_sku": "AT34149",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65641designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087595059",
+  "mfr_sku": "AT34125",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65613designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086546483",
+  "mfr_sku": "AT34146",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwta-65636designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948087431219",
+  "mfr_sku": "AT34150",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "barcelona-sand-paisley-wallpaper-cgs-83510",
+  "vendor": "LA Walls",
+  "shopify_id": "gid://shopify/Product/1498736689264",
+  "mfr_sku": "83510",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwkk-121617",
+  "vendor": "Gaston Y Daniela",
+  "shopify_id": "gid://shopify/Product/7419553120307",
+  "mfr_sku": "GDW4856.007.0",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "barcelona-champagne-paisley-wallpaper-cgs-83511",
+  "vendor": "LA Walls",
+  "shopify_id": "gid://shopify/Product/1498736885872",
+  "mfr_sku": "83511",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "rough-weed-grasscloth-chocolate-brown-grass-and-jute-grs-7400",
+  "vendor": "Phillipe Romano",
+  "shopify_id": "gid://shopify/Product/1495159996528",
+  "mfr_sku": "GRS-7400",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "watsuya-wide-blade-grs-3603",
+  "vendor": "Phillipe Romano",
+  "shopify_id": "gid://shopify/Product/1495174381680",
+  "mfr_sku": "GRS-3603",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "dwkk-121614",
+  "vendor": "Gaston Y Daniela",
+  "shopify_id": "gid://shopify/Product/7419552956467",
+  "mfr_sku": "GDW4856.003.0",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "dwkk-121626",
+  "vendor": "Gaston Y Daniela",
+  "shopify_id": "gid://shopify/Product/7419553349683",
+  "mfr_sku": "GDW5104.006.0",
+  "live_status": "active",
+  "live_imgs": 1
+ },
+ {
+  "handle": "kubuki-sisal-grs-9022",
+  "vendor": "Designer Wallcoverings",
+  "shopify_id": "gid://shopify/Product/1495214850160",
+  "mfr_sku": "SH5023",
+  "live_status": "draft",
+  "live_imgs": 0
+ },
+ {
+  "handle": "dwta-65600designerwallcoverings-los-angeles",
+  "vendor": "Anna French",
+  "shopify_id": "gid://shopify/Product/6948086120499",
+  "mfr_sku": "AT34105",
+  "live_status": "active",
+  "live_imgs": 1
+ }
+]
\ No newline at end of file
diff --git a/data/load_items.sql b/data/load_items.sql
new file mode 100644
index 0000000..7fcdbb0
--- /dev/null
+++ b/data/load_items.sql
@@ -0,0 +1,53 @@
+DROP TABLE IF EXISTS tmp_imageless;
+CREATE TEMP TABLE tmp_imageless(handle text, vendor text, shopify_gid text, shopify_id text, mfr_sku text);
+INSERT INTO tmp_imageless VALUES
+('versace-370507-wallcovering-versace','Versace','gid://shopify/Product/7821709508659','7821709508659','370507'),
+('versace-791361-wallcovering-versace','Versace','gid://shopify/Product/7821709738035','7821709738035','791361'),
+('dwta-65601designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086153267','6948086153267','AT34136'),
+('ala-scalapini-printed-sisal-grs-9031','Phillipe Romano','gid://shopify/Product/1496811044976','1496811044976','GRS-9031'),
+('beverly-hills-damask-wallpaper-pink-1','Fentucci','gid://shopify/Product/7664585080883','7664585080883','BEVERLY-HILLS-DAMASK-WALLPAPER-PINK-1'),
+('dwta-65629designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087169075','6948087169075','AT34157'),
+('dwta-65631designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087234611','6948087234611','AT34154'),
+('dwta-65610designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086448179','6948086448179','AT34104'),
+('beverly-hills-damask-wallpaper-pink','Designer Wallcoverings','gid://shopify/Product/6577176674355','6577176674355','BEVERLY-HILLS-DAMASK-WALLPAPER-PINK'),
+('chanel-grass-on-metal-grs-3609','Phillipe Romano','gid://shopify/Product/1495175725168','1495175725168','GRS-3609'),
+('custom-print-the-set-decorator','The Set Decorator','gid://shopify/Product/7832963088435','7832963088435',NULL),
+('versace-366924-wallcovering-versace','Versace','gid://shopify/Product/7821709475891','7821709475891','366924'),
+('versace-370551-wallcovering-versace','Versace','gid://shopify/Product/7821709541427','7821709541427','370551'),
+('versace-791755-wallcovering-versace','Versace','gid://shopify/Product/7821709770803','7821709770803','791755'),
+('versace-935834-wallcovering-versace','Versace','gid://shopify/Product/7821709803571','7821709803571','935834'),
+('versace-791333-wallcovering-versace','Versace','gid://shopify/Product/7821709606963','7821709606963','791333'),
+('versace-791351-wallcovering-versace','Versace','gid://shopify/Product/7821709672499','7821709672499','791351'),
+('versace-791352-wallcovering-versace','Versace','gid://shopify/Product/7821709705267','7821709705267','791352'),
+('dwta-65622designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086874163','6948086874163','AT34130'),
+('parlor-velvet-pillow-lumbar-14x22-nougat-scalamandre','Scalamandre','gid://shopify/Product/7832784764979','7832784764979',NULL),
+('dwta-65651designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087922739','6948087922739','AT1407'),
+('dwta-65599designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086054963','6948086054963','AT34110'),
+('dwta-65607designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086349875','6948086349875','AT34103'),
+('dwta-65616designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086644787','6948086644787','AT34148'),
+('dwta-65637designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087463987','6948087463987','AT34152'),
+('dwta-65648designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087824435','6948087824435','AT1452'),
+('tattiana-tightweave-jute-grs-9026','Designer Wallcoverings','gid://shopify/Product/1495215571056','1495215571056','SH5027'),
+('dwta-65639designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087529523','6948087529523','AT34122'),
+('dwta-65630designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087201843','6948087201843','AT34158'),
+('dwta-65633designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087332915','6948087332915','AT34156'),
+('dwta-65632designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087300147','6948087300147','AT34155'),
+('dwta-65638designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087496755','6948087496755','AT34151'),
+('pradera-pink-vintage-floral-wallpaper-cgs-83513','LA Walls','gid://shopify/Product/1498737344624','1498737344624','83513'),
+('barcelona-maroon-paisley-wallpaper-cgs-83509','LA Walls','gid://shopify/Product/1498736459888','1498736459888','83509'),
+('dwta-65619designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086775859','6948086775859','AT34126'),
+('dwta-65625designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087005235','6948087005235','AT34138'),
+('dwta-65635designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087398451','6948087398451','AT34149'),
+('dwta-65641designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087595059','6948087595059','AT34125'),
+('dwta-65613designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086546483','6948086546483','AT34146'),
+('dwta-65636designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948087431219','6948087431219','AT34150'),
+('barcelona-sand-paisley-wallpaper-cgs-83510','LA Walls','gid://shopify/Product/1498736689264','1498736689264','83510'),
+('dwkk-121617','Gaston Y Daniela','gid://shopify/Product/7419553120307','7419553120307','GDW4856.007.0'),
+('barcelona-champagne-paisley-wallpaper-cgs-83511','LA Walls','gid://shopify/Product/1498736885872','1498736885872','83511'),
+('rough-weed-grasscloth-chocolate-brown-grass-and-jute-grs-7400','Phillipe Romano','gid://shopify/Product/1495159996528','1495159996528','GRS-7400'),
+('watsuya-wide-blade-grs-3603','Phillipe Romano','gid://shopify/Product/1495174381680','1495174381680','GRS-3603'),
+('dwkk-121614','Gaston Y Daniela','gid://shopify/Product/7419552956467','7419552956467','GDW4856.003.0'),
+('dwkk-121626','Gaston Y Daniela','gid://shopify/Product/7419553349683','7419553349683','GDW5104.006.0'),
+('kubuki-sisal-grs-9022','Designer Wallcoverings','gid://shopify/Product/1495214850160','1495214850160','SH5023'),
+('dwta-65600designerwallcoverings-los-angeles','Anna French','gid://shopify/Product/6948086120499','6948086120499','AT34105');
+-- 49 items
diff --git a/data/source.sql b/data/source.sql
new file mode 100644
index 0000000..dbeb677
--- /dev/null
+++ b/data/source.sql
@@ -0,0 +1,36 @@
+\i data/load_items.sql
+
+-- Helper: classify an image_url
+-- Build a unioned lookup of (mfr_sku, vendor_tag, image_url, all_images, rejected) across the relevant vendor catalogs
+DROP TABLE IF EXISTS tmp_imgsrc;
+CREATE TEMP TABLE tmp_imgsrc AS
+SELECT mfr_sku, 'versace_catalog'::text src, image_url, NULL::text all_images, image_rejected FROM versace_catalog
+UNION ALL SELECT mfr_sku,'anna_french_catalog', image_url, all_images, image_rejected FROM anna_french_catalog
+UNION ALL SELECT mfr_sku,'command54_catalog', image_url, all_images, image_rejected FROM command54_catalog
+UNION ALL SELECT mfr_sku,'la_walls_catalog', image_url, all_images, NULL FROM la_walls_catalog
+UNION ALL SELECT mfr_sku,'gaston_daniela_catalog', image_url, all_images, image_rejected FROM gaston_daniela_catalog
+UNION ALL SELECT mfr_sku,'fentucci_catalog', image_url, all_images, NULL FROM fentucci_catalog
+UNION ALL SELECT mfr_sku,'scalamandre_catalog', image_url, all_images, image_rejected FROM scalamandre_catalog
+UNION ALL SELECT mfr_sku,'scalamandre_pillows', image_url, NULL, NULL FROM scalamandre_pillows;
+
+\echo '==== PER-ITEM SOURCING (vendor catalog match by mfr_sku) ===='
+SELECT t.vendor, t.mfr_sku, t.shopify_id,
+       s.src AS matched_catalog,
+       CASE WHEN s.image_url ~ '^https?://' THEN 'HTTP'
+            WHEN s.mfr_sku IS NULL THEN 'NO_ROW'
+            WHEN coalesce(s.image_url,'')='' THEN 'EMPTY'
+            ELSE 'OTHER' END AS img_state,
+       coalesce(s.image_rejected::text,'-') AS rej,
+       CASE WHEN s.all_images ~ '^https?://' OR s.all_images ~ '"https?://' THEN 'HAS_ALL' ELSE '-' END AS allimg
+FROM tmp_imageless t
+LEFT JOIN tmp_imgsrc s ON s.mfr_sku = t.mfr_sku
+ORDER BY t.vendor, t.mfr_sku;
+
+\echo ''
+\echo '==== shopify_products mirror image state for these 49 (by shopify_id) ===='
+SELECT sp.vendor, sp.mfr_sku,
+       CASE WHEN sp.image_url ~ '^https?://' THEN 'HTTP' WHEN coalesce(sp.image_url,'')='' THEN 'EMPTY' ELSE 'OTHER' END AS mirror_img,
+       sp.status
+FROM shopify_products sp
+JOIN tmp_imageless t ON t.shopify_id = regexp_replace(sp.shopify_id,'\D','','g') OR sp.shopify_id = t.shopify_gid
+ORDER BY sp.vendor, sp.mfr_sku;
diff --git a/data/status-table.json b/data/status-table.json
new file mode 100644
index 0000000..425a9cf
--- /dev/null
+++ b/data/status-table.json
@@ -0,0 +1,492 @@
+[
+ {
+  "vendor": "Versace",
+  "mfr_sku": "370507",
+  "handle": "versace-370507-wallcovering-versace",
+  "shopify_id": "7821709508659",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "791361",
+  "handle": "versace-791361-wallcovering-versace",
+  "shopify_id": "7821709738035",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34136",
+  "handle": "dwta-65601designerwallcoverings-los-angeles",
+  "shopify_id": "6948086153267",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Phillipe Romano",
+  "mfr_sku": "GRS-9031",
+  "handle": "ala-scalapini-printed-sisal-grs-9031",
+  "shopify_id": "1496811044976",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "original PR grasscloth/sisal; local crop dir GrassclothWallpaper.com/cropped-images (only GRS-3609 present, low-res)",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Fentucci",
+  "mfr_sku": "BEVERLY-HILLS-DAMASK-WALLPAPER-PINK-1",
+  "handle": "beverly-hills-damask-wallpaper-pink-1",
+  "shopify_id": "7664585080883",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "fentucci_catalog (Beverly Hills Damask dup) \u2014 needs crawl",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34157",
+  "handle": "dwta-65629designerwallcoverings-los-angeles",
+  "shopify_id": "6948087169075",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34154",
+  "handle": "dwta-65631designerwallcoverings-los-angeles",
+  "shopify_id": "6948087234611",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34104",
+  "handle": "dwta-65610designerwallcoverings-los-angeles",
+  "shopify_id": "6948086448179",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Designer Wallcoverings",
+  "mfr_sku": "BEVERLY-HILLS-DAMASK-WALLPAPER-PINK",
+  "handle": "beverly-hills-damask-wallpaper-pink",
+  "shopify_id": "6577176674355",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "in-house lines (SH sisal / Beverly Hills Damask) \u2014 no vendor catalog",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Phillipe Romano",
+  "mfr_sku": "GRS-3609",
+  "handle": "chanel-grass-on-metal-grs-3609",
+  "shopify_id": "1495175725168",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "original PR grasscloth/sisal; local crop dir GrassclothWallpaper.com/cropped-images (only GRS-3609 present, low-res)",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "The Set Decorator",
+  "mfr_sku": null,
+  "handle": "custom-print-the-set-decorator",
+  "shopify_id": "7832963088435",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "bespoke custom print \u2014 no catalog SKU",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "366924",
+  "handle": "versace-366924-wallcovering-versace",
+  "shopify_id": "7821709475891",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "370551",
+  "handle": "versace-370551-wallcovering-versace",
+  "shopify_id": "7821709541427",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "791755",
+  "handle": "versace-791755-wallcovering-versace",
+  "shopify_id": "7821709770803",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "935834",
+  "handle": "versace-935834-wallcovering-versace",
+  "shopify_id": "7821709803571",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "791333",
+  "handle": "versace-791333-wallcovering-versace",
+  "shopify_id": "7821709606963",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "791351",
+  "handle": "versace-791351-wallcovering-versace",
+  "shopify_id": "7821709672499",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Versace",
+  "mfr_sku": "791352",
+  "handle": "versace-791352-wallcovering-versace",
+  "shopify_id": "7821709705267",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "new-walls.com (upstream; keep Versace-branded)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34130",
+  "handle": "dwta-65622designerwallcoverings-los-angeles",
+  "shopify_id": "6948086874163",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Scalamandre",
+  "mfr_sku": null,
+  "handle": "parlor-velvet-pillow-lumbar-14x22-nougat-scalamandre",
+  "shopify_id": "7832784764979",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "scalamandre_pillows (scene7) \u2014 RESOLVED, lumbar Nougat attached",
+  "resolution": "ATTACHED this session (lumbar Nougat scene7, 1200x954); stays DRAFT"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT1407",
+  "handle": "dwta-65651designerwallcoverings-los-angeles",
+  "shopify_id": "6948087922739",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34110",
+  "handle": "dwta-65599designerwallcoverings-los-angeles",
+  "shopify_id": "6948086054963",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34103",
+  "handle": "dwta-65607designerwallcoverings-los-angeles",
+  "shopify_id": "6948086349875",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34148",
+  "handle": "dwta-65616designerwallcoverings-los-angeles",
+  "shopify_id": "6948086644787",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34152",
+  "handle": "dwta-65637designerwallcoverings-los-angeles",
+  "shopify_id": "6948087463987",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT1452",
+  "handle": "dwta-65648designerwallcoverings-los-angeles",
+  "shopify_id": "6948087824435",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Designer Wallcoverings",
+  "mfr_sku": "SH5027",
+  "handle": "tattiana-tightweave-jute-grs-9026",
+  "shopify_id": "1495215571056",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "in-house lines (SH sisal / Beverly Hills Damask) \u2014 no vendor catalog",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34122",
+  "handle": "dwta-65639designerwallcoverings-los-angeles",
+  "shopify_id": "6948087529523",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34158",
+  "handle": "dwta-65630designerwallcoverings-los-angeles",
+  "shopify_id": "6948087201843",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34156",
+  "handle": "dwta-65633designerwallcoverings-los-angeles",
+  "shopify_id": "6948087332915",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34155",
+  "handle": "dwta-65632designerwallcoverings-los-angeles",
+  "shopify_id": "6948087300147",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34151",
+  "handle": "dwta-65638designerwallcoverings-los-angeles",
+  "shopify_id": "6948087496755",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "LA Walls",
+  "mfr_sku": "83513",
+  "handle": "pradera-pink-vintage-floral-wallpaper-cgs-83513",
+  "shopify_id": "1498737344624",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "la_walls_catalog EMPTY \u2014 needs crawl",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "LA Walls",
+  "mfr_sku": "83509",
+  "handle": "barcelona-maroon-paisley-wallpaper-cgs-83509",
+  "shopify_id": "1498736459888",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "la_walls_catalog EMPTY \u2014 needs crawl",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34126",
+  "handle": "dwta-65619designerwallcoverings-los-angeles",
+  "shopify_id": "6948086775859",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34138",
+  "handle": "dwta-65625designerwallcoverings-los-angeles",
+  "shopify_id": "6948087005235",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34149",
+  "handle": "dwta-65635designerwallcoverings-los-angeles",
+  "shopify_id": "6948087398451",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34125",
+  "handle": "dwta-65641designerwallcoverings-los-angeles",
+  "shopify_id": "6948087595059",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34146",
+  "handle": "dwta-65613designerwallcoverings-los-angeles",
+  "shopify_id": "6948086546483",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34150",
+  "handle": "dwta-65636designerwallcoverings-los-angeles",
+  "shopify_id": "6948087431219",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "LA Walls",
+  "mfr_sku": "83510",
+  "handle": "barcelona-sand-paisley-wallpaper-cgs-83510",
+  "shopify_id": "1498736689264",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "la_walls_catalog EMPTY \u2014 needs crawl",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Gaston Y Daniela",
+  "mfr_sku": "GDW4856.007.0",
+  "handle": "dwkk-121617",
+  "shopify_id": "7419553120307",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "kravet.com / kravet_sku_images (DWKK, MAP pricing)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "LA Walls",
+  "mfr_sku": "83511",
+  "handle": "barcelona-champagne-paisley-wallpaper-cgs-83511",
+  "shopify_id": "1498736885872",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "la_walls_catalog EMPTY \u2014 needs crawl",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Phillipe Romano",
+  "mfr_sku": "GRS-7400",
+  "handle": "rough-weed-grasscloth-chocolate-brown-grass-and-jute-grs-7400",
+  "shopify_id": "1495159996528",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "original PR grasscloth/sisal; local crop dir GrassclothWallpaper.com/cropped-images (only GRS-3609 present, low-res)",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Phillipe Romano",
+  "mfr_sku": "GRS-3603",
+  "handle": "watsuya-wide-blade-grs-3603",
+  "shopify_id": "1495174381680",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "original PR grasscloth/sisal; local crop dir GrassclothWallpaper.com/cropped-images (only GRS-3609 present, low-res)",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Gaston Y Daniela",
+  "mfr_sku": "GDW4856.003.0",
+  "handle": "dwkk-121614",
+  "shopify_id": "7419552956467",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "kravet.com / kravet_sku_images (DWKK, MAP pricing)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Gaston Y Daniela",
+  "mfr_sku": "GDW5104.006.0",
+  "handle": "dwkk-121626",
+  "shopify_id": "7419553349683",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "kravet.com / kravet_sku_images (DWKK, MAP pricing)",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ },
+ {
+  "vendor": "Designer Wallcoverings",
+  "mfr_sku": "SH5023",
+  "handle": "kubuki-sisal-grs-9022",
+  "shopify_id": "1495214850160",
+  "live_status": "draft",
+  "live_imgs": 0,
+  "image_source": "in-house lines (SH sisal / Beverly Hills Damask) \u2014 no vendor catalog",
+  "resolution": "NEEDS-CRAWL (no good local image); tagged Needs-Image"
+ },
+ {
+  "vendor": "Anna French",
+  "mfr_sku": "AT34105",
+  "handle": "dwta-65600designerwallcoverings-los-angeles",
+  "shopify_id": "6948086120499",
+  "live_status": "active",
+  "live_imgs": 1,
+  "image_source": "thibautdesign.com (AT prefix); dead-upstream for the 23 gap SKUs but Shopify CDN images already present",
+  "resolution": "ALREADY-FIXED (active+imaged since 06-16 snapshot)"
+ }
+]
\ No newline at end of file
(oldest) · back to Imageless Rescue · Add republish memo + AF gap diagnosis (Thibaut not Cowtan; 2 f31b3a2 →