The key idea

A zero means that a defined source reported no relevant demand during a covered period. A missing value means the observation is unavailable or incomplete. Treating both as zero can make a disconnected feed look like a collapse in sales and cause the system to cut stock for the wrong reason.

This is an original operational explainer. Its examples and decision rules are illustrations, not measured customer results or universal service commitments.

Make coverage part of every import

A sales file should specify its account, market, timezone, period and metric. Record whether the period is complete, and whether cancellations have already been removed. A spreadsheet containing only dates with transactions cannot establish coverage by itself. The importer needs a declared window or another trustworthy indication of completeness. Keep the raw import and the normalized result so unusual gaps can be investigated without reconstructing what the customer originally supplied.

Let uncertainty change the action

When recent coverage is incomplete, show that condition beside the forecast. A policy can retain a conservative target, require approval or pause automatic ordering depending on the context. It should not silently infer a new trend. After the missing period arrives, recompute affected summaries in a controlled way and preserve the previous decision record. The point is to make decisions with the information available, not to rewrite their history afterward.

Worked example · illustrative assumptions

Imagine a title normally sells two copies per day. An import includes Monday through Thursday but the Friday export failed. The weekly series should not show Friday as zero merely because there is no row. If the publisher later confirms that Friday was fully reported with no orders, zero becomes valid. Until then, the forecast should know that the observation is missing rather than learn a false one day demand drop.

Put it into practice

  • Store declared coverage windows with every sales import.
  • Keep missing observations distinct from confirmed zero values.
  • Show incomplete recent history before approving a new stock target.

Watch out for

Do not fill an entire year with zeros just because the first observed order occurred recently. The title may have launched late, changed seller accounts or been absent from the supplied source.

Can a file with only transaction rows still be useful?

Yes, when the source period and completeness are known. A verified export window allows empty days within that window to be interpreted differently from days outside it.

AI assisted editorial content with original planning examples. Source links support the stated source notes; operational suggestions are guidance rather than guarantees. Provider rules and product coverage can change. Editorial approach · BooksAhead.ai connection status.