Skip to main content
Steigern Tech - Technologies Inspire Us
All Case Studies
SPORTS & EDUCATION TRANSFORMATIONOdoo PodEducation

Dublin University Football Club: Odoo website with Google Sheets fixtures and AI match tables

We took Dublin University Football Club (Trinity Rugby) from Figma to a live Odoo website with Google Sheets fixtures and league tables, AI-built match tables, a club shop and event booking.

Dublin University Football Club: Odoo website with Google Sheets fixtures and AI match tables Project Thumbnail
Client
Dublin University Football Club (DUFC)
Location
Dublin, Ireland / Steigern Client
Industry
Sports & Education
Timeline
8–16 Weeks
Engineering Pod
3 Verified Engineers
Status
Live in Prod
01
100%
Milestone Delivery
On schedule
02
Real-Time
Google Sheets Fixture Sync
Automated
03
AI-Powered
Match Table Creation
Direct in Odoo
Operational Challenges

The Moment That Started It

Dublin University Football Club is the oldest club in the world in continuous existence, founded in 1854. Its website is run by volunteers: students, alumni and committee members who have a match on Saturday and exams on Monday. Every week someone had to update fixtures, results and the league table across seven teams by hand. When that person was busy, the website fell behind and supporters turned up for kick-offs that had moved.

Identified Bottlenecks:
Volunteers found website editing slow and technical
Building each round of fixtures by hand took hours
Club income came through many separate channels
Events were announced but hard to book
The new design existed only as Figma files
Steigern Architectural Solution

Engineering Solution & Architecture

We took Dublin University Football Club (Trinity Rugby) from Figma to a live Odoo website with Google Sheets fixtures and league tables, AI-built match tables, a club shop and event booking.

Architectural Highlights:
Fixtures, results and league tables are kept in a Google Sheet they already know; the Odoo website reads it automatically
Staff describe the round in plain words; AI drafts the match rows in Odoo and flags venue clashes before publishing
One Odoo shop sells merchandise, wine, yearbook ads, memberships and match sponsorships
Events can be filtered by team, type and date, and booked or RSVP'd online
The Figma design was built pixel-close on the Odoo website builder so volunteers can edit pages without code
SYSTEM ARCHITECTURE WORKFLOW

Execution Architecture & System Flow

The end-to-end technical and operational workflow engineered for Dublin University Football Club (DUFC).

STEP 01

Design to build

The club's Figma designs became editable Odoo website pages: home, events, news, fixtures, results, game day, shop and join.

STEP 02

Google Sheets sync

Each team has a tab in one spreadsheet. The website pulls fixtures, results and the AIL league table from it.

STEP 03

AI match tables

An admin types something like "add the November rounds for the 1st XV". The AI drafts the rows, checks College Park bookings and suggests time changes where games clash.

STEP 04

Publish

One click publishes the approved fixtures to the website.

STEP 05

Game day

Supporters buy a €10 match ticket, see the team sheet, donate and join the club from one page.

Dublin University Football Club: Odoo website with Google Sheets fixtures and AI match tables — Flagship System Architecture
Dublin University Football Club (DUFC): Odoo Website Redesign & AI-Powered Fixtures Management
Dublin University Football Club (DUFC) — Overview
dufc Screen 01
Dublin University Football Club (DUFC) — Odoo Website
dufc Screen 02
Dublin University Football Club (DUFC) — Google Sheets Fixtures Tables
dufc Screen 03
Dublin University Football Club (DUFC) — AI Match Tables Odoo
dufc Screen 04
Dublin University Football Club (DUFC) — Club Shop
dufc Screen 05
Dublin University Football Club (DUFC) — Events
dufc Screen 06
THE DELIVERY BLUEPRINT

How Steigern Architected & Shipped This Solution

A battle-tested 4-phase agile delivery model combining architectural discovery, rapid prototyping, production hardening, and zero-downtime transition.

01

Architecture & Discovery

Deep-dive technical workshops, system schema profiling, API audit, and non-functional requirements (NFRs) specification.

02

Agile Pod Sprint Delivery

Bi-weekly deliverables with working builds, automated unit/widget testing, CI/CD testflight builds, and daily asynchronous standups.

03

Hardening & Benchmarks

Chaos engineering, concurrency load tests (JMeter/k6), memory profiling, vulnerability scans, and offline resiliency validation.

04

Zero-Downtime Rollout

Canary deployment, multi-region database migration, telemetry alerting setup, staff runbooks, and 24/7 post-launch SLA support.

PROBLEM → SOLUTION TRANSFORMATION

The Real Problem vs What The System Does

A direct 1-to-1 comparison between operational bottlenecks and custom software capabilities engineered for Dublin University Football Club (DUFC).

The Real Problem

Volunteers found website editing slow and technical

What The System Does

Fixtures, results and league tables are kept in a Google Sheet they already know; the Odoo website reads it automatically

The Real Problem

Building each round of fixtures by hand took hours

What The System Does

Staff describe the round in plain words; AI drafts the match rows in Odoo and flags venue clashes before publishing

The Real Problem

Club income came through many separate channels

What The System Does

One Odoo shop sells merchandise, wine, yearbook ads, memberships and match sponsorships

The Real Problem

Events were announced but hard to book

What The System Does

Events can be filtered by team, type and date, and booked or RSVP'd online

The Real Problem

The new design existed only as Figma files

What The System Does

The Figma design was built pixel-close on the Odoo website builder so volunteers can edit pages without code

ENTERPRISE TECH SPECIFICATION

Production Technology Stack

Every library, database engine, and infrastructure provider was audited for latency, stability, and zero vendor lock-in.

Core Technologies

Odoo WebsiteOdoo eCommerceOdoo EventsGoogle Sheets APIAI assistant for fixture generationFigma design handoff
PRODUCTION RESULTS & ROI

Quantified Business Outcomes & Impact

Volunteers update fixtures in a spreadsheet and the website follows, saving volunteers 8–10 hours of manual data entry every match week. • New fixture rounds are drafted in minutes rather than built row by row. • Shop, memberships, sponsorships and event bookings run through one system, processing over €45,000 in unified digital payments and tickets during the first season.

Volunteers update fixtures in a spreadsheet and the website follows, saving volunteers 8–10 hours of manual data entry every match week.
New fixture rounds are drafted in minutes rather than built row by row.
Shop, memberships, sponsorships and event bookings run through one system, processing over €45,000 in unified digital payments and tickets during the first season.

Shipped Project Deliverables & Handover

Odoo Website Design & Development
Google Sheets Integration
AI Implementation
Workflow Automation
FREQUENTLY ASKED QUESTIONS

Frequently Asked Questions

Essential operational and architectural answers regarding the system engineered for Dublin University Football Club (DUFC).

Yes. Here the Odoo website reads each team's fixtures, results and the league table from a shared Google Sheet, so volunteers never edit web pages for scores.
PORTFOLIO EXPLORATION

Related Case Studies

View All Stories

Ready to achieve similar results for your product? Let's engineer your solution.

Connect directly with our senior software architects. We will analyze your architecture, estimate velocity, and formulate a delivery blueprint within 24 business hours.

Request Architectural ScopingExplore Our Full Bench
24-Hour Scoping SLA · Ahmedabad · Melbourne
AI Advisor