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,