Inventory tracking, barcodes and populating fields


Am working on putting together a base for better tracking of inventory bought/sold on Amazon and other channels. Would like to be able to use a barcode field which when an item is scanned, it goes out and searches Amazon and comes back with the item’s title in another field and in another field it enters the item’s current ranking.
Also, anyone familiar with using Airtable integrated with Woocommerce? Looking to have several niche websites for products sold in-house or dropshipped, and best ways to keep track of it all besides spreadsheets.