Barcode Scanning Inventory Management

All of our inventory has barcodes, for example for Item: PF1234 the barcode in physical tag is PF1234--Red--XXL

 

I am trying to create a view where I can scan my product barcode and the app can tell me what is the quantity of the stock from Google Sheet

My Sheet Contains: 

Product Name, Sale Price, Current Quantity

 

Can anyone help, I am unable to complete this Use Case.

 

Thanks,

0 1 154
1 REPLY 1
Top Labels in this Space