{"id":1839,"date":"2021-07-19T12:35:45","date_gmt":"2021-07-19T12:35:45","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/configure-magento-2-shipping-table-rates\/"},"modified":"2025-05-22T10:21:23","modified_gmt":"2025-05-22T04:51:23","slug":"configure-magento-2-shipping-table-rates","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/configure-magento-2-shipping-table-rates\/","title":{"rendered":"How to Configure Table Rate Shipping Method in Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Shipping in E-commerce influences the purchase decision of a consumer. Your shipping strategy must be in place if you do not want to lose a conversion because of miscalculations in shipping rates.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A convenient shipping experience is essential amidst the rising customer expectations and competition in online stores.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">According to research by&nbsp;<a href=\"https:\/\/baymard.com\/lists\/cart-abandonment-rate\" target=\"_blank\" rel=\"noreferrer noopener\">Baymard<\/a>, 49% of US shoppers abandoned their cart due to too high extra costs such as shipping.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, if your shipping rates calculation goes wrong, you may lose sales. However, if you are a Magento 2 store owner, you need not worry as the default Magento offers&nbsp;table rates shipping method.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may&nbsp;<em><strong>configure table rate shipping method in Magento 2<\/strong><\/em>&nbsp;and display the shipping rates in the frontend.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The table rate shipping method in Magento 2 refers to a&nbsp;table of data to calculate shipping rates based on a combination of conditions like:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Weight v. Destination<\/li>\n\n\n\n<li>Price v. Destination<\/li>\n\n\n\n<li>Number of Items v. Destination<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Using this method, you can optimize the shipping system such that it costs the minimum to deliver an item from the warehouse to its destination. The store owner can transparently pass on these savings to the customers with the help of Magento 2 table rates.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Configure Shipping Table Rates in Magento 2:<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Complete the default settings<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/Table-Rates-Shipping-in-Magento-2-1024x814.png\" alt=\"Table Rates Shipping in Magento 2\" class=\"wp-image-15619\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">1. <strong>Login<\/strong>&nbsp;to admin panel<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Navigate to&nbsp;<strong>Stores &gt; Configuration<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. Select&nbsp;<strong>Shipping Methods<\/strong>&nbsp;under&nbsp;<strong>Sales<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Expand the \u201c<strong>Table Rates<\/strong>\u201d section<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enabled<\/strong>&nbsp;\u2013 Enable or disable the table rate shipping method from the checkout page<\/li>\n\n\n\n<li><strong>Title<\/strong>&nbsp;\u2013 Set custom title for the shipping method<\/li>\n\n\n\n<li><strong>Method Name<\/strong>&nbsp;\u2013 Set custom method name to be displayed next to the calculated rate in the cart<\/li>\n\n\n\n<li>Set&nbsp;<strong>Condition<\/strong>&nbsp;to one of the following calculation methods:\n<ul class=\"wp-block-list\">\n<li>Weight vs. Destination<\/li>\n\n\n\n<li>Price vs. Destination<\/li>\n\n\n\n<li># of Items vs. Destination<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Include Virtual Products in Price Calculation<\/strong>&nbsp;\u2013 Set this option to \u201cYes\u201d if you want to &nbsp;be able to include the virtual product(s) in the calculation for orders that include virtual products.<\/li>\n\n\n\n<li>If charging a handling fee, set&nbsp;<strong>Calculate Handling Fee<\/strong>&nbsp;to one of the following\n<ul class=\"wp-block-list\">\n<li>Fixed<\/li>\n\n\n\n<li>Percent<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Enter the&nbsp;<strong>Handling Fee<\/strong>&nbsp;rate according to the method used to calculate the fee<\/li>\n\n\n\n<li><strong>Displayed Error Message<\/strong>&nbsp;\u2013 Enter the message that appears when a method is not available<\/li>\n\n\n\n<li><strong>Ship to Applicable Countries<\/strong>&nbsp;\u2013 Select the countries allowed to use this method<\/li>\n\n\n\n<li><strong>Show Method if not Applicable<\/strong>&nbsp;\u2013 Enable or Disable this option if you want to show or not the method when not applicable.<\/li>\n\n\n\n<li><strong>Sort Order<\/strong>&nbsp;\u2013 Enter the sort order<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">5. <strong>Save<\/strong>&nbsp;the configuration<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">6. <strong>Flush cache<\/strong>&nbsp;and&nbsp;<strong>refresh<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Prepare the Table Rate Data<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/Prepare-the-data-for-the-table-rate-1024x582.png\" alt=\"Prepare the data for the table rate\" class=\"wp-image-15621\"\/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to&nbsp;<strong>Stores &gt; Configuration<\/strong><\/li>\n\n\n\n<li>Select&nbsp;<strong>Shipping Methods<\/strong>&nbsp;under&nbsp;<strong>Sales<\/strong><\/li>\n\n\n\n<li>Set&nbsp;<strong>Store View<\/strong>&nbsp;to&nbsp;<strong>Main Websit<\/strong>e, or to any other website where the configuration applies on the top-left of the page. Click \u201cok\u201d when prompted to confirm.<\/li>\n\n\n\n<li>Set the required \u201c<strong>Condition\u201d<\/strong>.<\/li>\n\n\n\n<li>Click&nbsp;<strong>Export CSV<\/strong>&nbsp;and save the tablerates.csv file on your computer.<\/li>\n\n\n\n<li>Open the file and complete the table with appropriate parameters for the shipping calculation condition<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" width=\"804\" height=\"233\" srcset=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates.png 804w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-300x87.png 300w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-768x223.png 768w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-626x181.png 626w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-720x209.png 720w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-525x152.png 525w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-345x100.png 345w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-586x170.png 586w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-455x132.png 455w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-340x99.png 340w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-293x85.png 293w, https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates-267x77.png 267w\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/tablerates.png\" alt=\"Default TableRates file\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use of asterisk (*) as a wildcard to represent all possible values in any category<\/li>\n\n\n\n<li>Make sure that the country column contains a valid three-character code for every row.<\/li>\n\n\n\n<li>Sort the data by Region\/State so the particular locations are at the top of the list, and the wildcard locations at the bottom. This will process the rules with the absolute values first, and the wildcard values later.<\/li>\n\n\n\n<li>Save the tablerates.csv file<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Import the Table Rate Data<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/Import-table-rates.png\" alt=\"Import table rates data\" class=\"wp-image-15623\"\/><\/figure>\n<\/div>\n\n\n<ol class=\"wp-block-list\">\n<li>Navigate to&nbsp;<strong>Stores &gt; Configuration<\/strong><\/li>\n\n\n\n<li>Select&nbsp;<strong>Shipping Methods<\/strong>&nbsp;under&nbsp;<strong>Sales<\/strong><\/li>\n\n\n\n<li>Set&nbsp;<strong>Store View<\/strong>&nbsp;to&nbsp;<strong>Main Websit<\/strong>e, or to any other website where the configuration applies on the top-left of the page. Click \u201cok\u201d when prompted to confirm<\/li>\n\n\n\n<li>As shown in the above image, click&nbsp;<strong>Choose File<\/strong>&nbsp;and select your completed&nbsp;table-rates.csv file for import in the&nbsp;<strong>Import<\/strong>&nbsp;field.<\/li>\n\n\n\n<li><strong>Save<\/strong>&nbsp;the configuration<\/li>\n\n\n\n<li>Flush and refresh the cache.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it. Now. if the customer places an order from the frontend, they can see the shipping table rates applied as set using the CSV.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, with default Magento 2 table rates, you cannot define shipping table rates based on multiple factors and it is limited to as shown in the above default CSV.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, with complex modern Magento 2 stores and various shipping strategies in place, you may need an advanced&nbsp;Magento table rates&nbsp;system.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Meetanshi offers the&nbsp;<a href=\"https:\/\/meetanshi.com\/magento-2-shipping-table-rates.html\" target=\"_blank\" rel=\"noreferrer noopener\">Magento 2 Shipping Table Rates<\/a>&nbsp;extension that allows calculating accurate shipping rates based on shipping destination, product weight, price, Percentage per Product Price, Fixed Rate Per Product Price, Fixed Rate Per Unit of Weight, and quantity prior to defining shipping rates through the CSV file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The admin can also display the estimated delivery days by adding it in CSV.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/07\/5_sample-csv-with-rates-and-postal-codes-of-uk-1024x152.png\" alt=\"magento 2 shipping table rates csv download- Meetanshi\" class=\"wp-image-15626\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">The Magento Shipping Table Rates extension offers key features like:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Unlimited number of custom shipping methods<\/li>\n\n\n\n<li>Create table rates in bulk using CSV<\/li>\n\n\n\n<li>Show the calculated shipping table rate on the frontend in cart page, checkout page, \u201cMy Accounts\u201d section, and order view backend<\/li>\n\n\n\n<li>Assign min\/max rates to apply shipping charge to the whole order having multiple products<\/li>\n\n\n\n<li>Restrict shipping methods based on store views and customer groups<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">and many more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You may check the entire range of features&nbsp;<a href=\"https:\/\/www.youtube.com\/watch?v=wCpDM4z9jQE\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Any doubts about the&nbsp;Magento 2 multiple table rates?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Also, do share my guide to&nbsp;table rate shipping method in Magento 2 via social media with the Magento community.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Shipping in E-commerce influences the purchase decision of a consumer. Your shipping strategy must be in place if you do not want to lose a&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1839","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1839"}],"version-history":[{"count":2,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1839\/revisions"}],"predecessor-version":[{"id":14268,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1839\/revisions\/14268"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1839"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1839"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}