Price Alerts

Purpose: Explain how users configure price alerts and how the system processes them. Audience: Product, Developer Prerequisites: Authenticated user; Supabase functions enabled.

Overview

• Users can create alerts on listings or search criteria; the system checks price changes and notifies users.

Core screens

• User UI: src/pages/PriceAlerts.tsx
• Admin UI: src/pages/admin/AdminPriceAlerts.tsx

Backend and data

• Tables (see supabase/backups/remote-schema.sql):
  • public.price_alerts (CREATE at ~2768)
  • public.price_alert_events (CREATE at ~2727)
  • public.price_alert_runs (CREATE at ~2751)
• Scheduled function: supabase/functions/run-price-alerts/index.ts triggers periodic checks and records events.

Flow

• User creates an alert → Alert stored in price_alerts.
• Cron/edge function runs → Compares current prices → Inserts price_alert_events for matches.
• Notifications (email or in-app) are sent; Admin can review in the admin page.

Next steps

• See docs/operations/monitoring.md for monitoring function health.
• See docs/features/notifications.md for notification delivery.