
Case study · Local authority
Services for Schools
Head teachers order services direct from the borough of Hounslow. Ordering stayed simple for occasional users while the reporting behind it got serious.
- Client
- London Borough of Hounslow
- Sector
- Local authority
- Scope
- Ordering and reporting platform for schools
- Pricing inputs
- More than 10 per school
The problem
The London Borough of Hounslow offers a wide range of services to its schools. Head teachers order them directly from the borough, and they always have a lot else on.
The price of each service depended on more than ten factors per school, and the only reliable way to work one out was to open "the spreadsheet". Quoting was slow, depended on the few people who understood it, and none of it fed the borough's sales reporting.
What we had to solve
Retire the spreadsheet
Every pricing rule lived in one workbook. Each had to become a rule the system could apply without anyone opening it.
Occasional users, busy people
Heads order rarely and in a hurry. The ordering journey had to make sense on the first visit of the year without training.
One price, everywhere
The price a school saw had to be the price on the order, the invoice and the monthly report, with no rekeying in between.
Control stays with the borough
Service teams needed to change their own offers and prices without a developer, and without breaking anyone else's.
What we built

An ordering platform built on Drupal's eCommerce tools. When a school signs in, every price recalculates from that school's own pricing factors, so heads see what they will actually pay, not a rate card to interpret.
The same figures flow from purchase through to the borough's monthly sales reports. One complex pricing model, applied once, in one place.
Automated pricing
More than ten factors per school, applied as rules rather than looked up by hand.
School accounts
Each school signs in and sees its own prices and order history.
Reporting that matches
Orders flow straight into the borough's monthly sales reports.
Borough-managed offers
Service teams update their own services and prices.
The outcome
Quoting no longer depends on the spreadsheet or the people who understood it. Feedback from the borough's teams and from schools themselves comes back to the same word: simple.
Got a process like this?
Applications, assessments, panels and deadlines. Thirty minutes on the phone is usually enough to tell you whether it is a six month job.



