Skip to content
Aravinthan B
Back to blog
Engineering7 min read

Bridging a Legacy POS with Modern Grocery Commerce

How dual-database design, phone-order workflows, and delivery tooling let a traditional supermarket sell online without replacing its existing POS.

Aravinthan Balaji

Engineering notes

Many Indian retailers already run stable point-of-sale systems. Replacing that foundation is rarely the first move when customers start expecting home delivery. The practical path is to introduce an online channel that treats the POS as the inventory source of truth.

Keep inventory ownership clear

For Raja Supermart, stock and pricing remained in Optech SQL Server. Application data - carts, orders, customer accounts - lived in MongoDB. A scheduled sync job reconciled quantities so the storefront never drifted far from what the cash counter knew.

Design for how orders actually arrive

Phone orders remain common in grocery retail. Admins needed to place and manage those orders in the same console that handled website checkouts, partner assignment, and returns. One operational surface reduced training cost and missed handoffs.

Ship with operational visibility

Dashboards for revenue, category performance, and delivery status matter as much as a polished catalog. When leadership can answer basic questions without exporting spreadsheets, the platform earns trust quickly.