Shipping weight for multi-item orders

1. WordPress: 6.5.2, WooCommerce: 8.8.3, Weight Based Shipping: 5.9.0, PHP: 7.4.33

2. <one or more links to screenshots here>

I am not reporting a bug but rather asking for your opinion of the best way to handle our situation.

We are based in the US and sell 10 different physical products on our website. Buyers use our WooCommerce store to select, order and pay for their products, including shipping. The order goes to a warehouse where the products are stored. The warehouse boxes and ships the order and charges us for the exact shipping they calculated. Of course by the time we are charged for the shipping we’ve already had the customer pay us for what we “thought” the shipping would be.

The warehouse uses the best shipping method depending on the current shippers’ fees and where the item is going. As you can imagine sometimes what we charge the customer is more than what we pay for shipping and sometimes it is less.

We moved to WooCommerce and Weight based shipping to give us the flexibility of multiple shipping options. It has worked well EXCEPT for large volume orders. We sell 10 different physical products but people frequently buy multiple. Product A weighs 2.3lbs. If someone buys 10 of Product A then the Weight Based Shipping plug-in calculates the shipping as 10 times the shipping for 1 Product A or 23 lbs. No problem because I’ve entered amounts for shipping up to 50 lbs in the table and the plug-in knows how much to charge.

However here is the problem – Product A is sold in boxes of 10. One box weighs 23 lbs. If a customer orders 7 boxes then Weight Based Shipping actually calculates 10 x 7 x 2.3 or 161 lbs as the weight of the order and attempts to look it up on my shipping rules. My shipping rules only go up to 50 lbs, so Weight Based Shipping tells the customer that shipping can’t be calculated. I want Weight Based Shipping to look at the weight of each box (Each Box of 10 is sold as its own product) and multiple that fee by the number of boxes to be shipped. Each box weighs 23 lbs which CAN be looked up in my shipping rules since they go up to 50 lbs.

How do I ask Weight Based shipping to calculate shipping fees per product and then add the fees up to get the shipping total? Otherwise my Shipping Table will be too big to keep updated for multiple shipping methods, even just for 10 products. I really would like to use the plug-in but I need this flexibility. Do you have a PRO version that adds this capability. I looked at Advanced Weight Based SHipping but it isn’t capable of this either (or I overlooked it if it does). Thank you very much.

My shipping table:

https://drive.google.com/file/d/1TLjetSczzUTRbBdi9aWvHR0f-S3jPZSs/view?usp=sharing