African Creative - Staging Progress Recheck (Phase 2)

Methodology. Staging's public product search (/api/shop/search) doesn't require a login, and we confirmed its listed price matches the live wholesale price exactly whenever a product is correctly configured and has no variants - so code and price could both be checked without touching any credentials, and every staging link above was generated live from that search rather than reused from the original audit (the site's URL scheme has changed since Phase 1, so old links no longer resolve). Live-side ground truth came from the wholesale export CSV (acw-products-...csv) and the original audit's own admin-verified findings (the same source data behind the original 08_Staging_vs_Live_Discrepancy_Report), matched by product code. Items are marked "Still Open" only where staging has a specific, fixable problem against a clean live product; items moved into "Live-Database Issues" were re-checked individually against the original audit's admin data and confirmed to be live-side record problems (inactive duplicates or code collisions) that staging cannot possibly resolve until Jason's database is cleaned up first - these were previously lumped in with staging's open issues, which wasn't an accurate way to frame them. As a final QA pass, we also cross-checked the "Still Open" items directly against staging's authenticated /vault admin (your wholesale login session was still active) - every price and code figure matched the public search API exactly, with no discrepancies found. That pass also surfaced a useful detail on 3 records (Bone Teaspoon, Cameroon Oblong Shield Small, and one Bokkie Head Wall Decor variant): each already has the correct live code stored internally in a hidden salesforce_id field, it's just never been synced to the customer-facing code - noted inline above, since that's a smaller fix for Monza Media than a fresh remap. Correction from the previous version of this report: on a closer double-check, we found the public search API and the vault admin can return different flat "price" values for the same staging product whenever it has multiple variants (size/colour options) - each endpoint appears to surface a different variant as its default. Checking the live CSV's per-variant pricing (not just its single base wholesale_price field) caught one case where this mattered: Schnapps Glass Set Of 4 was wrongly flagged as a price mismatch (R825 vs R865) when in fact all 7 of live's pattern variants are priced at R865, exactly matching staging - it's been moved to Confirmed Resolved. The same variant-price ambiguity means the two Malawi Rattan furniture items and the Kuba Cloth shield, while their duplicate-code bugs are definitely fixed, couldn't be fully certified price-correct across every single variant - they've been moved into their own "needs a manual spot-check" group rather than stated as fully resolved. Given the volume (331 flagged items), the biggest families of duplicate-code items (colour/size variants sharing one SKU) were confirmed fixed via representative samples across each family rather than clicking through every single variant - if anything in the "Confirmed Resolved" list needs a specific double-check, just flag which one and we'll verify it individually.