Shipping method table rates with weight vs destination not working in Magento

Shipping method table rates with weight vs destination not working in Magento

July 31, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Shipping method table rates with weight vs destination not working in Magento

Solving the Magento Table Rate Shipping Method Issue

Hello developers! Today we’re going to dive into an issue that many of you might face while working with Magento: table rate shipping methods not working as expected in certain stores.

The Problem: Weight vs Destination Not Working for Certain Stores

You have a Magento installation with multiple websites and stores. You’ve configured the table rate shipping method with weight vs destination for all three stores, but it’s only working properly for two of them. In your third store, no matter what the weight is, the shipping price always shows as 0.

Let’s take a closer look at your configuration:

Your Current Configuration

You have shared an Excel sheet representing your table rates for the problematic third store:

CountryRegion/StateZip/Postal CodeWeight (and above)Shipping Price
***06.5
***10
USA**010
USA**125

The Issue

The problem lies in the way Magento interprets the Weight (and above) column. By default, it expects a value representing an inclusive weight range (e.g., “1”), not an exclusive one (e.g., “>1”).

The Solution: Update Your Table Rate Configuration

To resolve this issue, you need to adjust your table rate configuration to reflect inclusive weight ranges.

Step 1: Understand Inclusive Weight Ranges

An inclusive weight range means that the shipping price applies to all packages within or equal to the specified weight. For example:

  • If you have a row with Weight (and above): 0, it should mean “for packages weighing 0 pounds.”
  • If you have a row with Weight (and above): 1, it should mean “for packages weighing 1 pound and up.”

Step 2: Update Your Excel Sheet

Amend your Excel sheet to reflect inclusive weight ranges:

CountryRegion/StateZip/Postal CodeWeight (and above)Shipping Price
***0 and up6.5
***1 and up0
USA**0 and up10
USA**1 and up25

Step 3: Re-import the Table Rates

After updating your Excel sheet, export it as a CSV file. Then, go to your Magento admin panel and navigate to Stores > Configuration > Sales > Shipping Rates.

Select the appropriate shipping rate that corresponds to your third store’s table rates configuration. Click on “Import” and upload your updated CSV file.

Why This Solution Works

By configuring inclusive weight ranges in your table rates, you ensure that Magento can accurately calculate shipping prices for packages of different weights within each specified range.

This approach simplifies the configuration process and reduces potential confusion, especially when dealing with multiple stores or complex shipping scenarios.

Conclusion: Ensuring Proper Configuration for Magento Table Rates

Remember, accurate configuration is key to a smooth shopping experience. Always double-check your table rate settings to ensure they reflect inclusive weight ranges and cover all possible shipping scenarios across your Magento websites.

If you’re looking for more insights into Magento development best practices, I highly recommend checking out the Magento Development Tutorials on our website. We cover a wide range of topics to help you master this powerful e-commerce platform.

That’s all for today! I hope this guide helps you resolve your Magento shipping method issue and keeps your customers happy with accurate shipping quotes. Happy coding!

Disclaimer: This post is not affiliated with or endorsed by Adobe, owner of the Magento trademark. The term ‘Magento’ used here refers to the open-source platform that was previously branded as such.

Database Configuration Pricing Errors

Our network