All work

Case Study — Food Distribution / Legacy Modernization

SGC BidBase

Modernizing a Critical Foodservice Bidding System Without Disrupting the People Who Use It

Replaced a 1990s Microsoft Access foodservice bidding system with a secure web application designed so experienced salespeople could become productive with minimal instruction.

Role

Lead UX Designer

Company

TAP Developers

Platform

Web Application

The Challenge

For decades, SGC Foodservice relied on a Microsoft Access application developed in the 1990s to create, manage, and track foodservice bids for schools throughout the region. While the application had become deeply embedded in the sales organization’s workflow, its aging technology limited scalability, maintainability, and the ability to support the business as it evolved. The challenge was not simply to replace an old application with a new one—it was to modernize a mission-critical business process without disrupting the experience and expertise of the salespeople who depended on it every day.

Our team immersed ourselves in the existing workflow, observing how bids were created, managed, and tracked, and worked closely with key stakeholders to identify what needed to change—and, just as importantly, what needed to remain familiar.

Process & Approach

01

Workflow Study

Studied the existing Access application in depth — observing how salespeople actually used it.

02

Familiarity-First Design

Designed the new interface to feel familiar — preserving keyboard-driven navigation of the original system.

03

Learning Curve Minimization

Prioritized minimizing the learning curve at every design decision.

04

Secure Web Architecture

Delivered a secure web application replacing the Access database.

Application Screens

The Redesigned Experience

BidBase Add New Bid form showing bid details, line items, and import/export controls
Add New Bid — coordinator creates a bid with customer, period, and line-item detail
BidBase Coordinator Bid List showing bids filtered by role and user with Add New Bid action
Coordinator view — role-filtered bid list with full management controls
BidBase Buyer Bid List showing assigned bids with completion status and include-complete toggle
Buyer view — assigned bids with completion status and include-complete filter

Outcomes & Impact

Minimal

Instruction required for experienced salespeople to become productive

Secure

Modern web application replacing 30-year-old Access database

Preserved

Keyboard-driven workflow familiar to the sales team

BidBase: a secure, modern web application that transformed a decades-old Access-based workflow into a scalable platform built for the future without sacrificing the familiarity that made the original system effective. By grounding the design in real-world observation and stakeholder collaboration, we created an experience that enabled experienced salespeople to transition with minimal disruption and training, while providing SGC with a significantly more maintainable and extensible foundation.

The solution was designed and delivered quickly and professionally, with an architecture that enabled SGC’s own development team to maintain and evolve the application long after our engagement ended. BidBase demonstrated that successful modernization isn't about changing everything—it’s about understanding what already works, improving what doesn't, and creating a better path forward.