Closed

Small warehouse software-excel

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: Excel, Software Architecture

See more: small warehouse, create small software excel, small warehouse software excel, excel program warehouse, excel warehouse software, small warehouse program excel, warehouse associate, track quotes, parts inventory database, amount received, a.b.c. warehouse, warehouse, warehouse inventory, upc codes, small architecture, simple software, excel inventory, excel duplicate, excel colour, duplicate inventory, excel upc, warehouse stock excel, excel based software, excel based inventory program, excel additional

About the Employer:
( 5 reviews ) Warsaw, Moldova, Republic of

Project ID: #4415478

10 freelancers are bidding on average $297 for this job

atchayagandhi

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 More

$150 USD in 5 days
(18 Reviews)
5.8
pkcyber

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 More

$250 USD in 3 days
(18 Reviews)
5.1
mlacunza

Hello I can create your software please check PMB

$249 USD in 15 days
(5 Reviews)
3.6
omaralieissa

Hi, i can do it, but need more details about project, thanks.

$150 USD in 7 days
(4 Reviews)
2.8
israrsoft

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 More

$550 USD in 10 days
(1 Review)
2.4
amraox

Dear Sir Madam I have pledge working experience for the related areas therefore I can do the project with deadline and recruitment Best Regards

$241 USD in 4 days
(0 Reviews)
0.0
hdkf79

Small warehouse software-excel

$300 USD in 3 days
(0 Reviews)
0.0
ms3prov

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

$550 USD in 30 days
(0 Reviews)
0.0
subodanaherath

I am ready to take your project. Thank You

$220 USD in 10 days
(0 Reviews)
0.0
tupuconstantin

I understand your task. I can do this task quickly and accurately. Thank you, Constantin

$308 USD in 7 days
(0 Reviews)
0.0