Weight Based Calculations Question

  • Resolved erin814

    (@erin814)


    4 years, 10 months ago

    I have a price structure like this:

    $15 + $15 per 1.33 lbs over 1.33 lbs => [$15 - $45]

    When I add a single item to the cart that is 1.33 lbs, the shipping cost is $15. (Everything okay here.)

    If I then add another product that is 0.434 lbs, the shipping cost changes to $30. But if I did the formula correctly, I thought it would still be $15.

    I would like the price to only go up $15 if another 1.33 lb item is added to the cart.

    Could anyone give me guidance on what I’m doing wrong here?

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Dan

    (@dangoodman)

    Hello Erin,

    It rounds up to the next step, e.g. 0.5 lbs is rounded up to 1.33, 1.35 -> 2.66, and so on. While it seems you need it to round down to the previous step, 0.5 -> 0, 1.35 -> 1.33, etc.

    The closest thing to that I can see is to set the ‘over’ value to something a bit less than 2.66, e.g. ‘over 2.659999’. That way it would calculate the price as follows:
    — 0 – 2.659999 lbs => $15
    — 2.66 – 3.989999 lbs => $30
    — etc.

    Thread Starter erin814

    (@erin814)

    Hi Dan,

    Interesting, so it doesn’t add up the actual weight, it rounds up to the next step? The way it’s written in the Weight Rate field it looks like:

    Charge $15 per each 1.33lbs over 1.33lbs.

    To me, that would mean that between 1.33lbs and 2.66lbs, everything would be charged $15. So two items, 1.33lbs and .5lbs, equaling 1.83lbs, would get charged $15.

    What you’re saying is the .5lbs gets rounded to 1.33lbs, and therefore becomes 1.33lbs + 1.33lbs, therefore getting charged $30.

    Am I understanding you correctly? I can make the adjustment as you’ve recommended, I just want to make sure I understand how this works.

    Thanks for your response.

    Erin

    Plugin Author Dan

    (@dangoodman)

    Charge $15 per each 1.33lbs over 1.33lbs.

    To me, that would mean that between 1.33lbs and 2.66lbs, everything would be charged $15. So two items, 1.33lbs and .5lbs, equaling 1.83lbs, would get charged $15.

    Right, that’s how it works. And you also have Base Cost $15. So, in total, Weight Rate and Base Cost, turn in to $30 for 1.83lbs order.

    Thread Starter erin814

    (@erin814)

    Thanks Dan. I think I get it now. I changed the formula to

    $15 + $15 per 1.33 lbs over 1.764 lbs => [$15 - $30]

    which is the 1.33lb product + the lighter .434lb product so those two together are $15 shipping and then anything over that would be $30.

    Looks good now, thanks for your help!

    Plugin Author Dan

    (@dangoodman)

    Glad to help! Thank you for the update.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Weight Based Calculations Question’ is closed to new replies.