Affiliate Command Center is live at https://affiliate-tawny-rho.vercel.app — a password-gated dashboard to manage affiliate programs, track short-link redirects, log commissions, and break down revenue per MVP.
What it does: Five integrated pages — Dashboard (overview stats), Programs (CRUD for partner programs like PartnerStack, Vercel, Stripe), Links (short-link codes with click tracking), Commissions (paid/pending per program), and MVPs (per-product revenue breakdown). The /r/[code] redirect handler works in production with a static fallback — no database required for link redirects.
Database: Turso serverless SQLite (affiliate-cc database). Schema has 5 tables with proper indexes. The app auto-initializes the schema and seeds default data (5 programs, 4 MVPs, 2 sample links) on first connection.
Tech stack: Astro 6 + React 19 + Tailwind CSS 3 + TypeScript. Dark-first design matching byjtt.com’s zinc/purple aesthetic. Vercel deployment with @astrojs/vercel adapter. Password auth via env var (no multi-user).
PartnerStack profile: Logo uploaded (300×300px JT lettermark, dark rounded square with purple accent). Profile at 88% complete — needs “What should program managers provide?” field filled in.
Next: Fill remaining PartnerStack profile fields. Start adding real affiliate links. Connect PartnerStack API for auto-imported commissions.