[HELP] Weight-based calculation not working on checkout page

Hi, newbie here with my first forum post looking for help.

I’m having an absolute nightmare with my e-commerce website, Webflow Support is unresponsive/ their AI bot keeps closing the request without passing me on to a human and from what I can tell, every topic even remotely related to my issue is dated by like 4+ years, with no solution. GPT also can’t help.

This is my last resort, reaching out to the community. If this doesn’t work I’ll likely close my webflow account and move elsewhere.

Rant out of the way… here’s my issue.

My client’s e-commerce is trying to calculate shipping costs based on the overall weight of the basket.

the rule is in place here:

All of the products in the list have weights implemented like here:

but when I test checkout on my published site, it displays the total shipping cost in the summary as $1, even though my cart is full of items with multiple weights which should see the overall shipping cost exceed waaaay over $1:

If ANYONE has a solution here, that doesn’t involve using an external service like shippo, please, I beg you, share.

Thanks
George


Here is my site Read-Only: Webflow - APE Solar

And here is the live site: https://www.apesolar.com
(the issue is on the checkout page)