MdAyeen
Back to Blog
SaaS & ERP

How I Built Rotana Store Platform

Behind the scenes of an enterprise WMS build: from database normalization roadblocks to deploying a functional product.

January 25, 2026 12 min read By Mohammed Ayeenuddin

The Genesis of Rotana ERP

Building the Rotana Store Platform was a challenging engineering journey. Replacing manual spreadsheet bookkeeping across dozens of retail outlets required a clean warehouse-first architecture, complex SQL transactional queries, and robust API securities.

Overcoming the Sync Issue

Initially, network drops in remote branches caused data desynchronization between local offline Point-of-Sale registers and the central cloud database. We re-engineered the architecture to use an Offline-First approach with IndexedDB on the client, pushing a queue of encrypted transactions to the server only when the connection was restored.

The Final Architecture Stack

The final product utilized Next.js for the administrative dashboards, React Native for the warehouse scanner apps, Node.js/Express for the core API gateway, and PostgreSQL hosted on AWS RDS for mission-critical data integrity.

  • Deployed CI/CD pipelines via GitHub Actions to ensure zero-downtime updates.
  • Integrated AWS S3 for storing thousands of product images and invoice PDFs.
  • Utilized Socket.io for real-time dashboard analytics and warehouse alerts.