Small warehouse software-excel

CLOSED
Bids
10
Avg Bid (USD)
$297
Project Budget (USD)
$30 - $250

Project Description:
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

Skills required:
Excel, Software Architecture
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 5 days
Hire pkcyber
$ 250
in 3 days
$ 249
in 15 days
$ 150
in 7 days
$ 550
in 10 days
$ 241
in 4 days
$ 308
in 7 days
Hire ms3prov
$ 550
in 30 days
Hire hdkf79
$ 300
in 3 days
Hire subodanaherath
$ 220
in 10 days