Stock Allocation System
Budget: £3,000 – £5,000 GBP
I'm looking to develop an online allocation system to track inventory across multiple stores and replenish stock based on sales. The system is to be web-based and handle user accounts for access to view, update and delete the data. It will also keep track of supply data, but the main focus is to monitor and replenish inventory from multiple locations.
Features need to include
- Allow importable and exportable Excel updates to allow easy updates of stock and allocations.
- We think it should work out an allocation based on sales rather than stock. So you sell 2 you get 2 back. If you sell 3 it should round up to 4. The rounding up would mean we're sending more than we’ve sold in some cases, however we know stock loss is high so it should counteract this. This is due to the packs of 2 products are sent out in.
- Allow stores to be blocked from an allocation as needed.
- Master and Slave SKUs – A new SKU is allocated annually, but they will need to link back to a master SKU.
- Depot Stock. Stock is sent in bulk to the main warehouse, the allocation needs to take into account what stock is available and not allow unlimited stock replenishments.
- Manual Allocation – the ability to pull an allocation based on a single store number or group.
- Categorise the stores by group, then sub group (so bands 1-5, then broken down further based upon sales)
- Prioritise high grossing stores for allocations.
- It would be good to be able to summarise an allocation topline by store. This way we can sense check if a store is receiving too much or too little in comparison to its stand fill.
- On the above if each store had a profile in which you can set its stand fill level, add its banding, address, stand type etc this is also where you could block a store from receiving an allocation.
- Sales history – It would be great if you could generate an allocation based on either average sales or peak week sales. If we know were set for wet weather we can allocate based on peak week and ensure stores are well stocked. So could the system store historical sales data for each store.
- Using an API link to bring in weather data based on Postcodes within the UK - to identify high rainfall areas to inform stock demand.
The ideal candidate should have experience with database design, web development and user authentication. They should also be able to demonstrate their knowledge and provide suggestions on how they can improve the system. In order to ensure the highest quality of work, the freelancer should also be able to provide feedback and support following the completion of the project.
We have attached a more detailed description of what is required.
Features need to include
- Allow importable and exportable Excel updates to allow easy updates of stock and allocations.
- We think it should work out an allocation based on sales rather than stock. So you sell 2 you get 2 back. If you sell 3 it should round up to 4. The rounding up would mean we're sending more than we’ve sold in some cases, however we know stock loss is high so it should counteract this. This is due to the packs of 2 products are sent out in.
- Allow stores to be blocked from an allocation as needed.
- Master and Slave SKUs – A new SKU is allocated annually, but they will need to link back to a master SKU.
- Depot Stock. Stock is sent in bulk to the main warehouse, the allocation needs to take into account what stock is available and not allow unlimited stock replenishments.
- Manual Allocation – the ability to pull an allocation based on a single store number or group.
- Categorise the stores by group, then sub group (so bands 1-5, then broken down further based upon sales)
- Prioritise high grossing stores for allocations.
- It would be good to be able to summarise an allocation topline by store. This way we can sense check if a store is receiving too much or too little in comparison to its stand fill.
- On the above if each store had a profile in which you can set its stand fill level, add its banding, address, stand type etc this is also where you could block a store from receiving an allocation.
- Sales history – It would be great if you could generate an allocation based on either average sales or peak week sales. If we know were set for wet weather we can allocate based on peak week and ensure stores are well stocked. So could the system store historical sales data for each store.
- Using an API link to bring in weather data based on Postcodes within the UK - to identify high rainfall areas to inform stock demand.
The ideal candidate should have experience with database design, web development and user authentication. They should also be able to demonstrate their knowledge and provide suggestions on how they can improve the system. In order to ensure the highest quality of work, the freelancer should also be able to provide feedback and support following the completion of the project.
We have attached a more detailed description of what is required.