Unified online-store sales dashboard
Order data that staff downloaded store by store is now collected automatically from three platforms, totaled on one set of rules and shown on a single screen.
Checking sales
Before
3 platforms · each store separately
After
One screen · collected automatically
To protect client information, these screens recreate the same features with mock data.
Background
Companies rarely sell through a single channel. The same product is listed on Naver Smart Store, on Coupang and on the company’s own Cafe24 store. Two brands mean twice the stores, and every store has its own admin screen.
What we found
To check sales, staff had to log in to each platform, set a date range and download an Excel file. Seven stores meant doing it seven times. Each platform used different column names and different terms for order status, so combining the files became manual work again.
The problem
Collecting the data was not the hard part. Totaling it on the same rules was. Stacking orders from three platforms as they are produces totals that do not match. Without a rule for cancellations and refunds, the dashboard figures drift away from each platform’s own admin screen.
What we built
- Three platform collectors — Naver Smart Store, Coupang and Cafe24. Each uses different authentication and data formats, so each was built separately
- Automatic Cafe24 token renewal — OAuth tokens expire. When one does, collection stops silently and nobody notices for days. Browser authentication, token issuance and renewal now run as one automatic flow
- Standardized storage — Platform-specific columns are mapped to one format before they go into the database. Data has to share a shape before it can be combined
- Net sales after refunds — Refunds are deducted and reported separately from gross sales. This is the amount the business actually keeps
- Unified dashboard and Excel export — Collection status by store and platform and sales trends by period on one screen, with the same view exportable to Excel
Results
Delivered within the two-week contract term. Sales from three platforms are checked on one screen and exported to Excel for any date range.
See more work built the same way under Web data collection.
See more work on this topic under Data analysis.