`PENDING-APPROVAL-memo.md`

36 lines
# Pending Approval: mfr_sku Recovery — Zoffany (24) + Novasuede (14)
**Ticket**: TK-10677, TK-10794  
**Agent**: rescrape-agent  
**Date**: 2026-08-23 04:xx AM  
**Action**: APPROVE / REVISE / BLOCK

## Summary

Two vendors have ACTIVE products with null mfr_sku that can be recovered via LOCAL JOIN (no live scrape, $0):

### Zoffany — 24 products
- **Join key**: extract `DWZF-XXXXXX` from product handle → join `zoffany_catalog.dw_sku` → get real mfr_sku
- **Dry-run verified**: all 24 products matched and mfr codes confirmed (e.g. `ZFOW312943`, `ZHIW312996`)
- **SQL**: `~/Projects/mfr-recovery-2026-08-23/zoffany_mfr_recovery_APPLY.sql`
- **Reversible undo**: `UPDATE shopify_products SET mfr_sku='' WHERE vendor='Zoffany' AND status='ACTIVE' AND mfr_sku IN ('ZFOW312943','ZHIW312996','ZTOT312747','ZPHA312595','ZKEM312648','ZRHW312903','ZRHW312914','ZRHW312907','ZRHW312899','ZKEM312641','ZRHW312910','ZRHW312890','ZRHW312906','ZRHW312897','ZHIW312994','ZQUA310993','ZHIW313004','ZRHW312889','ZRHW312916','ZFOW312941','ZGUV08004','ZHIW312995','ZHIW313003','ZHIW312997')`

### Novasuede — 14 products (of 22)
- **Join key**: strip `-luxury-suede` suffix from handle → join `novasuede_catalog.mfr_sku`  
- **Dry-run verified**: 14 matches (Red, Lime, Gray, Lilac, Orange, Latte, Light Camel, Mauve, Navy, Rose, Mist x2, Green, Gold)
- **8 unmatched** (Sand, Spice, Abyss, Flame, Gentle Pine, Satin, Umber-copy, sand-dupe) — need live scrape or manual entry
- **SQL**: `~/Projects/mfr-recovery-2026-08-23/novasuede_mfr_recovery_APPLY.sql`

## Reversibility Gate Check
- [x] Reversible — undo is SET mfr_sku='' for identified ids
- [x] No externality — dw_unified local mirror write ONLY; Shopify write stays gated separately
- [x] Bounded — 24 + 14 = 38 rows total (under 500)
- [ ] GATED: dw_unified canonical mirror write per CLAUDE.md

**DECISION NEEDED**: APPROVE to run the APPLY SQL on the local dw_unified mirror.

## To Execute (after approval)
```bash
psql "host=/tmp dbname=dw_unified" -f ~/Projects/mfr-recovery-2026-08-23/zoffany_mfr_recovery_APPLY.sql
psql "host=/tmp dbname=dw_unified" -f ~/Projects/mfr-recovery-2026-08-23/novasuede_mfr_recovery_APPLY.sql
```