Contact person: Business Client

Phone:Show

Email:Show

Location: Crystal Lake, United States

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"PROJECT DESCRIPTION

I am looking for a full-stack developer (or team) to build a production-ready web platform that automatically tracks every Sports Card and Pokémon card show in the United States, updates daily, and sends email/SMS alerts to users about shows near them.

This platform will combine:

Web scraping

A clean frontend directory

A secure admin backend

A geolocation engine

Radius alerts via email/SMS

Vendor and attendee user accounts

I need someone who can handle end-to-end development: backend, frontend, database, scraping, cron jobs, and deployment.

WHAT THE PLATFORM SHOULD DO
1. Automatically Scrape Card Show Data Daily

Scrape show information from public card show sources, including:

Beckett Venue Manager

[login to view URL]

Additional sources added over time

Scraper requirements:

Use Axios/Cheerio or Puppeteer

Extract event name, date, address, city, state, venue, website link

Normalize and clean data

Deduplicate based on title, date, and location

Save to the database

Mark new shows as “Pending Admin Approval”

Run automatically every 24 hours via cron

2. Admin Panel (secured)

Admin should be able to:

Review scraped shows

Approve or reject shows

Edit any show

Add shows manually

Delete shows

View analytics such as number of alerts sent and number of shows scraped

3. User Accounts (Attendees and Vendors)

Signup form should collect:

Full name

Email

Phone

ZIP code

Password

Role: Vendor or Attendee

Vendors should be able to:

Create and maintain a vendor profile

Add their shows manually

Edit their own submissions

Users should be able to:

Log in

Manage their location and alert preferences

View saved and nearby shows

4. Show Directory (Public Facing)

Create a clean, searchable directory of all approved shows.

Features:

Search by title, city, or state

Filter by state

Filter by date range

List and optional map views

Individual show pages containing title, date, venue, address, map, promoter details

5. Location-Based Alerts (Email and SMS)

When users sign up, they enter their ZIP code.

The system should:

Convert ZIP to latitude/longitude

Store their preferred radius (default 50 miles)

Allow users to change the radius (10/25/50/100 miles or nationwide)

The daily or weekly alert job should:

Check all upcoming approved shows

Compare distance from user to show using the Haversine formula

Email or SMS users about shows within their radius

Log alerts to avoid sending duplicates

Email provider: SendGrid or Resend
SMS provider: Twilio

6. Preferred Technology Stack

The ideal stack (flexible based on developer experience):

[login to view URL]

Tailwind CSS

PostgreSQL (Supabase or RDS)

Prisma ORM

NextAuth for authentication

Vercel Cron Jobs or an external cron system

Axios + Cheerio for scraping (or Puppeteer if necessary)

Alternate full-stack solutions (Laravel, Django, Express, Rails) are acceptable with justification.

FEATURE SUMMARY

Daily automated scrapers from multiple sources

Admin approval workflow

Attendee and vendor user accounts

Nationwide show directory and detail pages

Geolocation and radius-based filtering

Email and SMS radius alerts

Clean mobile-responsive UI

Robust backend and API structure

Deployable in a production environment

DELIVERABLES

Fully functioning deployed website

Admin credentials and documentation

Daily scraping automation configured

SMS and email alert system operational

Database schema documentation

Source code delivered through GitHub

Ability to easily add new scrapers in the future

Modern, clean UI and fast performance

REQUIRED SKILLS

Strong web scraping experience

Full-stack development capability

API development

Database design and modeling

Experience with [login to view URL], Tailwind, and Prisma (preferred)

Geolocation and distance calculation logic

Twilio SMS integrations

Email sending services (SendGrid or Resend)

Cron jobs and backend automation

Admin dashboard interface development

BONUS SKILLS

Experience with sites that implement anti-bot measures

Experience building event directories

Mapbox or Google Maps integration

UI/UX design capabilities

APPLICATION QUESTIONS (Please Answer)

Have you built automated scrapers before? Provide examples.

Have you built platforms with automated email/SMS alerts?

What tech stack would you use for this project and why?

What is your estimated timeline for an MVP?

Provide examples of your cleanest production code.

ADDITIONAL NOTES

This platform is intended to become the leading nationwide directory for sports card and Pokémon card shows, with long-term monetization opportunities including:

Vendor advertising

Sponsorship packages

Marketplace fees

Promoter partnerships

I am ready to hire immediately for the right developer." (client-provided description)