E-Commerce Order Dashboard

Overview

A custom-built dashboard using Google Sheets and Apps Script to centralize daily order management across multiple marketplace channels.

Problem

Managing orders from Shopee, Tokopedia, and TikTok Shop separately was time-consuming and error-prone. There was no unified view of daily order volume, inventory levels, or product performance.

Solution

Built a centralized Google Sheets dashboard with automated data aggregation using Apps Script. The dashboard pulls order data, calculates key metrics, and provides a single-page overview for daily operations.

Process

1. 1 Identified key metrics needed for daily operations.
2. 2 Designed the spreadsheet layout for clarity and quick scanning.
3. 3 Wrote Apps Script functions to automate data collection.
4. 4 Tested with real order data across three marketplaces.
5. 5 Iterated on the layout based on team feedback.

Result

Reduced daily order review time by approximately 40%. The team now has a single source of truth for monitoring inventory and order status across all channels.