How to edit a shipping class formula?

  • Resolved davefineleather

    (@davefineleather)


    2 years, 6 months ago

    I noticed today that our shipping rates are not up to date – i.e. the flat rate shipping class cost formulas are no longer accurate, as entered by a contractor that no longer works for us.

    As an example, in shipping a product of a specific class from California (where we’re located) to New York:

    Our site quotes: $45.55
    The actual USPS cost is: $64.78

    The formula our site uses for this particular shipping class is:

    21+[fee percent=”5″ max_fee=”31″]

    I tried editing the formula order to update it appropriately. I can get accurate quotes from California to New York, but then the rates are inaccurate for other, closer parts of the country.

    Which portion of the formula should I be editing in order for our site to make the correct calculation and quote the correct rates?

Viewing 5 replies - 1 through 5 (of 5 total)

  • Hi @davefineleather

    Thanks for reaching out!

    I understand that you are having inaccurate shipping costs on your site based on the formula above.

    The shipping costs will only be determined based on the formula you input on your shipping methods. You could have several formulas depending on the shipping locations but this is tedious as you need to determine it one by one.

    What I would suggest is a plugin like USPS Shipping Method to get shipping rates from the USPS API which handles both domestic and international parcels. It shows your customers accurate shipping rates automatically with their integration for USPS, the largest delivery network in United States.

    If you want to try our products, please note we have a 30-day refund policy.

    If the product doesn’t work the way you need it or you think another product would work better, we are more than happy to offer a full refund. [You can read more about our refund policy on our website here](https://woocommerce.com/refund-policy/).

    How is the Flat Rate set up? Changing the formula for a particular shipping class won’t affect any others.

    Thread Starter davefineleather

    (@davefineleather)

    Thanks for your reply, @seank123. We have different formulas for each of our different shipping classes for the US.

    I understand that changing the formula for a particular shipping class won’t affect any others – my question is about how to correctly edit this formula:

    21+[fee percent=”5″ max_fee=”31″]

    So that it will properly calculate our shipping costs, which are:

    Our site quotes: $45.55
    The actual USPS cost is: $64.78

    In other words, we are undercharging for this particular shipping class, and I’m unsure how to edit the formula. Thanks for your help!

    It would depend as the cost calculating is using the order total to generate the cost – in the example you used then the calculation is:

    Order total: 491
    Fee: 5% of Order Total = 24.55
    Shipping: 24.55 + 21 = 45.55

    To get 64.78 you would need either:

    21+[fee percent=”8.9″]
    40.23+[fee percent=”5″]

    But how are you working out the actual shipping cost? Is it based on the order total? Weight? Fixed at 64.78 etc? These calculations will only work for one product – anything else will make the shipping total different.

    Thread Starter davefineleather

    (@davefineleather)

    Thanks, this was super helpful and really helped me to wrap my head around this!

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to edit a shipping class formula?’ is closed to new replies.