A stock alert needs variant-level evidence
Illustration: a product feed shows 12 dresses, but it lacks size-level stock. That may support a general assortment discussion; it cannot justify an availability alert for size M. The team obtains the sellable variant quantity and checks the destination before reviewing the alert. A missing size quantity remains unknown, even when the product total is positive.
Write a source contract for one decision
For each required input, record the system, account, owner, fields, historical coverage, refresh time and permitted use. Distinguish an available catalog connector from a connected account and from a verified dataset. Agree what makes an input too stale for this task. Inventory used for a launch decision may need a different freshness standard from a monthly editorial review.
Reconcile meanings before joining tables
Record currency, timezone, tax treatment, cancellations, refunds and the period being measured where relevant. Check that order, product and variant identifiers mean the same thing across the sample. A product name is not a reliable substitute for a stable variant key. Separate technical access from permission to use the data for the intended task, and avoid importing personal fields that the task does not need.
Test completeness and exceptions with a small sample
Trace a normal order, a cancellation, a partial return and a changed variant through the relevant sources. Compare row counts and totals at a known cutoff, inspect duplicates and list missing periods or fields. For cohort analysis, explain whether earlier purchases are visible before calling someone a new customer. NIST’s framework includes assessment of data suitability; the checks here are our practical starting proposal for a retail team.
Source: NIST: AI risk management core ↗
Decide what can proceed and what must wait
Accept inputs that meet the task’s criteria; qualify an exploratory analysis when its limitation is explicit; block a consequential action when a required fact or permission is absent. Assign each gap an owner and retest date. Save a small redacted evidence record with the cutoff and definitions. Recheck after a connector, mapping or business rule changes rather than treating one successful import as permanent readiness.
Use this at work
- List the minimum fields, history and freshness needed.
- Confirm identifiers, definitions and permitted use.
- Reconcile a sample including exceptions.
- Assign missing-data owners and retest before action.
Reference material
Sources checked 4 October 2026. Definitions are attributed where cited; the retail review methods and examples are Faccelerate editorial proposals, not product capability claims.