pal-e-docs

Phase 14: Receipt Intelligence

phase-mcd-tracker-14-receipt-intelligence Phase

phase
Project
Goal: Extract maximum value from receipt photos. Items purchased, prices, timestamps, store numbers, payment methods — rich data beyond survey codes.
Owner: Dev agent + Lucas (product decisions)
Repo: mcd-tracker-api
Depends on: Phase 5b (OCR — deferred, currently manual code entry)

Scope

  • OCR pipeline: Tesseract (self-hosted) or Cloud Vision (API) — decision deferred to this phase
  • Receipt parsing: extract line items, total, tax, store number, timestamp, payment method
  • Insights: most ordered items, average spend per visit, spending by location, visit frequency patterns
  • Optimal timing: when are BOGO codes most likely to have open slots at each location?
  • Data model: ReceiptItem table (receipt_id FK, item_name, price, quantity)
  • Privacy-first: all data stays on our infra, user can delete anytime
  • Feed gamification: "You've tried 23 different menu items" or "Your most ordered: Big Mac (8x)"

Deliverables

  • pending
  • plan-mcd-tracker — parent plan
  • phase-mcd-tracker-13-gamification — receipt data feeds gamification insights
  • phase-mcd-tracker-5a-receipt-model — receipt model + photo upload (foundation)