How We Transformed a Dubai
Import-Export Company’s
Operations with One App
Spreadsheets. WhatsApp threads. Manual invoices taking three hours each. Here’s exactly how Codearbro built a Zoho Creator application that fixed all of it.
| Client Industry | International Trade & Logistics — Import/Export |
|---|---|
| Client Location | Dubai, United Arab Emirates |
| Platform | Zoho Creator |
| Core Modules | Shipment Tracking, Customer Management, Master Data, Invoice Automation |
| Developed By | Codearbro Solution OPC Pvt Ltd |
Executive Summary
A rapidly expanding import-export company headquartered in Dubai came to Codearbro Solution OPC Pvt Ltd with a problem that will sound familiar to anyone who has scaled a trading business without scaling their systems. Their workflow was a fragmented mix of spreadsheets, manual ledgers, email threads, and WhatsApp groups.
Shipment data was scattered across personal files. Customer records were duplicated or outdated. Generating a single invoice required an accounts team member to spend two to three hours cross-referencing multiple sources — only to produce something that was frequently wrong.
We designed and delivered a fully custom Zoho Creator application that consolidated every aspect of their trade operations into one intelligent, cloud-based platform. The result was a dramatic reduction in manual workload, near-zero data errors, faster invoice turnaround, and complete end-to-end visibility across every shipment lifecycle.
Codearbro Solution OPC Pvt Ltd specialises in low-code application development and business process automation across the Zoho ecosystem — including Zoho Creator, Zoho CRM, Zoho Books, and Zoho Analytics. We build intelligent digital systems that replace manual processes for clients across India, the UAE, and beyond.
Client Background
The client is an established trading company based in Dubai operating across import and export corridors spanning Asia, Africa, and Europe. With a growing volume of concurrent shipments — each involving freight forwarders, customs brokers, buyers, sellers, and logistics partners — the back-office infrastructure had simply not kept pace with revenue growth.
Operations teams coordinated via email and WhatsApp. Shipment tracking lived in Excel. Invoices were produced manually, one at a time. At lower volumes, this worked. As the business grew, it became a serious operational liability.
The Challenges We Were Brought In to Solve
Before we wrote a single line of code, we conducted structured discovery workshops with the operations, accounts, and management teams. Five compounding problems emerged consistently:
No Centralised Shipment Tracking
Each shipment tracked manually across separate spreadsheets. No single system of record. Operations staff frequently worked from outdated information.
Fragmented Customer Data
Customer records maintained inconsistently across personal files, email threads, and local spreadsheets. Duplicate entries were everywhere.
No Master Data Governance
Port codes, commodity types, carrier details — all undocumented. “Dubai Port,” “DXB,” and “Dubai” appearing as three separate entries in different sheets.
Manual Invoice Generation
2–3 hours per invoice. Calculation errors caused client disputes. Payment delays were a recurring problem affecting cash flow every month.
The fifth problem sat above all of these: management had zero real-time visibility into the business. Every summary report required hours of manual consolidation — by which time the data was already outdated.
The Solution: Architecture Overview
We selected Zoho Creator as the platform for this engagement. It offered rapid development capabilities, native integration with other Zoho applications, and a cloud-native architecture suited for multi-user access across global teams. The application was built using a modular, relational design — every piece of data interconnected, consistent, and accessible in real time.
Shipment Tracking Module
End-to-end lifecycle tracking from booking to delivery. Real-time status updates, milestone alerts, and a built-in document repository.
Core ModuleCustomer Management
Centralised customer profiles with full transaction history, contact management, billing details, and credit visibility.
CRM LayerMaster Data Module
Ports, commodities, carriers, Incoterms, currencies, and regulatory codes — all standardised and dropdown-driven.
Data GovernanceInvoice Automation
Auto-triggered on delivery confirmation. Line-item calculation, branded PDF generation, and optional auto-email — under 2 minutes.
AutomationThe Shipment Module: Full Lifecycle Tracking
The Shipment Module is the operational heart of the application. Each shipment record is created when a new trade order is confirmed and follows a defined lifecycle from origin to delivery. Here’s how the flow works:
📋 Order Confirmed → Shipment ID Auto-Generated
A unique Shipment ID is created. Origin/destination ports, customer reference, commodity, carrier, and estimated dates are all linked from master records.
🚢 In Transit → Real-Time Status & Alerts
Operations team updates milestones. Automated notifications sent to stakeholders. Bills of lading, packing lists, and certificates of origin uploaded directly.
🛃 Customs Clearance → Tracked as a Distinct Milestone
Regulatory flags from master data trigger compliance checks automatically. No manual cross-referencing of country codes or tariff classifications.
✅ Delivered → Invoice Triggered Automatically
When status updates to “Delivered,” the invoice workflow fires instantly. No manual steps. No missed billing. No delays.
⚡ Fully AutomatedInvoice Automation: From 3 Hours to Under 2 Minutes
This is the highest-impact feature in the entire application. The before-and-after speaks for itself:
- ❌ Manual data collection every time
- ❌ Arithmetic errors were common
- ❌ Payment delays every month
- ❌ No consistent format
- ❌ Shipments missed in billing
- ✅ Zero manual input required
- ✅ Calculation errors eliminated
- ✅ Payments arrive faster
- ✅ Branded PDF, auto-emailed
- ✅ Every delivery invoiced
When a shipment’s status transitions to “Delivered,” a Zoho Creator Deluge workflow pulls shipment details, customer billing info, applicable charges, exchange rates, and tax configuration — calculates line-item totals, generates a branded PDF, assigns a sequential invoice number, stores it against both the shipment and customer record, and optionally dispatches it via email. All without a single click from the accounts team.
Measurable Business Outcomes
Following deployment, user training, and a 60-day hypercare period, here are the quantified outcomes:
How We Built It: 5-Phase Methodology
We followed an agile, milestone-driven delivery methodology to keep the client’s team engaged throughout and ensure the final product precisely matched operational reality.
Phase 1 — Discovery & Requirements Mapping
Structured workshops with operations, accounts, and management. User stories created and signed off before development began.
Phase 2 — Architecture & Data Modelling
Relational schema designed to reflect real-world trade relationships. ER diagrams shared with client for validation before build.
Phase 3 — Module Development
Each module built iteratively, Shipment Module first. Bi-weekly client demonstrations used to gather real-time feedback.
Phase 4 — Workflow Automation & Invoice Logic
Deluge scripts written and stress-tested with production-representative data volumes before sign-off.
Phase 5 — UAT, Training & Deployment
Structured User Acceptance Testing. Role-specific training for operations, accounts, and management. 60-day hypercare support followed go-live.
“Before Codearbro built this application for us, our operations team was drowning in spreadsheets and our accounts team was spending days every week just processing invoices. Today, every shipment is tracked in one place, every invoice goes out automatically the moment a delivery is confirmed, and our management team can see the entire business on one screen.”Operations Director · Dubai Import-Export Enterprise
“The measure of a good business application isn’t the number of features — it’s how completely it eliminates the need to work outside it.”
— Codearbro Solution OPC Pvt LtdThe Takeaway
This project demonstrates what’s possible when a business stops working around its systems and starts building systems that work for the business. The client didn’t need a complex, six-figure ERP implementation. They needed a thoughtfully designed application — built around their actual workflows — on a platform that could grow with them.
Zoho Creator, combined with Codearbro’s deep understanding of trade operations and workflow automation, delivered exactly that: an intelligent, connected system that turned three hours of manual invoicing into two minutes of zero-click automation, and scattered spreadsheets into a single source of truth visible to every stakeholder in real time.
Running Your Business on Spreadsheets?
Let’s build a smarter system. Codearbro specialises in custom Zoho Creator applications tailored to your exact workflows.
Get a Free Consultation →
