All projects
Project 01/Motorbike parts business

POS System

A mobile-first field sales app built on an existing MSSQL system, with offline sync, live stock lookup, orders, receipts, and packing workflows.

Key results

50% manual paperwork reduces

Zero errors in invoice finalization

Improved efficiency in Packing

Interface diagram for an offline field sales and inventory application

Summary

We built a mobile-first web app on top of the existing MSSQL database. It reads and writes the same live data, saves work locally when the connection drops, and syncs it when the connection returns. The office kept its desktop software while the field team gained a practical phone-based workflow.

Context

Motorbike parts business

Project type

Field Sales

Primary stack

React.js

Focus areas

Field SalesMSSQLOffline Sync

Technology

React.jsMSSQLMobile Web AppOffline SyncCloudflare TunnelREST API

The situation

Field work had outgrown the counter system.

The business already had a .NET desktop system that worked at the counter, but it could not travel with the sales team. Reps used paper order books, collections staff wrote deposit receipts by hand, and office staff entered everything later. Weak mobile signals also made field work difficult.

Interface diagram for an offline field sales and inventory application

The result

50% manual paperwork reduces

The business reduced manual paperwork and order errors while saving around three hours of work each day. Shop and field teams could share live stock information without replacing the existing desktop system, and company data stayed on-site.

Additional outcomes

  • Zero errors in invoice finalization
  • Improved efficiency in Packing
  • Around 20 hours saved every week

What was built

The main workflows and capabilities delivered for this project.

01

Live stock and product lookup

02

Mobile order entry for sales reps

03

Offline local saves and later sync

04

On-the-spot deposit receipts using the sales rep's live location

05

Phone-based packing workflow

06

Secure on-site hosting through Cloudflare Tunnel

Have a software problem to solve?

Tell us what you are trying to build, improve, or automate. We can work out the right approach together.

Start a project

Related cases

More work