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
10 freelancers are bidding on average $297 for this job
HI, we can deliver the application and have it customised according to your needs,. We have experience in Inventory applications. We are over 165 projects strong. We might need a little more details however. Kindly req Daha Fazla
Hi, I can give u a web software for this. Which will do the things you mentioned below. Also as it is web system, you can access it from any where, without installation of any thing. Moreover, it has reports Daha Fazla
Hi, i can do it, but need more details about project, thanks.
Hi; I have studied your project requirement and understood the requirement. We feel confident about this project. We would like to share our experience to develop your project also. Please open chat so that we can show Daha Fazla
Dear Sir Madam I have pledge working experience for the related areas therefore I can do the project with deadline and recruitment Best Regards
Understand your requirement. Competent enough to complete this job on time. Have further questions to detail out your requirements. 16+ years of experience in Database and Excel
I understand your task. I can do this task quickly and accurately. Thank you, Constantin