Schoolboy smiling at his desk in a classroom with classmates

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

01

Retire the spreadsheet

Every pricing rule lived in one workbook. Each had to become a rule the system could apply without anyone opening it.

02

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.

03

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.

04

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

A teacher smiling at her desk with a laptop

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.