All projects

ZN SYSTEMS

Project 01/Motorbike parts business

Offline Field Sales & Inventory App

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

Less manual paperwork

Fewer order errors

Around three hours saved each day

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.

Interface diagram for an offline field sales and inventory application

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.

The result

Less manual paperwork

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

  • Fewer order errors
  • Around three hours saved each day

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

Field SalesMSSQLOffline SyncCloudflare 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