I hope this is the best place to ask questions like this I am looking for a solution on how to properly implement warehouse architecture based on Django models.
Let’s assume the below points:
- Same items can be purchased at different prices and qty depending on the supplier and date
- Warehouse should store information about each item or purchase?
- During item sales, Django should look for all purchases and decrease stock for certain items
Looks simple? I don’t think so
So I managed to make models like:
Item/Product → General information about item like color and image
OrderProduct → Store information about a certain product, purchase price, and qty
Order → Collect all OrderProduct which was purchased from one seller
Warehouse → No idea how to manage it
And this point looking for support how I should manage “selling” products from warehouse. Any ideas or tips?