TerryK Posted May 15, 2004 Posted May 15, 2004 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 Quote 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. *
TerryK Posted May 17, 2004 Author Posted May 17, 2004 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 Quote 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. *
berkedam Posted May 17, 2004 Posted May 17, 2004 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. Quote "If you're working on something new, then you are necessarily an amateur."
berkedam Posted May 17, 2004 Posted May 17, 2004 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 Quote "If you're working on something new, then you are necessarily an amateur."
TerryK Posted May 17, 2004 Author Posted May 17, 2004 Okay, so my math sucks at 3am... :) Terry Quote 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. *
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.