LUCID-AI®
< CASE STUDY >SYS/09NZ-AKL● OPERATING

RETURNS PLATFORM

WAREHOUSE + ADMIN RECONCILIATION

A logistics business was running every refund and return through a shared spreadsheet, handed between a frontline warehouse team and admin. We replaced it with a platform built to fit their exact process.

THE PROBLEM.

[ BEFORE ]

Every refund and return moved through a spreadsheet shared between the warehouse floor and the admin team. Warehouse staff logged what came back, admin cross-checked it against orders, approved the refund and updated stock, all by hand, all in one shared file.

It worked, in the way spreadsheets always work until they don't: no audit trail on who changed what, no way to see which products were causing repeat problems, and admin spending hours a week just filtering and cross-referencing rows instead of processing.

An off-the-shelf returns tool would have meant bending the business's actual workflow to fit the software. That trade-off wasn't worth it for a business whose warehouse-to-admin handoff was already specific and well understood, just badly tooled.

WHAT WE BUILT.

[ THE SYSTEM ]

  1. BUILD/01

    A custom platform built around the exact handoff between warehouse and admin, instead of a generic returns workflow the business would have to adapt to.

  2. BUILD/02

    Structured pipelines so a return moves through defined stages, logged and status tracked, rather than living as a row in a spreadsheet with no history.

  3. BUILD/03

    Reconciliation built in as a first-class feature: the platform surfaces which products are coming back repeatedly, turning returns data into a signal instead of a chore.

THE RESULT.

[ AFTER ]

Manual handling dropped 80%. Filtering and cross-referencing that used to eat hours of admin time every week now happens inside the platform, and the warehouse and admin teams work off one system instead of one shared file.

[ BUILT WITH ]

PHPMySQLCustom Workflow Engine

>> PART OF AI Agents + Automation

[ START HERE ]

BOOK A FREE
DISCOVERY CALL.

30 minutes, no pitch deck, no obligation. Tell us what's eating your team's time and we'll tell you straight whether AI is the answer, and roughly what it would take.

WHAT YOU GET

A straight answer on whether AI pays off in your business, and what it would take.

EMAIL

jason@lucidai.co.nz

RESPONSE TIME

Within one working day