Welcome to WebmasterWorld Guest from 54.81.166.196

Forum Moderators: coopster & jatar k & phranque

Message Too Old, No Replies

# Shipping Calculations

## What logic do you use?

#### rocknbil

10:39 pm on Mar 25, 2006 (gmt 0)

#### Senior Member

joined:Nov 28, 2004
posts:7999

Currently I use UPS and USPS online tools via silent post to calculate shipping. Send them a width, height, depth, shipping method, they return a price.

The problem comes in when someone orders multiple items. Initially just to get the thing rolling what I did was find the longest sides of the items and add the heights. This overshot a little, but worked.

I'm sure you all see what *I* saw the potential for, but never expected the outstanding success of the site in question. We're getting some LARGE orders, multiple items, and it's blowing my "calculator" out of the water. When someone orders 70 12" X 2" X 1" items, you now have a box 12" X 2" X 70" high which throws ANY calculator into oversize.

So what logic do you follow? Calc the total volume, grab the largest length and width and make the height whatever's required to equal the volume?

I will cross-post this in Ecommerce because it may be more relevant there, but am interested in a programmer's point of view. 'Cause that's what I have to figure out, how to program it. :-)

#### DrDoc

12:39 am on Mar 26, 2006 (gmt 0)

#### Senior Member

joined:Mar 15, 2002
posts:6807

Well, I typically figure out the volume for each ... then add those together (so now I have an accurate volume at least). Then I imagine a box with that volume where the w/h/d ratio is as close as possible to the average w/h/d ratio for the items involved. I then multiply each dimension by 1.1 or 1.2

So far, very accurate.

#### DrDoc

12:41 am on Mar 26, 2006 (gmt 0)

#### Senior Member

joined:Mar 15, 2002
posts:6807

Another option ... If you know the shipper, and which box sizes are available, you can actually calculate the optimal box usage as well, and get dead on the spot shipping rates ;)

"Hmm, to ship these five items the best box to use is the X×Y×Z. I will need two of them."

#### rocknbil

1:18 am on Mar 26, 2006 (gmt 0)

#### Senior Member

joined:Nov 28, 2004
posts:7999

DrDoc, thank you very much for your help on a Saturday. So I'm on the right track with the volume. I've been searching all over this afternoon and can't believe this question hasn't come up anywhere. Thanks again!

#### DrDoc

3:45 am on Mar 26, 2006 (gmt 0)

#### Senior Member

joined:Mar 15, 2002
posts:6807

That's what I have found gives the best results, at least.

The latter option is definitely the better one, though ... Although the calculations are no less fun ;)