Back to Projects
    E-Commerce / Operations

    Rotana Grocery

    Unified Commerce & Operations Platform for End-to-End Grocery Distribution

    Duration14 Weeks
    Team5 Engineers
    PlatformsWeb, Admin Dashboard, POS

    Overview

    Rotana Grocery Warehouse needed a complete digital operating system — not just an e-commerce site, but a unified platform that connects every aspect of their business: B2C online store, B2B wholesale ordering, warehouse inventory, supplier management, delivery logistics, sales team coordination, and financial operations including credit, invoicing, and reconciliation. We built a centralized system where data flows in real-time across all departments, eliminating silos and manual processes.

    Challenges

    01

    Disconnected Operations

    Warehouse, store, sales, delivery, and finance all operated on separate spreadsheets and disconnected tools with no shared data.

    02

    Dual Commerce Complexity

    Serving both retail (B2C) and wholesale (B2B) customers required different pricing, ordering, and fulfillment workflows.

    03

    Inventory Blindness

    Stock levels were tracked manually, leading to overselling, stockouts, and no visibility into warehouse-to-store transfers.

    04

    Financial Chaos

    Credit sales, invoicing, payments, and reconciliation were done manually — leading to errors, delayed collections, and cash flow problems.

    Key Features

    Unified B2C + B2B Commerce

    Single platform serving retail customers (online store) and wholesale buyers (bulk ordering) with role-based pricing and separate checkout flows.

    Real-Time Inventory Intelligence

    Live stock tracking across warehouse and store locations, automatic reorder alerts, transfer management, and batch/expiry tracking.

    Supplier Management Portal

    Purchase order creation, supplier onboarding, delivery tracking, and cost analysis — all integrated with inventory and finance.

    Sales Team Dashboard

    Mobile-friendly dashboard for field sales teams with route planning, customer visit logging, order placement, and commission tracking.

    Delivery Operations

    Order-to-delivery workflow with route optimization, driver assignment, delivery confirmation, and real-time status tracking.

    Financial Operations Suite

    Complete credit management, invoice generation, payment tracking, ledger maintenance, and automated reconciliation.

    Technology Stack

    Frontend

    Next.jsReactTypeScriptTailwind CSS

    Backend

    Node.jsExpress.jsREST APIGraphQL

    Database

    PostgreSQLRedisPrisma ORM

    Auth & Security

    JWTRBACAudit LoggingRole-Based Pricing

    Real-time

    WebSocketServer-Sent EventsPush Notifications

    Deployment

    VercelAWS (RDS, S3)Docker

    Results & Impact

    01

    6

    Operations Unified

    Six departments connected in real-time — warehouse, store, suppliers, sales, delivery, finance

    02

    B2C + B2B

    Commerce Channels

    Dual commerce model with role-based pricing and separate workflows

    03

    80%

    Manual Processes Eliminated

    Automation replaced spreadsheets and manual tracking across the business

    04

    99%+

    Financial Accuracy

    Automated invoicing and reconciliation virtually eliminated accounting errors

    Future Scope & Scalability

    Mobile app for delivery drivers with GPS tracking

    AI-powered demand forecasting and auto-replenishment

    Customer loyalty program with points and rewards

    Multi-warehouse support for expansion

    Barcode/QR scanning for warehouse operations

    Integration with accounting software (Tally, QuickBooks)

    Conclusion

    Rotana Grocery now operates with a unified digital operating system that connects every aspect of their business in real-time. From B2C online ordering to B2B wholesale, from warehouse inventory to delivery logistics, from supplier management to financial operations — everything flows through one platform. The result is dramatically improved operational efficiency, financial accuracy, and the foundation for scaling to multiple locations.

    Frequently Asked Questions

    Let's Work Together

    Have an idea? Let's build something amazing.

    We brought Rotana Grocery's vision to life. Now it's your turn.