I need a software for order pick up in a retail location.
All the items are located in Bins.
The software written in php needs to interface with a SQL database.
The software needs to have codes which correspond to upc that are created in a separate bar code program(which we already have).
The software needs have several identifiers .
2. Sales order #(or S0#) which will be scanned as well from our currrent packing slip.
3 Date of scanned
4. Date of PICKUP
5 BIN # (bin numbers start at 001 and end at 200
6 sales rep
The software needs to allow me to attach sales order numbers to bin #'s as well as dating them.
So once a bin # is scanned it allows me to scan and attach a sales order to that specific bin.
At that time i will also be able to put in a optional name , as well as the rep name
A status screen needs to be created in a table format that will show the date sales order was scanned in , the customer name and date scanned. The sales rep. It will also display and organize by oldest date. The Bin# will not be shown unless a code is put in and then the fields will be shown.
so this way people do not just grab their bin without having someone sign them out, since they do not know what their bin is attached to .
Once an order is picked up the bin # is scanned again and it asks if order is being picked up if yes it asks to put in the password.,, then it records the pick up date and removes it from the active list and detaches the current sales order from the bin# so the bin# can be reused.
in order to scan the bin i must have a password. in order to see the bin# i need to put in a password. in order to detach i need to put in a password
I also want to have a separate window that i can pull a quick report for date sales orders are picked up. as well as bins assigned to reps that have not been picked up. So this way the rep can monitor who they need to contact to pick up their sales orders.
29 freelancers are bidding on average $1265 for this job
I am ready to get started right away.... Can we discuss the project details? My distinction, payment after your complete satisfaction with the resulted task.