Case study · Custom glazing

From thousands of Excel workbooks to one survey-to-order system

A custom secondary glazing business ran its surveys on Excel. Every job had its own workbook, with measurements, pricing, quote maths and PDF output all inside it. We moved that work into Retool apps for the office, a React portal for partners and one Supabase database underneath, connected to the company’s WooCommerce store.

The challenge

What wasn’t working

Each pane survey lived in its own Excel workbook, and there were thousands of them. Finding an old pane meant finding the right file first.

Older workbooks carried older prices, so reusing one could quietly produce a wrong quote.

Once a quote was accepted, someone typed the details again into a separate order book. That second round of typing is where mistakes and missing history crept in.

The solution

What we built

Survey upload and review

Retool apps where the office uploads surveys, reviews them and searches the history of every pane measured.

A workbook that feeds the database

We redesigned the measurement workbook so it produces a structured “DB Output” for each pane, ready to load instead of retype.

Quotes and orders

Quote versions, snapshots of accepted orders, production statuses and the cutting and acrylic exports production needs.

Partner portal

A React portal where partners see their own information, signed in through Firebase Authentication.

Shared Supabase database

One PostgreSQL data layer on Supabase, linked to the existing order and remuneration apps, with proper relationships between records.

Store and automation links

Orders and their details go to WooCommerce through its REST API, and Zapier handles webhook-driven transfers where the team wanted them.

How it works

How a survey becomes an order

  1. 1

    Survey captured

    The surveyor measures each pane in the redesigned workbook.

  2. 2

    Uploaded and reviewed

    The structured output is uploaded to Retool, checked and saved to Supabase.

  3. 3

    Quoted

    A quote is built on current pricing, and every version is kept.

  4. 4

    Ordered

    The accepted quote is snapshotted as an order and synced to WooCommerce.

  5. 5

    Made and paid

    Production statuses, cutting exports and partner remuneration all run from the same records.

Screens

Inside the build

The result

What changed

  • Pane and survey history is searchable instead of buried in workbooks
  • Accepted quotes flow into orders without retyping
  • Quotes use current pricing, with every version kept
  • Partners get their own portal instead of emails and spreadsheets

Have a project like this?

Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.

Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day