Three workstreams: (1) 74 missing Xtricity items added with gold content + images, (2) Jessar's 3 review files analysed & graded, (3) lifestyle/packaging photos matched to products. Honest quality read + gaps below.
Missing Xtricity bulbs, CFLs, fixtures, fans & outdoor lights. Content sourced from WordPress spec tables (65) + product names (9), generated to match the live Xtricity gold schema (romance + spec-led bullets + Features/Specifications body + wattage/voltage/lumens/base metafields). All ACTIVE, vendor Xtricity, SKU + UPC barcode set.
LED GU10 Spotlight — 7W (50W eq.), 500L, 3000K Soft White, Dimmable).40301–40320 are cabinet handles ("Stanley"), not Xtricity — excluded from this run and flagged separately.All edits from Taniya, Billy & wadad, compared 3-way (what we sent → their edit → what's live). Key finding: their edits are NOT superseded — live is behind the file we sent them, so their structural fixes are genuine upgrades.
review_apply.py, per-reviewer/per-group, not fired. Yours to greenlight after relaying to Jessar.Matched by SKU to live products. LIFESTYLES + 3D → gallery; PACKAGING → box_image (only where empty, never overriding). Dedup: colliding filenames get a -2 suffix.
Sean's spot-check (1-40231) exposed a systemic gap: live carried v1 romance, raw titles and empty certifications — the v2 gold layer (which Jessar reviewed) was never pushed. A deterministic audit (all 1,667 SKUs classified per field vs v1/v2, plus a forensic push-history reconstruction) confirmed clean boundaries: descriptions & bullets were 100% gold-v2; romance/titles/certs never left the file. Sean approved the sync 11 July.
work/title_backup_2026-07-11.csv.work/romance_backup_2026-07-11.csv.review_apply.py --group structural runs them.