Shelf Location Retrieval After Visual Identification

Published 2026-08-03 by Faraz Rahimi

Identifying the item is only half of the job. People still need the last place it was real. That is a query, not a guess.

Shelf Location Retrieval After Visual Identification

Tags: SQL, Warehouse, Computer Vision, Inventory, unlisted

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.

Original post: https://farazrahimi.com/posts/shelf-location-retrieval-after-visual-identification