We are looking for a software developer with experience in Magento and warehouse stock control systems.
We are an online retailer, and use Magento as our back office system. We currently have software to scan and dispatch our items and orders. However we don't have any software to manage our warehouse:
We would like software creating which will run on a warehouse PDA / barcode scanner, and update Magento.
We would like to be able to scan a barcode on a product, and the app should bring up the current location, quantity in stock, and provide a field where we can type in the quantity received and update magento.
If the product barcode is not found on the system then it should create a new "ghost product" in magento - ie a product where the user has to enter a product name (title), SKU, quantity and location. This can be used to create a new magento product which is disabled until a member of office staff edits the product and fills out the fields fully.
Picking of orders:
We don't pick items per order, we pick all items per courier - Our system already works out which courier each order is going with and changes the orders status accordingly.
Currently we rely on a php web page which has a drop down for orders status, and delivery speed (controlled by a Magento order attribute). This returns a list of all items, on all orders which are awaiting picking / packing. These are ordered by warehouse location, and grouped by product SKU, ie:
Location Quantity SKU
A1 2 ACME123
A2 1 ACME452
A2 6 ACME953
B4 2 ACME0987
We would like to turn this simple php page & system into a part of the app. The user enters a starting location ie "A1", and the app then brings up the first item to be picked from that location. So the screen displays that we need to pick 2 x ACME123 from location A1. The user can then scan the products barcode to confirm they have the correct product, the screen shows how many need picking, and then the user should enter how many they have picked ie "2". The app confirms the pick, then moves onto the next product to pick (displays that we need 1 x ACME452 from location A2).
We need a way to do stock takes of items in the warehouse. We should be able to do an on the spot stock take of any particular item by scanning the barcode and entering the quantity on the shelf. We should update a magento product attribute with the time & date of last stock take.
Move products location:
We only store each SKU in one location in the warehouse. ie each product only has one "picking face", this means that sometimes when new stock comes in , we need to move stock from one location to another to ensure it all fits in. We need to be able to do this with a simple move function - scan the product, enter new location
This should be an option when using the "goods in" process, as well as when using the stock take function.
We are open to ideas and suggestions on the processes outlined above, as this has only come from what we believe would work best for us.
All code should be provided and well commented.
Please see attached file "additional details" for some further information.