Lapiz Group (Dubai and Abu Dhabi Zoho orgs)
Zoho stock-sync: 776,478 units reconciled, zero errors
Took the group's Zoho Books and Inventory in-house, automated packing and shipping for every invoiced order, and ran a backfill that closed 7,321 stuck orders and corrected 776,478 units of stock.
- 776,478stock units corrected · across 1,475 items
- 7,321stuck sales orders closed · 8,346 packages and shipments, 0 errors
- 782,525 → 27,607 unitsstock gap · −96.5%
- 1,631 → 425mismatched items · −74%
- 951dead orders closed · 128,207 units freed
01Context
Three branches, two Zoho organisations, and an ERP configured by an external agency. Accounting stock and physical stock disagreed by over 780,000 units because invoiced orders were never packed or shipped in the system.
02Constraint
Management had two quotes on the table: AED 160,000 from Odoo to fix the stock with automations and custom functions and migrate us, and AED 90,000 from another company just to fix Zoho. Whatever I did had to run on live data in a trading company that invoices all day, with no second chance on a bad write.
03What I did
After comparing Zoho, Odoo and Dynamics and leading the Odoo discovery, I recommended staying on Zoho and fixing it. I audited the agency's automations, switched off the failing rules and removed an exposed API key. Then I built the invoice-to-shipment automation in Deluge (every invoiced sales order packs and ships itself, voided invoices return goods to stock) and a Python backfill with idempotent, marker-tagged, retried writes to process the history. Alongside: a "to be received" column kept correct by an hourly check, purchase history on PO lines, item-page buttons, and four scheduled daily reports.
04Result
The backfill closed 7,321 stuck orders with 8,346 auto-generated packages and shipments at zero errors, correcting 776,478 units across 1,475 items. The stock gap fell 96.5% and mismatched items 74%; a further 951 dead orders freed 128,207 committed units. The automation went live on 6 October 2026 and the Odoo migration was cancelled.
05What I'd change
I ran the backfill in batches with manual review between them, which was slow but right. The piece I'd add earlier is the daily invoiced-vs-shipped mismatch report. It existed only after the cleanup and would have caught the drift years ago.
06Stack
- Zoho Books
- Zoho Inventory
- Deluge
- Python
- GitHub Actions
- Zoho Cliq


