Background
With 12 stores, online orders and store inventory were reconciled by hand in spreadsheets — overselling was routine. Paper punch cards left no repurchase data.
Approach
- 1
Modeled inventory per store: orders lock stock at checkout, stock returns after verification
- 2
Integrated WeChat Pay, phone-number login and subscription messages to reduce friction
- 3
Made points, coupons and birthday rewards configurable rules instead of hard code
- 4
Built the backend around the three highest-frequency views: orders, stores, reconciliation exports
Results
- Overselling complaints eliminated
- Staff verification went from manual logs to a scan
- Repurchase reachable directly through membership data
Tech Stack
Native WeChat Mini ProgramNode.jsPostgreSQLRedisWeChat Pay
