For a while, our warehouse data looked healthy. Every item had a storage location. Every location existed in the system. The numbers were consistent, and nothing failed.
The locations were placeholders.
The problem with numbers that are merely consistent
Placeholder locations are easy to generate and easy to trust. They fit the schema, they pass validation, and they produce charts. The failure only appears when someone has to physically pick something up, or when two different people describe the same shelf in two different ways and the system insists they are different places.
That is the trap: placeholder data does not look like missing data. It looks like data.
Replacing the placeholder set with the real one
We rebuilt the warehouse master from how the facilities actually operate, then loaded it as the authoritative set of storage locations.
- Verified storage locations
- 1,306
- Facilities modelled
- Suzhou, Shenzhen
- Approach
- Physical location first, system record second
- Placeholder locations
- Retired, not repaired
- Unknown mapping
- Kept unknown until a real location is confirmed
The count is not the point. The point is that every one of those 1,306 locations corresponds to a place a person can walk to, and that the two facilities are modelled on the same rules rather than two local conventions.
What the change surfaced
Replacing placeholders with reality exposes everything that had been quietly leaning on the fake data:
- Items that had a placeholder location and no real home needed a decision, not a default.
- Legacy codes that meant different things at each facility had to be resolved instead of merged.
- Any process that assumed every item is always somewhere had to tolerate "we have not confirmed this yet" as a legitimate state.
That last point is the one that changed the system most, and it is the subject of the next note in this log.
Why we publish this
A warehouse master is the least glamorous part of a commerce operation and one of the few parts that everything else depends on. Publishing it as a build note is a way of stating the standard we now hold ourselves to: storage locations are physical facts, and a system that invents them is worse than a system that admits it does not know.
A location record that nobody can walk to is not inventory data. It is decoration.