TikTok Shop
Mapping TikTok Shop order statuses to a sheet you can scan
A marketplace status field exists to describe the order accurately. Your sheet exists to tell you what to do. Those are different jobs, and copying one into the other is why order sheets are hard to read.
The only question that matters
For each row: does this need me, right now, and if so for what? Every status you keep should answer that. Every status that does not answer it is decoration.
Five buckets
- To buy - paid, not yet purchased from the supplier. Action: buy it
- Waiting - bought, no tracking yet. Action: none, unless it has been too long
- Shipped - tracking uploaded and scanning. Action: none
- Problem - something is wrong and a human is needed
- Done - delivered or cancelled and settled. Action: never look again
Everything the platform reports maps into one of those. Multiple platform statuses collapsing into one bucket is fine and expected.
Why "done" has to be strict
The done bucket is the one that keeps the sheet fast. If rows never reach it, every sweep re-checks history forever - and on a busy sheet that is most of the work being done for no benefit.
Be deliberate about what counts as terminal. Delivered is terminal. Cancelled and refunded is terminal. "Delivered but the buyer has messaged" is not - that is a problem.
The waiting bucket needs a timer
Waiting is the only bucket where doing nothing is correct and also where doing nothing forever is wrong. An order that has been waiting four days is not waiting, it is stuck.
A single formula comparing today against the date you bought turns that bucket from a parking space into a queue that eventually pushes rows into "problem" on its own.
Keep the platform status too
Collapse for reading, but keep the raw status in a column further right. When you need to work out why something is odd, the detail you threw away is exactly the detail you want.
The rule is: left-hand columns for decisions, right-hand columns for evidence. Both matter; only one of them should be competing for your attention.