Two hours a day down to 20 minutes

• Daily admin2h20m
• Admin workload100%30%
• Staff on overtime21

Based on customer operating data

How we planned it

1. 1

   Diagnosing the workflow through interviews

   Over two days of interviews in October and November 2025, we reviewed customer service, order management across Smart Store, Coupang, and trade partners, shipping, inventory, and the tools in use. The owner, managers, and install teams each kept separate Excel files, so cross checking whether jobs were done took a lot of time.

2. 2

   Cleaning up the data first

   We moved scattered files into one spreadsheet and turned payment, settlement, and completion markers that existed only as cell colors into true or false values. Customer details crammed into one cell were split into fields, and Smart Store and Coupang orders were converted automatically against a product table. The data had to line up before any system went on top.

3. 3

   Requirements and priorities

   The interviews produced four core needs: matching install teams by region, checking team schedules, linking payment and settlement status, and mobile notices. A partner ordering program under review was pushed back so that install team dispatch could go first.

4. 4

   Setup and training for Maybom

   In December 2025 we finished the first build and testing, then registered seven products as dispatch units and four KakaoTalk notice templates. Settlement done separately per install team was merged into a monthly settlement. We ran a live remote training session, then edited and shared the recording and followed up one by one.

5. 5

   Improving after launch

   With steady use came requests to make amounts easier to read, and these went to the top of the second half 2026 development priorities.

ilnetta

Names and numbers on screen are samples.