osCommerce 4 osCommerce 4 App Shop Support Services App Shop Us
• Checkout
• Get in touch

osCommerce

The e-commerce.

# Table Rate Weight-Based Shipping Calculations

## Recommended Posts

I've set up my shipping prices using the table rate based on weight in grams, as follows:

1:0.00,100:2.00,200:3.00,250:4.50,500:6.00,1000:9.00,1500:10.00,

2000:11.00,3000:12.00,3500:13.00,4000:14.00,4500:15.00,5000:16.00

I've set my tare weight and percentage increase to 0.

When I put through a test order weighing 5800 grams, it's not returning the correct shipping amount. If I understand the formula correctly, it should be charging \$16 for the first 5000 grams, then \$9 for the additional 800 grams, for a total of \$25. But it's not -- it's only charging \$24 for some reason.

Ditto on another test order weighing in at 5300 grams. It should be charging \$16 for the first 5000 grams, then \$6 for the additional 300 grams, for a total of \$22. But it's charging \$24 for this one, too!

Yet another test on total weight of 9510 grams accurately calculates the charge at \$32.

I'm stumped -- can anyone help me to understand why the calculations aren't working?

TIA,

Terry

Terry Kluytmans

Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like:

* If at first you don't succeed, find out if there's a prize for the loser. *

##### Share on other sites

I think I figured this out...

It looks like the cart doesn't calculate the first package at MAXIMUM weight, with the balance calculated at the lower weight rate. Instead, it appears that the total package weight is divided by the number of boxes (based on total package weight divided by your maximum package weight), and the costs reflected based on that calculation.

So, in the case of my 5800g package, it divided 5800 by 2, for individual package weights of 2700g. The applicable shipping cost for that weight is \$12. Times 2 = \$24.

HTH someone else's sanity...

Terry

Terry Kluytmans

Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like:

* If at first you don't succeed, find out if there's a prize for the loser. *

##### Share on other sites

I've set up my shipping prices using the table rate based on weight in grams, as follows:

1:0.00,100:2.00,200:3.00,250:4.50,500:6.00,1000:9.00,1500:10.00,

2000:11.00,3000:12.00,3500:13.00,4000:14.00,4500:15.00,5000:16.00

I've set my tare weight and percentage increase to 0.

When I put through a test order weighing 5800 grams, it's not returning the correct shipping amount. If I understand the formula correctly, it should be charging \$16 for the first 5000 grams, then \$9 for the additional 800 grams, for a total of \$25. But it's not -- it's only charging \$24 for some reason.

Ditto on another test order weighing in at 5300 grams. It should be charging \$16 for the first 5000 grams, then \$6 for the additional 300 grams, for a total of \$22. But it's charging \$24 for this one, too!

Yet another test on total weight of 9510 grams accurately calculates the charge at \$32.

I'm stumped -- can anyone help me to understand why the calculations aren't working?

TIA,

Terry

Hi Terry, the system works is as follows:

yr 5800 :2 = 2900

at your rate (3000:12) it means 2x12=24.00 :D which is correct.

5300:2 = 2650 at (3000:12) that will be 24.00 also

that means it's calculating: 2 parcels at 50% weight each and the price of 1 parcel is multiplied by 2

I can hear you sighng :D

Greeetings

John

If you use other modules, sometimes you can see that the weight is 50% and sometimes it's also mentioned that 2 parcel are going to be shipped.

"If you're working on something new, then you are necessarily an amateur."

##### Share on other sites

I think I figured this out...

It looks like the cart doesn't calculate the first package at MAXIMUM weight, with the balance calculated at the lower weight rate. Instead, it appears that the total package weight is divided by the number of boxes (based on total package weight divided by your maximum package weight), and the costs reflected based on that calculation.

So, in the case of my 5800g package, it divided 5800 by 2, for individual package weights of 2700g. The applicable shipping cost for that weight is \$12. Times 2 = \$24.

HTH someone else's sanity...

Terry

I'm getting insane now, how much is 2 x 2700 in Canada :D

"If you're working on something new, then you are necessarily an amateur."

##### Share on other sites

Okay, so my math sucks at 3am... :)

Terry

Terry Kluytmans

Contribs Installed: Purchase Without Account (PWA); Big Images, Product Availability, Description in Product Listing, Graphical Infobox, Header Tags Controller, Login Box, Option Type Feature, plus many layout changes & other mods of my own, like:

* If at first you don't succeed, find out if there's a prize for the loser. *

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.