PWA and retail operations Case study
Jeweltime
The shop floor needed something that behaves like an app: installable, fast on a phone, and usable while a customer is standing there. It reads the catalogue from the existing WooCommerce database and keeps its own record of customers, orders and inventory.
The business problem
Retail staff needed an app-like workflow for catalogue browsing, assisted ordering and internal admin tasks.
What I delivered
- A production-oriented PWA web app using PHP, MySQL and Vanilla JavaScript.
- Installable PWA behaviour, offline-aware caching and web push notifications.
- Kavenegar OTP/SMS integration and a WooCommerce database read layer for products, prices, stock and media.
Technical approach
- I built an operations app, not a decorative website.
- I kept the stack small enough that one person can support it.
- I shaped the catalogue, ordering and admin workflows around what staff actually do in the shop.
Result and evidence
The system runs catalogue browsing, assisted ordering and internal workflows, and I still support it.
Commercial value
The project covers the whole path end to end: frontend, data access, notifications and day-to-day usability.
Readable implementation brief
implementation_brief {
project: "Jeweltime"
context: "PWA and retail operations"
problem: "Retail staff needed an app-like workflow for catalogue browsing, assisted ordering and internal admin tasks."
delivered: "A production-oriented PWA web app using PHP, MySQL and Vanilla JavaScript.; Installable PWA behaviour, offline-aware caching and web push no"
evidence: "The system runs catalogue browsing, assisted ordering and internal workflows, with ongoing technical support."
value: "The project covers the whole path end to end: frontend, data access, notifications and day-to-day usabili"
}What this project shows
The dual-database model is the decision worth discussing. WooCommerce stays the source of truth for catalogue and media; everything operational lives in the app's own schema rather than being forced into postmeta.
I built it as a PWA rather than a native app for delivery reasons. It reaches every device the staff already carry, and I can ship an update without going through an app store.