Case study · Sprint build + AI integration

From daily spreadsheet chaos to a live stock-analytics portal in under two weeks.

A steel distributor's sales team was manually reconciling a daily export of 1,800+ product lines against enquiries and outstanding orders. We replaced the spreadsheet gymnastics with a portal that answers in seconds.

Client: A Singapore-based industrial steel distributor (anonymized)Sprint buildStock-analytics portalBilingual UIAI catalogue assistant

Outcomes at a glance

< 2 wksSpec to live productionshipped within the initial sprint

1,800+Product lines per daily exportingested in one upload

~1,300Product mappings wiredattribute + catalogue joins

EN / 中文Bilingual interfacebuilt in from day one

Metrics from a live NexSprint engagement. Client anonymized at their request; figures rounded for readability.

The problem

Where things stood.

Every day, the distributor's system produced an inventory export of more than 1,800 product lines. Every customer enquiry meant a salesperson manually cross-referencing that export against the catalogue and against outstanding orders to work out what could actually be fulfilled.

It was slow and error-prone. A single enquiry could take a chain of manual lookups across separate spreadsheets, and the risk of promising stock that was already committed to another order was constant.

The bottleneck hit the customer directly: fulfilment answers were delayed, and the team's time was consumed by reconciliation instead of selling. The distributor also serves customers whose access needed to stay fast and reliable from mainland China.

What NexSprint built

Human-led, agent-built, iterating weekly.

NexSprint scoped, designed, and shipped a stock-enquiry and outstanding-orders analytics portal in a single sprint. Upload the daily export and the manual reconciliation collapses into a few seconds of interaction — then we kept extending it release over release.

Daily export upload

The team uploads the daily stock export and the portal ingests all 1,800+ lines instantly — no manual formatting, no re-keying.

Instant batch stock lookup

Paste or upload a list of product codes and get a batch stock answer in one pass, instead of looking each one up by hand.

Outstanding-orders fulfilment view

A dedicated view shows outstanding orders with cumulative shared-stock allocation, so the team can see what is truly available before promising it.

Product-attribute joins

The catalogue is enriched with product attributes — PMI data and colour coding — joined automatically so enquiries return the full picture.

One-click Excel export

Any result set exports to Excel in one click, fitting the team's existing downstream workflow rather than fighting it.

Bilingual UI + AI assistant

A full English / Chinese interface, plus an AI chat assistant that answers questions over the catalogue in natural language.

The outcome

What changed.

The sales team now answers stock enquiries in seconds. What used to be a chain of manual lookups across a daily 1,800-line spreadsheet became a portal interaction - and the whole build, spec to live production, took under two weeks.

It stuck. Around 1,300 product mappings power the attribute joins and batch lookups, and the portal is daily operational software for the sales team - not a demo that got shelved.

Infrastructure

Built on modern, Singapore-hosted edge infrastructure, with AI capabilities grounded in the client’s own data.

Timeline

Shipped within the initial sprint - under two weeks from spec to production. The engagement did not stop at launch: releases have continued month over month, including an AI-assisted quote-matching module, under an ongoing partnership.

Your turn

Want the same, measured against your own baseline?

We start with an audit, agree on the KPI, and ship a pilot. If we miss the number we agreed on, you don’t pay for it.

Start an audit See more work