1. Overview

The order file, reference date, channel and day thresholds, and each order's status, memo, and history are saved in the browser. They stay in place after a refresh or a later visit.

Connected at rollout: automatic sync with sales channels and courier software, tracking lookup, sending texts or notifications to customers, issuing refunds, and server storage for sharing the same records across devices.

2. Challenges

1. Problem orders are buried among all orders.

Most orders in a day ship without trouble. Only a few have problems, yet finding them means scanning the full list every day. Only the orders to follow up should remain.

2. "How many days has it been" is counted differently.

Shipping is counted in business days, excluding weekends; returns and refunds in calendar days. Thresholds also differ by seller. You need to view the list while changing the reference date and number of days.

3. No record of who handled what, and how far.

If whether the courier was called or the warehouse is checking only goes back and forth in a messenger, the next person does the same work again. Each order needs its status, memo, and change history.

3. Structure

Everything happens on one screen. Pick the file, reference date, and channel at the top; problem orders sit in four lanes in the middle, oldest first. Tap an order and a detail panel opens beside it to show the reason and record the status and memo.

4. Key Features

Sorting Problem Orders into Four Lanes

Of 33 orders, only the 12 that need attention are sorted: unshipped 5 · missing tracking 3 · delayed return 2 · pending refund 2. Unshipped is counted in business days after payment (weekends excluded), returns and refunds in calendar days, and canceled orders are left out. Change a lane's day threshold and the orders re-sort at once.

Open an Order to See the Reason

Tap a card and the reason appears at the top, such as "송장번호 12345가 10~14자리 숫자가 아닙니다" (tracking number 12345 is not 10–14 digits), with channel, payment date, product, tracking, ship date, and return and refund dates in one panel.

Status and Memo

Choose Not checked → Checking → Done and add a memo; it shows on the card right away. Done orders drop off the list and reappear when "Show done" is turned on.

Handling History

Every status change or memo edit adds a record with the time and a change such as "Not checked → Checking". It stays after a refresh or when reopened the next day.

• Filter by Sales ChannelTap open marketplace, live commerce, wholesale orders, or own store to see only that channel's orders, and the issue list CSV downloads the visible orders with their status and memo.

6. QA

Results from running the pages on PC 1440 and mobile 390 screens and clicking through in the order a real user would. We also checked that data is still there after saving and refreshing. (2026-09-23)

The 12 function tests: first-visit screen display · loading the sample order file and sorting into four lanes · filtering by sales channel · changing day thresholds · changing the reference date · opening an order to see the reason · saving status and memo · done orders drop off the list · status, memo, and history kept after refresh · issue list CSV · blocking files with different headers · uploading your own order file

Speed and quality scores (out of 100; mobile measured three times on a slow connection, median shown)

Mobile: First Contentful Paint 1.1s · Largest Contentful Paint 1.5s · Layout Shift 0.000 · Blocking Time 0ms PC: First Contentful Paint 0.3s · Largest Contentful Paint 0.4s · Layout Shift 0.000 · Blocking Time 0ms

7. Result