Back to Blog
Use Case

SME Logistics 35 employees — standardizing order processing from Excel to system

The story of a logistics company that transitioned from fragmented operations using Excel + Zalo to a unified system in 6 weeks — and the lessons learned.

SME Logistics 35 employees — standardizing order processing from Excel to system

Table of Contents

In early 2026, we received a brief from a logistics company operating with 35 employees and processing over 200 daily orders. Despite stable revenue, operational fragmentation was exhausting the team. The entire workflow—from receiving orders, dispatching drivers, to reconciling debts—ran manually on Excel spreadsheets and Zalo chat groups. Every morning, the founder spent at least 2 hours merely asking each department how many orders were closed yesterday and identifying potential risks.

The "Chaos" picture before implementation

Following our initial process audit, we discovered 4 critical bottlenecks:

  • Data Redundancy: Order information had to be manually entered three times across different Excel files (Sales, Dispatch, and Accounting).
  • Fragmented Communication: Drivers lacked a dedicated app. Instructions were sent via a 50+ member Zalo group, leading to buried messages and frequent missed deliveries.
  • Key Person Dependency: The complex debt ledger was understood by only one accountant. If they took a sick leave, the company's cash flow reconciliation stalled entirely.
  • High Latency Reporting: Compiling revenue reports took a full working day, forcing the Board of Directors to make decisions based on outdated information.

OXMODE's Lean Approach

Faced with this challenge, traditional consulting firms often recommend implementing an Enterprise Resource Planning (ERP) system. However, a standard ERP setup costs upwards of $20,000 and requires 6 months to implement—a highly risky investment for an SME.

Instead, OXMODE applied an agile No-code Stack methodology:

  • Airtable as Core Database: Built a Relational Database to centralize everything from Orders and Clients to Drivers. All departments now access a Single Source of Truth.
  • Glide for Mobile App: Developed a Progressive Web App (PWA) allowing drivers to accept jobs, report GPS locations, and upload Proof of Delivery (POD) directly at drop-off points.
  • Make.com for Automation: Automated information flow. When a driver clicks "Completed", Make automatically triggers status updates, calculates revenue/debt, and sends an automated SMS/Zalo notification to the client.

The total software maintenance cost is approximately $150/month. The entire system was implemented, tested, and deployed in just 6 weeks.

Business Results After 3 Months

The transformation went beyond technology, directly impacting the P&L and company culture:

  • End-to-end order processing lifecycle time reduced by 65%.
  • Revenue and debt reports are updated real-time on the Management Dashboard.
  • Information error rate plummeted from 8% to under 0.5%.

Most importantly: This open-architecture system allows the company to scale to 50-100 employees or expand to other provinces without overhauling the core platform.

Does this sound like your business?

Book a 30-minute call for OXMODE to analyze your specific case.

Contact Us