How to Handle Missing Supplier Product Data
Missing supplier data needs an explicit policy. A blank value might mean unknown, not supplied or intentionally removed; treating all three as the same can erase useful catalogue information.

Define the meaning of absence
Document whether each field should remain unchanged, become empty or require review when the source is missing. Keep that rule separate from a genuine zero value. For example, unknown stock and a confirmed quantity of zero are different business states and should not be casually merged.
Practical checklist
- Distinguish missing, blank and zero.
- Preserve known values where the rule requires it.
- Record the incomplete source row.
- Make unresolved records visible to staff.
How to review the result
Test the policy with a deliberately incomplete feed. Confirm that the result matches the written rule and that no customer-facing facts have been invented to fill the gaps.