I would recommend using your SKU (Stock Keeping Unit) product field to use as a way to locate inventory. SKU code should help you identify the exact product variant you are looking for and you can even incorporate its warehouse location. Therefore, you should incorporate information on color, type, size, and other similar attributes into the SKU. This saves you time in decoding the SKU during everyday operations. For example, if your product list includes a chair that comes in various sizes and colors then the following would be a good SKU code: CHR-S-BK-I2-S7 (Chair, Small, Black, Isle 2, Shelf 7).
I hope this helps! If there is anything else I can help you with, please let me know.