A correct SKU with no bin is a trivia answer. On the floor, identity without location is how you get a 10-minute walk.
I attach last-scan location the moment a match is confirmed. The card shows bin, timestamp, and whether that scan was inbound, pick, or cycle count. A location from last year is a rumor.
Last scan is not truth, it is a prior
Inventory ghosts exist. The query should say "last seen" not "is at." If the timestamp is old, the UI should look old — a warning color, a prompt to cycle-count that bin.
I keep a short history, not one field that gets overwritten. When something "disappears," the path through bins is the story.
Do not hide empty
If there is no scan history, say so. Fake precision ("aisle 2") trained on vibes will be believed once and then never again.