← back to Fentucci Naturals

evidence/tk11943/FINDINGS.md

47 lines

# TK-11943 — Fentucci Naturals "$0.00 sellable Per-Yard price" — VERIFY-BEFORE-ACT findings

Date: 2026-09-20  Agent: night-TK-11943  Store: designer-laboratory-sandbox (LIVE prod DW)

## Ticket premise
462/504 ACTIVE Fentucci Naturals "Per Yard" products carry a $0.00 sellable price →
suspected live free-checkout money bug (like TK-11758 Latigo). Verify availableForSale.

## What was measured (LIVE Shopify Admin GraphQL, all 462 products, not a sample)
- LIVE RISK (per-yard $0 AND availableForSale=true): **0**
- GUARDED (per-yard $0 but availableForSale=FALSE): **462** (100%)
- Every $0.00 Per-Yard variant: inventoryPolicy=DENY, inventoryQuantity=0 → availableForSale=false → NOT checkout-orderable.

## Conclusion: NOT a live free-checkout bug.
The mirror's min_variant_price=0 is the raw variant price, but the variant is unbuyable.
No customer can check out for $0. The author's own suggested "DENY" remediation is ALREADY the live state.

## Line context
- All 504 ACTIVE Fentucci Naturals are metafield custom.price_mode = "quote_only".
- The 42 "clean" ACTIVE ones (min_variant_price=4.25) have NO Per-Yard variant at all — only the $4.25 Sample.
  => The canonical DW end-state for this quote-only line is SINGLE-VARIANT (Sample only).
- The 462 carry a vestigial $0.00 Per-Yard variant.

## Residual (non-emergency) issues on the 462
1. COSMETIC: storefront publicly displays "Per Yard $0.00" (unbuyable, but looks broken/unprofessional).
2. LATENT LANDMINE: a future inventory-stamp job flipping the Per-Yard qty>0 (the recurring TK-11357 $0-orderable
   re-stamp class) would flip availableForSale=true and THEN create a live $0 free-checkout bug.

## Recommended gated remediation
Delete the 462 vestigial $0.00 Per-Yard variants so all 504 ACTIVE match the 42 clean Sample-only siblings.
Restore-map (per-yard variant gid, sku, price, inventory state) captured for full reversal.
Gated (canonical customer-facing Shopify write) → pending-approval memo, NOT auto-fired.

## Artifacts
- per-yard-restore-map.json — 462 rows, full variant definitions for reverse.
- live-variant-scan.json — raw live scan output.

---
## EXECUTED 2026-09-20 — Option A applied (Steve-approved)
- Deleted 462/462 vestigial $0.00 Per-Yard variants (3 canary + 459 batch), 0 skipped, 0 failed.
- Per-variant safety re-assertion before each delete (only deleted if still $0 + availableForSale=false + Sample present).
- Final LIVE re-measure of all 462: sampleOnly=462, stillHasPerYard=0, orderableZeroRemaining=0, stillACTIVE=462.
- All 504 ACTIVE Fentucci Naturals now consistent (Sample-only), matching the 42 clean siblings.
- Ledgered: 462 rows in ~/.claude/yolo-queue/executed-reversible/ledger.jsonl (ticket TK-11943).
- Undo: recreate any variant via productVariantsBulkCreate from evidence/tk11943/per-yard-restore-map.json.
- Note: local dw_unified mirror (min_variant_price=0) will self-correct on next Shopify->Mac2 sync (Shopify is authoritative).