Case study · ERP & Automation

From Excel and WhatsApp
to one system.

A fabric business ran everything — procurement, manufacturing and shipment — on spreadsheets and WhatsApp messages. We built a custom ERP in Python and SQL that carries every order through each stage in one place.

Industry
Textiles & fabric
Where
India
What we did
ERP Development
Built with
Python · SQL
The challenge

Every stage lived in a different sheet or chat.

From buying fabric to making it and shipping it, the business ran on Excel files and WhatsApp groups. Each stage kept its own records, in its own format, often with one person holding the latest version.

When information sits in spreadsheets and chat threads, simple questions — where is this order, what did we buy, what is ready to ship — take calls and scrolling to answer, and mistakes are easy to miss.

BeforeAfter
Procurement Excel sheets and WhatsApp Purchases recorded in one database
Manufacturing Status shared in chats Each production stage tracked in the system
Shipment Separate dispatch files Dispatch linked back to the original order
Reports Put together by hand Drawn from the same data
What we did

Step by step, around their business.

01

Map the flow

We followed the work from fabric procurement through manufacturing to shipment, and noted every sheet and chat each stage relied on.

02

Design the data

We designed one SQL database for suppliers, materials, orders, production and shipments, so each record is entered once.

03

Build in Python

We built the screens and workflows for each stage in Python, shaped around how the team already works.

04

Connect the stages

Each stage hands over to the next inside the system, so an order carries its history from purchase to dispatch.

05

Hand over

We brought the team onto the system stage by stage and kept refining it as they used it.

What changed

The result.

  1. Procurement, manufacturing and shipment now run in one system
  2. Every order can be followed from purchase to dispatch
  3. Day-to-day work no longer depends on spreadsheets and chat threads
  4. Reports come from one shared source of data
More case studies

Other work.

All case studies →

Want something like this for your business?

Tell us how things run today. We'll map it and show you what to change first — honestly.

Start a Conversation