Re^2: determine numbers of boxes needed per weight

Hi. Here is some more information.

For the sweet spot, I am not sure. But I would like to keep things between 50 and 70 pounds to make best use of the boxes.

I don't want to go less than 50 lbs per box.

The problem with different sizes boxes is I'd have to send a bot to the USPS site for each box. If they are all the same, I only need to parse their site once.

This is for small products (candles, incense, soaps, etc) so no one item will take up a box, if that's what you mean.

95% is definitely good enough.

I really appreciate the help!

Comment on Re^2: determine numbers of boxes needed per weight

Replies are listed 'Best First'.
Re^3: determine numbers of boxes needed per weight by BrowserUk (Patriarch) on Nov 24, 2005 at 06:58 UTC
Using the distribute function above, the minimum box weight would be 37.5 lbs, except where the total weight is less than that figure; and you will only ever need to look up one price as they will always be the same. If you need to limit your weight to greater than 50 lbs, then you will inevitably have to do 2 lookups more often than not. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal? "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice.	[reply]
Re^3: determine numbers of boxes needed per weight by GrandFather (Saint) on Nov 24, 2005 at 06:40 UTC
But you must go to a 10 lbs box for small orders surely? Or is there a minimum charge that equates to say, a 20 lbs box? For your 80 lbs shipment, why not two 40 lbs boxes? DWIM is Perl's answer to Gödel	[reply]
Re^4: determine numbers of boxes needed per weight by Anonymous Monk on Nov 24, 2005 at 07:07 UTC
The boxes will be put together the best we can. If one is a few pounds heavier than the other, we wouldn't charge them again for shipping. If it's fairly accurate, that's more than suitable. As for smaller boxes, if the order is small enough we'll use small boxes. If it's over 70 pounds, we'll always use the medium boxes. We just want around 50lbs or higher if it's way over 70 lbs or half of the weight in each box for say 80lbs. Thanks again for all your help!	[reply]