My client has products stored at three different warehouses, each is a separate company which ships independently for an example:
Product X located at warehouse X - light weight products shipping cost $5
Product Y located at warehouse Y - medium weight products shipping cost $10
Product Z located at warehouse Z - heavy weight products shipping cost $20
If a customer buys product X, product Y & product Z we want them to be charged shipping at $35, in other words a shipping cost for each item, not just a single fee based on total weight.
It also needs to charge based on weight per warehouse, e.g. if someone buys 2x product X plus product Y it should be a higher shipping cost for product X but remaining at $10 for product Y.
Is it possible to achieve this with any module? kindly suggest