Creation of a warehouse database and a program to support it

We are looking for a contractor to create a warehouse database of products and a program to support it.

The database is to have standard warehouse functions, such as saving an order, contractor, booking an order, changing an order, tracking order status and shipments, searching by all data.

The ability to add an order through a form, as well as through structured data (shoper).

The database is to have the key function of decomposing the set into items and summing their quantity with the other items in the order. E.g., the order will show set 1 (composition of item a, b, c) and set 2 (composition of a, b), and the program should generate an order printout of either the sets or the summed items upon request.

Another key feature is the reporting of stock differences, the number of reserved and ordered items to keep track of stock levels.

The ability to create more warehouses and flip items between them. Additional warehouse for raw materials and semi-finished products.