Real-time car deal detection system built for Latvian marketplace SS.LV:
PROBLEM SOLVED:
- Manual searching through 1000+ daily car listings is time-consuming
- Hard to know true market value without comparing dozens of similar cars
- Missing good deals because they sell within hours
SOLUTION:
- Automated scraping every 15 minutes (2,880 checks/month)
- 50,000+ car database with median price calculation (not skewed by outliers)
- Instant Telegram alerts when deals appear (15%+ discount)
- Daily digest reports at 20:00 with statistics and top deals
TECH STACK:
- PHP for scraping & processing
- MySQL database (15K+ records, growing daily)
- Telegram Bot API for instant notifications
- Cron jobs for automation
- MEDIAN algorithm (professional real-estate approach, not average)
KEY FEATURES:
- Smart duplicate prevention
- Fuel type matching (diesel vs petrol comparison)
- Year range tolerance (±1 year)
- Minimum comparable cars threshold (5+)
- Historical deal tracking (2,000+ deals found)
- WhatsApp & Telegram sharing
- Anti-cache system for fresh data
- 7-day log rotation
RESULTS:
- 50,081 cars in database
- 5,039 good deals identified
- Average discount: 25-50%
Could the same be done for auto24? How much work would it take to use the existing solution?