Page 1 of 1
Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 4:32 pm
by tessthepup
I have setup my shipping table rate as follows
100:2.29,250:2.83,500:3.39,750:4.30,1000:4.85,2000:6.57,2250:6.98,2500:7.40,2750:7.80,3000:8.20,3250:8.60,3500:8.99
I have added one product to the basket weighing 76 however the table rate on the shipping page is showing a value of £4.58
Surely it should be showing 2.29 ???

Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:02 pm
by heatherbell
tessthepup wrote: ↑Sun Mar 13, 2022 4:32 pm
I have setup my shipping table rate as follows
100:2.29,250:2.83,500:3.39,750:4.30,1000:4.85,2000:6.57,2250:6.98,2500:7.40,2750:7.80,3000:8.20,3250:8.60,3500:8.99
I have added one product to the basket weighing 76 however the table rate on the shipping page is showing a value of £4.58
Surely it should be showing 2.29 ???
Double check Tare Weight = 0 in Configuration>Shipping/Packaging?
Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:04 pm
by tessthepup
heatherbell wrote: ↑Sun Mar 13, 2022 5:02 pm
tessthepup wrote: ↑Sun Mar 13, 2022 4:32 pm
I have setup my shipping table rate as follows
100:2.29,250:2.83,500:3.39,750:4.30,1000:4.85,2000:6.57,2250:6.98,2500:7.40,2750:7.80,3000:8.20,3250:8.60,3500:8.99
I have added one product to the basket weighing 76 however the table rate on the shipping page is showing a value of £4.58
Surely it should be showing 2.29 ???
Double check Tare Weight = 0 in Configuration>Shipping/Packaging?
First thing I checked and yes it is 0
Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:17 pm
by ReneH4
I'm sure you noticed it but just in case: It's exactly double the amount it should.
Might be a bug?
Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:18 pm
by ecartz
Check that "admin > Configuration > Shipping/Packaging > Enter the Maximum Package Weight you will ship" is set to 3500 (the maximum value in your table) rather than the default 50.
Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:22 pm
by heatherbell
ecartz wrote: ↑Sun Mar 13, 2022 5:18 pm
Check that "admin > Configuration > Shipping/Packaging > Enter the Maximum Package Weight you will ship" is set to 3500 (the maximum value in your table) rather than the default 50.
Should there not be a Message or checkout prevention if order weight > Maximum Package Weight?
Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:28 pm
by tessthepup
ecartz wrote: ↑Sun Mar 13, 2022 5:18 pm
Check that "admin > Configuration > Shipping/Packaging > Enter the Maximum Package Weight you will ship" is set to 3500 (the maximum value in your table) rather than the default 50.
that did the trick

Re: Shipping Table Rate Showing Wrong Value
Posted: Sun Mar 13, 2022 5:44 pm
by ecartz
heatherbell wrote: ↑Sun Mar 13, 2022 5:22 pm
Should there not be a Message or checkout prevention if order weight > Maximum Package Weight?
The logic, which is not new, is that if the order weight is greater than the maximum package weight, it breaks the order into multiple packages and charges shipping for each package. The presumption is that store owners won't list items that are too big for them to ship. So if an order is too big, it just needs to be broken into multiple packages.
It wouldn't be that hard to create a hook that would check each product when it was entered and throw a warning or error if the product was larger than the maximum weight. Which in this case (assuming that the product was entered manually on the catalog page rather than via bulk upload) would have meant that the conflict would have been noted. I.e. that it would have been known that 76 was greater than the maximum package weight of 50, so presumably the maximum package weight would have been increased.
It would be more difficult but not impossible to check that a shipping table has a maximum weight equal to the maximum package weight. I think that that could be done with a use_function on the table entry that would add a warning message stack.
If it's not clear, what I believe happened here is that 76 was larger than 50, so the order was broken into two packages. Then table shipping was applied to each package. Since the maximum package weight of 50 was smaller than the minimum charge weight of 100, that meant that it ended up charging twice the fee for the minimum weight. I forget (and don't feel like looking up at the moment) whether the packages would have been 50 and 26 or both 38. But the fees are the same either way with that table.
Re: Shipping Table Rate Showing Wrong Value
Posted: Mon Mar 14, 2022 6:59 am
by heatherbell
ecartz wrote: ↑Sun Mar 13, 2022 5:44 pm
The logic, which is not new, is that if the order weight is greater than the maximum package weight, it breaks the order into multiple packages and charges shipping for each package.
Many thanks for the explanation. I have edited the User Guide accordingly.