Keep missing locations explicit
A listed row with no location stays visibly incomplete.
For operators
Read these instructions on any device. Watch or practise a chapter on a desktop or laptop, with a desktop or mobile application layout. Demonstrations use sample data and simulated scanners.
Keep missing locations explicit
- Start a lookup
Start a lookup.
FindBench reads the local reference you choose. It does not fetch stock data or confirm where goods are now. All values in this lesson are synthetic.
- Choose the prepared reference CSV
Choose the prepared reference CSV.
This prepared CSV enters the real file chooser. Review the rows and choose the columns before loading. Nothing has been uploaded.
- Map the exact code column
Map the exact code column.
Choose Part as the code column. Every value stays exact text, including leading zeroes.
- Map the description column
Map the description column.
Choose Text for the descriptions. Different descriptions for one code remain visible.
- Map every listed location
Map every listed location.
Choose Bin for locations. Repeated rows are retained, and a blank location stays explicitly not supplied.
- Keep the relevant note column
Keep the relevant note column.
Choose Comment for notes. The Ignore column is left out and will not be saved with the reference.
- Name the reference
Name the reference.
A clear title appears with the lookup, downloads and saved work. It is your declared context, not a verified authority.
- Declare when the reference was prepared
Declare when the reference was prepared.
This date comes from the file owner. Loading it today does not prove it is current.
- Load the reviewed reference
Load the reviewed reference.
Load all six mapped rows. The original file and excluded column are discarded; the exact mapped values and row numbers remain.
- Show a missing location honestly
Show a missing location honestly.
This listed code has an empty location cell. The result says No location supplied rather than inventing a bin.