The project involved building a grocery e-commerce platform for a retail supermarket that was already operating on a legacy, on-premise POS system backed by a local SQL Server database. The primary challenge was enabling online ordering and home delivery without disrupting existing store operations, while ensuring that stock levels and pricing remained consistent with the POS, which served as the business’s source of truth.
To address this, I architected and led the development of a full-stack commerce platform that integrated directly with the POS database rather than replacing it. I designed a dual-database approach where the POS retained authority over inventory and pricing, while the e-commerce system managed orders, users, and operational workflows. A scheduled synchronization process was implemented to update stock and pricing at regular intervals, preventing overselling and ensuring data consistency across offline and online channels.
I also modeled the order lifecycle as a controlled state-driven workflow supporting three order types: standard online orders, phone-call orders billed through POS, and return requests. Role-based access controls were implemented for customers, administrators, and delivery partners to ensure structured operational handoffs and prevent invalid state transitions. Barcode-based product onboarding was introduced to ensure product data originated from the POS, eliminating manual inconsistencies.
As a result, the platform reduced manual product setup effort by approximately 60%, minimized stock discrepancies between systems, and decreased order processing delays by around 50%. The solution enabled the supermarket to expand into online commerce without altering its existing billing infrastructure, providing a scalable and operationally stable foundation for digital growth.