Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Table Rate Weight-Based Shipping Calculations


TerryK

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:

 

Add order total to checkout_shipment

Add order total to checkout_payment

Add radio buttons at checkout_shipping (for backorder options, etc.)

Duplicate Table Rate Shipping Module

Better Product Review Flow

 

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

Link to comment
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:

 

Add order total to checkout_shipment

Add order total to checkout_payment

Add radio buttons at checkout_shipping (for backorder options, etc.)

Duplicate Table Rate Shipping Module

Better Product Review Flow

 

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

Link to comment
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."

Link to comment
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."

Link to comment
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:

 

Add order total to checkout_shipment

Add order total to checkout_payment

Add radio buttons at checkout_shipping (for backorder options, etc.)

Duplicate Table Rate Shipping Module

Better Product Review Flow

 

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

Link to comment
Share on other sites

Join the conversation

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

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

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...