Track warehouse order progress using barcodes

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

Tracking Order Progress Using Barcodes.

Quote format

Please read this document before quoting.

Proposal should include

Price

Leadtime

Previous experience

Hardware - scanners - cost estimate ( I will source hardware but would be great if you could help specify ) Based on 3 mobile and 4 fixed scanners.

Background

We process a high volume of orders through our warehouse and all orders are manually picked and packed. We need to implement a way to track who has picked and packed each order and what time. This will allow us to do the following things…

Monitor productivity

See who has packed / picked each order so we can improve training when mistakes occur.

Get a time of when an item was packed so we can check CCTV if customer claims not to have received an item in the package.

Improve productivity as there is no need to sign an order.

We won't need to ask customers to check who packed their order ( looking for signed initials on invoice etc )

All our order invoices, which also form our pick sheets, can be printed with a barcode for the sequential order number.

Project Overview

To write some software and propose some barcode scanners that can be used to automatically compile a spreadsheet - ideally in the cloud on google docs / google sheets / google forms etc.

Physical Equipment

There is a picking area where orders are manually picked and placed onto a conveyor. The idea is that the 2-3 people working in this area will have portable barcode scanners to scan the order as they place on the conveyor.

In the packing area there several people packing products. The concept here is to have scanners mounted above the workplace ( 4-5 workstations ) and that you have hold the order with barcode on under the scanner. This will then record who picked the order and the current time.

Database

The database will compile date on

Order number

Picking person

Picking time

Picking error recording

Packing person

Packing time

Packing error recording

Process flow

Order is picked

Order is scanned by the picker on mobile scanner

Order is scanned by packer ( some sort of error if there is no data of the order being picked ? )

Order is packed

At later date is mis pick / mis-pack is recorded in cells

The database can then be analysed monthly for things like … qty of order packed per person / errors per person / total orders processed etc

Key points.

Mix of scanners / fixed and portable

Need to control who is using scanner ( logged in ? / scanned in as user ? / each scanner is linked to one person ? )

Need to identify which scan is a pick and which is a pack ( logged in as function ? scan a barcode “Harry picker” ? each scanner has own address ? )

Some sort of backend to control update peoples names etc ?

Output

The database must be accessible via internet / possible phone app ? / google docs ?

Deliverables

Software package

Recommendation for suitable scanner spec ( wifi ? bluetooth ? )

Tech Support during implementation.

Database Development PHP Python Software Architecture

Project ID: #14647079

About the project

39 proposals Remote project Active 6 years ago

39 freelancers are bidding on average £2641 for this job

uhjk

Hello, I did similar project before. They asked me to build system to send "correct" item. When they scan product, it compared it with database and says if it's good or no. Relevant Skills and Experience I am good wit More

£750 GBP in 8 days
(1342 Reviews)
8.8
fleetways

Sorry for exceeding the max budget. May be we need to discuss about your choice of barcode scanne (scanner app for mobile or scanner device connected to PC or wifi), also a web hosted solution for the order tracking wo More

£3335 GBP in 60 days
(98 Reviews)
8.3
esalem

Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. Relevant Skills and Experienc More

£3157 GBP in 45 days
(62 Reviews)
8.0
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore More

£515 GBP in 10 days
(54 Reviews)
7.1
amin6106

hi there, i can help you develop, i have experience of working with barcode + tracking web app, i have done this for ecommerce website and for pizza business and currently i am working on similar Relevant Skills and E More

£400 GBP in 14 days
(90 Reviews)
6.4
umar064

i am experienced software developer. new to freelancer that is why you will not find much reviews but i am sure after look at my work you will give me good reviews. contact me before accepting for details and a huge di More

£250 GBP in 5 days
(27 Reviews)
5.6
TopsTechno12

Hi, We Masters in the same and have done and delivered such custom systems for our clients. Developed it for the client who has a warehouse in Spain, a direct sales distribution channel and 2 supermarkets and an More

£833 GBP in 30 days
(3 Reviews)
5.7
Valuesolutions

Hello, how are you? I hope you have a bright day/evening from your side. I have read the details provided, but please contact me so that we can discuss more on the project. Relevant Skills and Experience Database Deve More

£250 GBP in 5 days
(31 Reviews)
6.2
abhinavs1ngh

Hello. Thanks for reading my proposal. I want to long-term relationship and I wanted to contact you. I’ve read your brief and I could absolutely help you with your goal. I wish to you call on chat. Relevant S More

£555 GBP in 10 days
(14 Reviews)
4.9
shahalam7303

Hello Sir, I have properly gone through your job description and understood your requirements. I'm very eager to work on this project and will definitely make a successful delivery before deadline. Relevant Skills an More

£555 GBP in 10 days
(6 Reviews)
4.9
webdev1802

I have 6+ years of experience. I have reviewed your project requirement and I can do this work, it will be good if we once discuss about the requirement, I have done similar kind of work in past. Relevant Skills and More

£555 GBP in 10 days
(15 Reviews)
4.9
Anthony989

Hello, I am Anthony from Sri Lanka and I am a FULL time freelancer. So this is basically my job and I dont mess with it. I have multiple degrees in Electronic and Mechanical Engineering. Relevant Skills More

£555 GBP in 10 days
(9 Reviews)
4.7