feat(automation): Wire up Price Drop / Spike Alerts Cron Job

[rushikesh-bobade]

Problem Statement

The price-alerts.tsx route exists in the frontend, but users cannot actually subscribe to an item and receive notifications when the market price spikes or drops. This automation is crucial for a complete reselling experience.

Proposed Solution

Connect the PriceAlertsQuickAdd UI to the backend, save alert thresholds to the database, and update the cron job (api.cron.prices.ts) to trigger email or system notifications when a scraped price crosses a user's target threshold.

Acceptance Criteria

1. Database Schema: Ensure the Prisma schema has a PriceAlert model linked to a User and a sku, storing a target price and condition (e.g., GREATER_THAN or LESS_THAN).
2. Backend API: Create a new Remix action in market-prices.tsx to handle saving/deleting alerts.
3. Cron Job Integration: Modify api.cron.prices.ts to check all active alerts after fetching new prices, and log a notification if a threshold is crossed.
4. UI Validation: The PriceAlertsQuickAdd component should show active alerts and allow users to delete them.

Technical Hints

• For now, simply logging the alert to a new Notification Prisma table (or console logging for MVP) is acceptable. Email integration (e.g., Resend) can be a separate issue.

[rushikesh-bobade]

@shrutig-blip I assigned you this issue so you can get started right away since the blog bug was already claimed! Feel free to ask any questions here and open a Draft PR when you're ready to start building the Price Alert notifications. Happy coding!

[shrutig-blip]

Thanks for assigning this! I'll start by understanding the existing implementation and work through the feature step by step. I'll open a Draft PR once I have the initial implementation in place. If I run into any questions while understanding the current flow, I'll ask here.

[github-actions]

Hi @shrutig-blip! 👋

Thank you for your interest in contributing to this repository! Please wait until a maintainer officially assigns you to this issue before opening a Pull Request.

While you wait, please consider starring ⭐ this repository to show your support! We review requests regularly and will assign it as soon as possible if it's available. Happy coding! 🚀

[karrisanthoshigayatri]

Hi @rushikesh-bobade ,

I would like to work on this issue as part of ECSOC 2026.

Approach: I plan to add the PriceAlert database model, connect the PriceAlertsQuickAdd UI with backend actions for creating/deleting alerts, and update the cron job to check thresholds and log notifications when prices cross the target values.

Thank you!

[rushikesh-bobade]

Hi @karrisanthoshigayatri,

Thank you for the interest! Unfortunately, this issue is already officially assigned to @shrutig-blip, who is currently working on the Draft PR. To prevent duplicate work and merge conflicts, we only assign one person per issue.

However, since you clearly have a strong grasp of our Prisma and backend architecture (as I saw in your fantastic analysis of the slow navigation bug!), we would love to have you tackle another backend or performance optimization issue. Feel free to browse the open issues and drop a comment on one that isn't assigned yet.

Thanks again for being so proactive!