PortfolioOverview
A system where EC site and store POS systems share and integrate customer information. Customers are recognized as the same member regardless of which channel they shop in.
Problems Solved
Store purchases don't reflect EC points. Customers double-register as 'EC member' and 'store member'. Purchase history scattered, no full picture.
Solution
Using EC platform customer ID as master, implemented bidirectional data sync between EC and POS. Real-time point reflection on purchase and name matching logic using phone/email to identify same person.
Benefits
- Customer integration: Unify EC and store members
- Real-time: Immediate point reflection on purchase
- Full visibility: Unified purchase history across all channels
Architecture
Customer
(Same person uses EC and store)
│
┌─────────────┴─────────────┐
▼ ▼
┌─────────────┐ ┌─────────────┐
│ EC Site │ │ Store POS │
│ │ │ │
│ • Browsing │ │ • In-store │
│ • Online │ │ purchase │
│ purchase │ │ • Member │
│ • Point │ │ verify │
│ usage │ │ • Point add │
└──────┬──────┘ └──────┬──────┘
│ │
└───────────┬───────────┘
▼
┌─────────────────────────┐
│ Integrated Customer DB │
│ Customer: CUST-12345 │
│ • Basic info │
│ • EC purchase history │
│ • Store purchase hist │
│ • Unified point bal │
│ • Member rank │
└─────────────────────────┘