Full Custom Build Required - Training Company Back-Office Operations Platform (Supabase, EU-Based)

Posted yesterday

Worldwide

Summary

I'm a vendor-agnostic transformation consultant sourcing development quotes on behalf of a client. I am not the end client and I am not building this myself - I'm collecting quotes from a small number of vendors and presenting them to my client so they can choose who to work with. Please quote as you would to a client. The project: My client runs an Irish, PHECC-certified first aid and safety training company. Their bookings, customer records, certificates, renewals and invoicing are currently spread across Wix, spreadsheets, SumUp and email, which has caused double handling and booking errors. We need a single back-office application — the "Operations Hub" — built from scratch, bringing enquiries, bookings, contacts, certificates, renewals and invoicing into one place. This is a ground-up build. Please quote for the full application described below - do not assume any existing code, credentials or infrastructure to build on. Full scope: 14 core modules to be quoted: Dashboard — Daily overview: bookings this month, revenue trend, overdue invoice value, certificates pending, renewals due, a prioritised "needs you today" task list, and today's classes. Enquiries — Five-stage kanban board (new enquiry, dates offered, booked, delivered, invoiced) capturing every enquiry from the website and phone, with an automatic flag when a client has been offered dates but hasn't replied within three days. Bookings — Weekly class calendar with colour-coded classes, a clash warning, and an instructor availability panel synced with Google Calendar. Attendance — Records who attended each class, feeding certificate issue and renewal tracking. Contacts — Company and site-level customer records covering head office, individual sites, primary contacts, administrators/billing contacts and suppliers, with a full activity timeline and an account summary (balance, oldest invoice, annual value, payment terms). Learners — Individual attendee records and certification history, including the ability to move a learner between companies while keeping their certification history and an audit trail. Call Log — Phone call log with built-in transcription, an AI-generated summary and a snippet for each call, feeding the relevant contact's timeline. Certificates & Institutes — Register of certificates by awarding institute (e.g. PHECC), tracking status from awaiting signatures through to issued, with a paperwork-generation action. Renewals & Refreshers — Filterable list of learners due for renewal by course type, location and due date, with mail-merge based outreach and a tag for lapsed clients to win back. Invoices & Quotes — Quote and invoice tracking through a configurable, customer-linked pricing engine covering: base course rates by type/class size, travel and subsistence/room costs, supplier costs, discount rules, and margin visibility. Statuses for quote sent, invoiced, overdue and paid. Approvals — Queue of items awaiting the owner's sign-off (e.g. certificates ready to sign, reminder emails ready to send) before anything client-facing goes out. Automations — Automations built in n8n: overdue invoice reminders, renewal reminders three months out, a morning WhatsApp digest (owner-facing only), an enquiry "no reply in three days" chase, certificate return tracking, and social post suggestions. Integrations — Supabase (EU region, row-level security), Google Calendar (two-way sync), the confirmed invoicing platform (QuickBooks or SumUp — see open questions below), Wix (feeding enquiries in), Stripe/PayPal (online booking payments), WhatsApp Business API (owner digest only), and call transcription. Settings — User access, course and rate configuration, and account-level administration. Cross-cutting requirements — please account for these in your quote rather than pricing them as an afterthought: all data hosted in Supabase in the EU with row-level security; two-factor authentication; recorded consent captured before any client-facing WhatsApp or email communication; AI features (transcription, summarisation, automation logic) scoped and logged in line with the EU AI Act; GitHub for source control with standard secure development practice. Open questions to account for: a few items are still being finalised with the client — notably whether invoicing lands on QuickBooks or stays on SumUp, and what SumUp's API actually supports. Please state your assumptions on these where they affect your price, so we can compare quotes on a like-for-like basis. Out of scope for this build: asset tracking, rebuilding the Wix public website, client-facing WhatsApp/SMS beyond the owner digest, and a standalone learning management system. How your quote must be formatted: Because I'll be presenting your quote directly to my client alongside other vendors' quotes, please submit it as a document on your company's headed paper / letterhead, including your company details - I need a document I can pass on as-is. Within that document, please structure the quote as: A line item per module (not a single lump sum) - use the modules above, or your own logical grouping if you'd prefer to bundle closely related modules, as long as it's clear what's covered in each line What's included under each line item — the specific deliverables and functionality covered, so the client can see exactly what they're paying for All pricing in euro (EUR), stated as either fixed-price or hourly-rate-with-estimated-hours per line item — please be explicit about which VAT status — whether prices are VAT-inclusive or exclusive. A total for the full build described above An estimated delivery timeline, ideally per module or milestone Timeline We're looking to move quickly - please submit your quote as soon as you're able, ideally within the next few working days. Feel free to ask clarifying questions in the meantime. To apply Please submit your headed-paper quote in the format above.

  • Less than 30 hrs/week
    Hourly
  • 3-6 months
    Duration
  • Expert
    Experience Level
  • Remote Job
  • Complex project
    Project Type
Skills and Expertise
Mandatory skills
Lovable
Supabase
n8n
Automated Workflow
Activity on this job
  • Proposals:20 to 50
  • Interviewing:
    0
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since Sep 2, 2026
  • Ireland
    5:30 AM

Explore similar jobs on Upwork

OpenAI API
API Integration
Customer Relationship Management
Artificial Intelligence
Business Intelligence
WhatsApp Chatbot Marketplace DevelopmentFixed-price‐ Posted 4 months ago
PHP
JavaScript
HTML5
MySQL

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo