Yesterday’s advertising spend says RM0. Did you spend nothing, or has the connection failed to bring the cost in?
Those two explanations lead to different decisions. If the zero is confirmed, you can use it in the calculation. If the cost is missing, the report is incomplete. Filling an empty field with zero hides that distinction and can make an ordinary trading day look far more profitable than it was.
Three states, three meanings
Imagine reviewing advertising spend for yesterday. A confirmed zero means the source reports no spend for that period. An unavailable value means the source did not provide the data. A processing value means the data has not finished arriving. Each deserves a different label and a different response.
If sales arrived but advertising costs did not, a contribution estimate may look unusually strong. That is not evidence that the campaign suddenly became more efficient. The report is incomplete. Show the available information, but make the limitation visible beside the result rather than in a distant help page.
Check freshness as well as presence
A number can be present and still be stale. “Last refreshed” tells you when your system fetched data. It does not necessarily tell you the latest business period included in that data. A refresh today could return a source that is still reporting yesterday morning.
Where it matters, show when the connection was checked and which period the source covers. This is especially useful when different channels update on different schedules. Comparing current orders from one source with settled transactions from another can produce a convincing but misleading ranking.
A Malaysian team combining marketplace exports, retail POS records and website orders should also check timezones and currencies. Use MYT (UTC+8) as an explicit reporting choice, not an assumption about every source. For sales elsewhere in Southeast Asia, retain the original currency and document the exchange-rate date and conversion method before adding totals in ringgit.
Agree on what a sale means
Before combining sales from two sources, check what each one counts. One might include orders placed, while another includes only fulfilled orders. Cancellations and refunds can create further differences. Find out whether a refund appears against the original order date or the date it was issued.
Choose the definition that fits the question. A packing team may need orders awaiting fulfilment; a sales review may use fulfilled orders. Label the measure so readers know what they’re looking at. When you compare periods or channels, use the same definition on both sides.
Use a small set of checks
You do not need a long governance manual to begin. Check that expected sources arrived, that the period is complete and that identifiers have not created duplicate records. Review unexpected jumps against the source before interpreting them as growth or decline.
Keep a reconciliation point. For example, choose a complete day and compare the report's order count and sales total with the source, using matching filters. If the totals differ, investigate definitions and timing before assuming either system is wrong. Record the explanation so the same discrepancy does not trigger the same debate every week.
Use both the channel and order ID when combining records. Two platforms can reuse a similar-looking identifier. Separate a fulfilled order from its refund or settlement adjustment, rather than deleting one as an apparent duplicate. An order date and a settlement date answer different questions.
Make uncertainty useful
If a cost import is late, say which source is missing and which period it affects. The stock figures may still be useful for a reorder decision, while the margin estimate needs to wait. Put the notice beside the affected result so the reader doesn’t have to discover the problem later.
Avoid turning every missing field into an alarm. Reserve prominent warnings for information that could change a decision. Give the reader a next step. Ask them to reconnect a source, wait for the stated update window, or check a particular import. A warning without an action soon becomes background noise.
Sources: TikTok Shop Malaysia settlement definitions. Checked 10 October 2026. Reporting checks are Nisbah’s editorial recommendations, not claims of existing product features.