This is a tough question and even tougher to explain.

USPS has a 70lb shipping limit per box and people can purchase more than that weight from my shopping cart. I can't price check weights that surpass 70lbs.

I need a way to determine the BEST weight to box ratio if they have too much weight. Like if they had 80lbs, a 50lb box and a 30lb box would work but I'd have to send two search queries to USPS which would be inefficient. If say they had 100lbs, I could price check 50lbs on USPS and double the price myself.

I need a way to automate this to determine if 1) the weight is too much 2) how many boxes are needed 3) finding the price per box (hoping to use just one search query unless it's really unreasonable).

This is making my brain hurt. Can anyone think of a way to do this?

In reply to determine numbers of boxes needed per weight by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.