Product placement Database
- or -
Post a project like this- Posted:
- Proposals: 11
- Remote
- #1323071
- Awarded
Description
Description of requirements/functionality: We need a database utility whereby a member of staff scans a barcode of the product and it tells them what bin location to place it in.
Need it to be a very simple to use front end.....ie scan the barcode...it tells the warehouse operative where to put it.....location stays on screen until the next barcode is scanned.
We do not want the warehouse operative to interact with the system whatsoever, all they will be required to do is scan the barcode...place the product in the correct bin....then scan the next barcode (all very boring stuff!!)
A simple diagram has been included, so you can see what we need. The location part of the Diagram is based on a primary location (in the example the first digit is 4 being Area 4 and the second set of digits in the actual location of the bin in Area 4)
If a part number is encountered that is not on the database, this will need to be placed into a seperate location for inspection...so an example would be to place that part in location X - XX instead of a recognised part that went to location 4 - 44
The app needs to be very fast and useable without any decreases in speed or performance.
Again I must stress that we need the warehouse operative to have minimal interaction with the input, it must be completely barcode scaner driven so that they do not have to reset the scanning input etc as they will have no access to mouse or keyboards.
We will be using PC's for the scanning, but not ones attached to the internet or network....Basically standalone machines that can have an excel spreadsheet uploaded to it by our technicians whenever we need to update the database on each machine.
Hope this makes sense and look forward to hearing from you!
CMS and Admin requirements: All we need is the ability to upload an excel file that has the following for columns....
Product code (Visible on input screen)
Area (or location) code (Visible on input screen)
Bin location (Visible on input screen)
Product Description (Hidden on input screen)
Product Model (Hidden on input screen)
Extra notes:
Scott C.
100% (6)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Any chance on getting any estimates on the total number of records on the spreadsheet? Thanks, Tom
-
Hi Scott,
Could you please clarify what's your expected average database size (total number of records on the Excel spreadsheet)?
Cheers,
Tom -
Hi Scott,
You refer to this as an "App", so I assume this is to be an Android or iPhone app? As opposed to a Windows application running on a PC/laptop. Please confirm.
Also, would you consider an App that uses RFID instead of a barcode? This means that the operator simply has to hold the Android device (phone/tablet) close to the Product in order to display the bin information, i.e. no need to hold a [cumbersome] bar code scanner in the other hand.
Regards,
Jeremy
London NW3Scott C.14 Oct 2016Hi Jeremy,
Apologies, should have made it a bit clearer in my initial post. This would be on stand alone win 10 pro PC's.
Basically we receive a faulty product that has a barcode attached to the item, I need to be able to scan that barcode and assign it a bin location so that the operative can place it in the correct location for our techs to inspect and decide on a visual inspection whether to repair or discard for recycling.
Hope this helps
-
Thanks for the invitation,
I have a few questions to send you my proposal.
1) Do you want only the app as data entry and search? no other back office application? This means scan a barcode to enter a location and scan a barcode to search the location on the database. Only this features?
2) do you want on Android/iOS phones/Tablets?
3) What kind of bar code are you using?
4) Using only intranet (only by wifi) or internet app?
5) any User authentication/Validation?
RegardsScott C.14 Oct 2016Many thanks for your questions.
Literally all we want to do is assign a location to an item that has a barcode attached to it, stand alone win 10 pro units that we can manually update and excel spread to...
The main functionality will be just to scan a barcode and put it in a location...nothing more, and more so that we have no other interaction for the user other than to just scan...place...and scan again
RegardsTRUEBI LLC17 Oct 2016Thanks, but still pending my questions? do you want a mobile or PC app to scan products?