With Inventory Software using MSS Software's Inventory Tracker, you start the inventory process with a spreadsheet list of all your Part Numbers, Descriptions, Prices, etc. The Quantity field starts out as 0 (zero). Then you scan your Part # and input the quantity.
Sample of Master Spread Sheet with parts, quantities and total price.
Matching Data Collected with the Master Spreadsheet
Now, using a simple utility, the Inventory Tracker Utility from MSS Software, the barcode collected data is matched to the Part Numbers and Quantity fields of the Master Spreadsheet with the correct quantity. The Inventory Tracker Utility produces an updated spreadsheet containing all the fields, including the Quantity field. By applying simple formulas, you can get results such as "Total Price" as shown in this example.