I want to keep track of goods from my warehouse in a small software based on excel.
1- Be able to scan inventory through the UPC number as it arrives.
2- Have a laptop attached to the scanner
3- Have the program enter the inventory directly into Excel
4- if there is a duplicate UPC number have it total directly into the cell. In other words if there is 20 each of an item, have it total the amount received in the cell.
The software will have two parts:
a. Database of information where it pulls information – I have information for about 25000 different products with Brand, Part Numbers, Description. And I have about 5000 UPC codes for those products. Meaning that I don’t have all UPC codes necessary. This information must be editable/extendable and there must be a possibility to add additional parameter. Let’s say I don’t have the colour, I want to add additional parameter and enter colour.
b. Current inventory - software will show how many pieces of specific products are present in stock. The quantity can be added manually by adjusting the number or after scanning. One scan will mean +1 piece. And normally will need to be able to export all in excel file. Let’s say I scan the UPC code 46546848645, then I want the software to add into inventory. If there are already 3 pieces of it, then it is going to get updated to 4. If it gets scanned for the first time, it will create a new line and put quantity 1. However, if I scan a UPC code which is not in the database of information, then software will enter it in new line, and you can update brand, part number etc. You can either associate the UPC code with the existing product in the database, or enter an absolutely new description. All info can be exported into excel.
This is a simple software, so won't accept high quotes. Thanks