Complex Delivery Matrix Cost Calculation
-
I’m working on developing a site for a local landscaping company. They have products such as mulch, gravel, and dirt. Each product can be picked up by customers or under certain circumstances, delivered.
To deliver, the customer must order at least 3 bucket fulls of a product. They can order up to 12 bucket fulls of mulch or up to 6 of gravel/dirt (due to weight in the truck). For delivery under 5 miles from the store, it’s a flat rate of $39 and above that, $7.99 per mile is tacked on. The products obviously can’t mix, so different trucks would have to apply to the order. Some example calculations:
3 buckets of mulch 4.2 miles from store: $39
12 buckets of mulch 5.1 miles from the store: $39 base + 0.1 miles \* $7.99 = $39.80
18 buckets of gravel 3 miles from the store : $39 base \* 3 truck fulls = $117
4 buckets of mulch and 2 buckets of gravel 4.2 miles from the store: $39 for the mulch, mandate customer pickup of gravel (under 3 quantity limit)
5 buckets of mulch and 8 buckets of gravel 6 miles from store:
Mulch(39.99 + 7.99 = 46.99)
\+ gravel split into 2 trucks of 4 buckets eachGravel(2 * (39.99 +7.99 ) = 93.98)
Order total =$140.97
So far I have tried WooReer, Table Rate Shipping, WooCommerce Per Product Shipping, WooCommerce Advanced Shipping Packages, and WooCommerce Distance Rate Shipping. This has gotten me pretty close on a number of fronts, but I haven’t quite managed it. WooReer got me closest, but it is taking the total order quantity into account rather than per item (so in the second to last example it just sees 6 total items and thinks that meets the order minimum of 3, rather than being able to handle the 2 buckets of gravel not being acceptable).
Is there a plugin out there that is capable of this? Does it have to be a custom plugin? Or should I just try to get the client to simplify their shipping schemes?
- The topic ‘Complex Delivery Matrix Cost Calculation’ is closed to new replies.