Build an Inventory database for tracking inventory between multiple locations using barcodes

Dear Candidates, This program should act as an inventory tracking software first. There should be an Admin panel where we can add Products (Barcode, Manufacturer Product name/#, Description, whether or not it requires a serial # when used) and Locations (Location name, whether or not it is a client location). We also need to track the qty of items per location. From the admin panel, we should be able to scan a barcode and if it is in the system, it should show all current inventory levels (for spot checks), and if it is not in the system yet, allow it to be added. There should be a user section that will allow a user to do the following: Add inventory to a non client location (ie. receive a shipment) Transfer inventory between non client locations (ie. from main warehouse to a service van) Use inventory (ie. items taken from van or warehouse and installed ) When doing any of these transactions, the method for scanning the items in to the system should be similar to checking out at the store. You should open a 'cart' and scan all of the items in. For example, you click "use inventory", select the client location and warehouse, then begin scanning items. You should be able to scan Item1, Item2, Item3 and then scan an additional Item1 and then item4. It should give you a chance to edit these quantities and then give a spot to click submit. Each transaction should then create a report that is emailed automatically or tracked within the database. And it should adjust the inventory levels accordingly. There are some additional minor requirements like recording the serial numbers for some devices when they are used on a client site (no need to track before install). The biggest thing is making a very easy to use system for scanning items in and out quickly in batches. I am looking to start on this project ASAP