Need some help figuring out a major shipping problem. We have a site running on Magento 1.9x and we sell automotive parts. Due to the nature of the business we need some major functionality in order to be competitive and cannot figure out how to make the required shipping feature work. One required feature for us was dimensional shipping since some parts can be quite big but light weight (body plastic trim parts, spoilers etc) and we need a solution that would have accurate live rate shipping and found a good solution using AuctionInc shipping module. Our next biggest issue is free shipping: We basically break down the products into 2-3 categories: parts that can be shipped from our vendors warehouse for free in the US (lower 48) if the total cart is at least $150 and max weight is 15lb. Then there are parts that always ship from our warehouse so customers should only see live rate for those. Then there are specific products such as hazardous material (liquids, oils, chemicals) that can only be shipped in the US via Ground, no International shipping allowed. We thought we could achieve this with shopping cart rules but found out it is not possible. For example I created a rule that if cart total is min $150 and products are from "vendor1" shipping would be free in the lower 48 states. After testing I saw that if I put a product from this vendor1 in the cart sure thing free shipping shows up, as well as additional shipping options (FedEx or faster shipping methods) which is great. But as soon as I add another product not from vendor1 which requires customers to pay for shipping, it does not work. The cart just keep showing free shipping for everything. I have looked at every possible modules and extensions on the market for Magento but cannot find a solution on how to solve these issues. Is there any way to make this work with Magento or are we pretty much dead in the water? We're desperate at this point to find a solution, any help would be appreciated.
Thanks in advance.