Shipping - Dimensional Issues - Multiple Methods Per Order

I've read some of the threads regarding the lack of proper dimensional shipping in CSC, which is part of the problem.

The biggest problem is this...

I have certain products that need flat rate shipping. So a winch, which is 75 lbs, sells for $500 and needs to ship flat rate... $50 for example.

I have some products that must have a live shipping solution, FedEx Ground typically, a winch mount bumper for example that weighs 85 lbs and has a cost of $550.

The first is because the products total 160lbs FedEx won't show Ground Home Delivery because their limit is 150lbs...even though they ship separately, sometimes from me, sometimes from a drop ship. That's a dimensional issue I think, or at least in part.

Sometimes a customer orders both at once, so now he has flat rate and a live rate items in the cart. CSC returns a shipping solution with:

Sorry, it seems that we have no shipping options available for your location.
Please check your shipping address and contact us if everything is okay. We'll see what we can do about it.

What I need is an addon that enables product by product shipping as it seems CSC won't do that. I've run CSC for many years so I'm pretty familiar with it and don't see a solution for this problem. I have Hungryweb's Shipping/Payment Restriction addon which he kindly updated for 4.8.x and it does what it is supposed to and whether I have it running or not, selected restrcitions or not, this is obviously an issue related to the core CSC shipping logic.

So, what I would like to see is the cart with the winch listed with the flat rate shipping, then the next line shows the live rate methods and so on...the neatly totals it all up and let's him checkout out.. sale complete.

What am I missing? Is there no solution to this?

Ok.. so hang with me here as it might get a bit lengthy... but I think I have a combination here that works.

So I took a look at the Suppliers addon that comes with CSC and thought that I could go ahead and assign the product(s) to suppliers, my company, and others. I don't want them to be notified as we use a PO system so I simply used our email (but really don't want to receive those, needs a checkbox for that) and enabled.

I have the Hungryweb (HW) payment/shipping restrictions addon installed as well, keep that in mind.

The logic here is that you set suppliers to be more restrictive or inclusive depending on what you are doing and use Hungryweb's addon to be more inclusive. It's complicated and depends on how your business operates.

I have products we manufacture that ship using live methods.. FedEx Ground, etc, we have some products that ship free.

We sell third party products, some ship free, some flat rate, some live.

The problem is that if you restrict our products that ship live by excluding flat rate via HW's addon it will kill shipping methods for any other product that needs to ship via a supplier that ships flat rate. If we included flat rate at the product level and have 0.00 in the Shipping freight box then flat rate will show Free.. you know what the customer will select, free of course... we don't want that... so then we exclude Flat Rate with HW's addon but that kills any other flat rate products even if from different suppliers... so to fix it we enable flat rate in the product using HW then exclude flat rate at the supplier level. The trick here assigning free shipping to a live rate.. FE Ground.. and never use flat rate for free shipping.

It really depends on your shipping arrangement with suppliers and even down to the product. Some suppliers... Warn Winch for example.. have winches we can ship free, some flat rate and some need a live rate.

This is all doable by using suppliers and HW's addon. The only caveat is that you may need to create multiple suppliers for each... Warn Live.. Warn Flat Rate.. if the combo of issues dictates it.. haven't had to do that yet....yet.

If done right you get what you see in the attached screen shot.

This is not something you want to implement on an existing store with tons of products as you will need to address the HW exclusions in each product and is not something you can do by global edit. Luckily we only have 260 products so it's not the end of the world and as we add products we address it all then.