How do I get my spreadsheet of barcodes to append data from an asc file?

I have an ASC file with all of the products I can sell in my store. I want to scan the barcodes of stock I actually hold and have it pull the data from my ASC file.

The ASC file gets daily updates, I’m not sure if this is relevant.

Thank you in advance.