I have different warehouses like warehouseA, warehouseB, warehouseC. I purchased one item like product1 as qty 20. This item is available in three warehouses with 10,5,10. This order is check the item is available in warehouseA it decrease the 10 items and remaning in warehouseB, reamining in warehouseC like a below matrix structure.
WarehouseName location productqty warehouseA Bangalore 10 warehouseB Hyderabad 5 warehouseC Delhi 10
customer purchase the item with Qty 20 to shipping address kolkata. I want the shipping calculation from bangalore->kolkata for 10 items,hyderabad ->kolkata for 5 items and Delhi->kolkata for 5 items?