Build Client Portal + Admin Dashboard for Service Business (Supabase/React or No-Code)

LUVTrader — MVP Build Specification Request for Quote — June 2026 Overview LUVTrader is an established board-clearing service for Southwest Airlines flight attendants with an active recurring client base. We are looking for a developer or small development team to build a web-based operational platform — an MVP that replaces our current manual Google Sheet workflow and creates a client-facing portal. This is a build-for-hire project. The client (business owner, LUVTrader owner) retains 100% ownership of all code, data, and intellectual property upon completion. We are requesting quotes from multiple developers. Please read the full spec before quoting. What We Need Built 1. Three User Views with Role-Based Access Admin View (business owner) View, add, edit, pause, or cancel clients Change client status (active / TAP / TAP retainer / paused / single month / assisted) Enter monthly estimate per client → triggers automated email to client One-button send of TAP offer email to all eligible clients simultaneously See full financial picture across all clients (estimate, paid, balance, credit) View each client’s trip board and sale history Override or preview any automated message before it sends Internal notes field per client Admin flags for missing data, missing payment, or unusual situations Operations View (admin user — daily admin user) View all active clients and their full trip list for the month Mark individual trips as Sold and enter the sale amount Running balance updates automatically as trips are marked sold View client contact info, payment method, posting notes, and rotation group Add internal notes to any client record Flag anything unusual for business owner This view replaces the current Google Sheet as the daily working tool Client View (clients.luvtrader.com) Secure login with email and password See their board — which trips are active, which are sold See what each sold trip sold for See current balance (what they’ve paid vs. what they owe or are owed) Payment instructions (static — Venmo/PayPal/Zelle links) Mobile-friendly layout (most users are on phones) 2. Automated Messages The following messages currently go out manually. The platform should send them automatically based on triggers. All message templates will be provided — the system just needs to populate client-specific data and send. Trigger Action Business owner enters monthly estimate for a client Client receives estimate email with balance due and payment instructions Admin marks last trip on a board as Sold Client receives end-of-month billing or refund email Client’s RT month is next month Client receives RT bidding reminder email on the 8th of prior month Business owner hits one-button TAP All eligible clients receive TAP retainer offer email send simultaneously Client status changed to TAP Client receives TAP retainer offer email Refund calculated Client receives refund/credit choice email Messages must pull client-specific data (name, balance, trip dates, payment info) so each message feels personalized, not generic. Business owner needs the ability to preview any automated message before it sends, or toggle instant-send on a per-message basis. 3. Data Structure (per client record) Employee number Base CWA name / legal name Email and phone Payment method info (PayPal / Venmo / Zelle) Trip dates and trip type (reserve block / 2-day / 3-day / etc.) Rotation group (for internal posting stagger system) Monthly estimate (entered by admin) Amount paid by client Trip sale log (date sold, amount sold for, running total) RT month (triggers automated reminder) Subscription type (premium $250 / single month $300 / TAP retainer $75 / assisted $75) Client status (active / paused / single month / TAP / TAP retainer) Internal notes field Message log (what was sent and when) 4. TAP Status Handling TAP (Time Away Program) is a Southwest program where flight attendants take a month off work. When a client takes TAP: Their status changes to TAP or TAP Retainer Their board goes inactive in the operations view They drop out of the active rotation An automated TAP retainer offer email fires When TAP ends, their status reactivates for the following month This needs to be manageable without manual intervention beyond business owner changing the status. 5. Email Migration (Separate Line Item) business owner’s business email is currently hosted on a third-party server. It needs to be migrated to Google Workspace (~$6/month, business owner pays directly). What is needed: Set up Google Workspace for owners email Update MX records in the domain DNS settings to point to Google Confirm routing is correct before old server is touched Zero disruption to current email during transition Please quote this as a separate line item. 6. Technical Requirements Portal URL: clients.luvtrader.com (subdomain of existing domain — existing site stays untouched) Domain: Owner holds luvtrader.com on Squarespace — developer only needs a DNS record pointed to their server Design reference: An HTML/CSS mockup will be provided as visual reference. Southwest blue (#003594), yellow (#FFBF27), Montserrat font, “A Clear Board Is a Happy Board” tagline Mobile first: Most clients are on iPhones — must work cleanly on mobile Documentation required: Basic technical documentation and SOP so the platform can be handed to another developer if needed Ownership: All code and IP transfers to business owner upon final payment What Is NOT Included in This MVP Please do not quote for the following — these are future phases: AI chat SMS/text automation (email only for now) Advanced analytics or reporting Full public website rebuild Automated payment processing Team delegation workflows beyond business owner and one ops user Success Criteria The primary objective of this MVP is to eliminate the existing Google Sheet as admin user’s daily operational tool while reducing routine communication between business owner and clients. This is an operational improvement project, not a complete software platform. Future enhancements will be considered after the MVP is successfully deployed. Quote Format Requested Please provide: 1. 2. 3. 4. MVP build fee — total cost and payment milestone structure Timeline — realistic delivery estimate for a working MVP Monthly maintenance/hosting — ongoing cost after launch Email migration — separate line item 5. What you need from us — data export, design files, access, etc. 6. Your relevant experience — any similar platforms you’ve built About the Business LUVTrader has been operating for over a decade with a strong recurring client base and consistent monthly revenue. This is not a startup idea — it is an established business investing in infrastructure. We are looking for a reliable developer who can build it cleanly, document it properly, and maintain it long term. We are requesting quotes from multiple developers and will make a decision based on price, timeline, and fit.