Magento 2 Shipping Table Rates

Magento 2 Shipping Table Rates helps you offer Unlimited Numbers of Shipping Options by defining different Shipping Rates based on Shipping Destination, Product Weight, Price, and Quantity.

 

Table of Content

  1. Extension Installation Guide
  2. Add Method
  3. Configuration
  4. Create Shipping Types Options
  5. Shipping Table Rates in Frontend
  6. Shipping Table Rates in Backend

 

  1. Extension Installation
  • Extract the zip folder and upload our extension to the root of your Magento 2 directory via FTP.
  • Login to your SSH and run below commands step by step:
    • php bin/magento setup:upgrade
    • For Magento version 2.0.x to 2.1.x - php bin/magento setup:static-content:deploy
    • For Magento version 2.2.x & above - php bin/magento setup:static-content:deploy –f
    • php bin/magento cache:flush
  • That’s it.

 

  1. Add Method
    To import shipping table rates, go to Sales > Shipping Table Rates and add method from the “Add Method” button.


  

  • Add New Rate
    Configure the general settings to add a new method.
    • Name: Add a name for the shipping table rate method.
    • Status: Activate shipping method from here.
    • Priority: Set priority for this method.
    • For Products with Different Shipping Types:
      • Sum Up Rates: Summarize rates for different Shipping Types in the cart.
      • Select Maximal Rate: Use the only rate with maximal value for shipping type.
      • Select Minimal Rate: Use the only rate with minimal value for specific Shipping Type.
    • Stores: select the store view for the shipping table rate method.
    • Customer Groups: Select customer groups to allow the use of the shipping table rate.


 

  • Import Shipping Table Rates
    Import shipping table rates using CSV from the Import tab in Shipping Table Rate Methods.
    • Delete Existing Rates: All the existing rates will be removed when you try to save changes or import CSV with rates.
    • CSV File: Import CSV file with rates in proper formatting. You can download and use the sample CSV file from here. https://meetanshi.com/media/rates.csv

Note: After importing the rates through CSV, you have to click the “Save” button to see the rates imported under “Methods and Rates” tab.


  

  • Methods and Rates
    To view the imported shipping table rates, navigate to “Methods and Rates tab” as shown below. Here each grid column means as follow:
    • Country: Shows the country for which the rate will be applied.
    • State – Shows the state condition for the rate.
    • Zip From - To - a specific postcode range. When it's filled like 'From: 10000 To: 10999' the rate will apply for all 1000 postcodes inside the 10000 - 10999 range. UK postcode format is supported.
    • Price From - To - Prices for products with the same shipping type will be summarized.
    • Weight From - To - Same as condition above but works with weight attribute of the product.
    • Qty From - To - same as above but works for the quantity in the shopping cart.
    • Shipping Type – All means the rate will be applied to all the products.
    • Rate – Applicable rate amount for the whole order.
    • PPP - Percentage per Product Price. Shipping will be calculated as a percentage of the product price.
    • FRPP - Fixed Rate Per Product Price. Shipping will be calculated multiplying product quantity in the cart by the value in FRPP field.
    • FRPUW - Fixed Rate Per Unit of Weight. The rate will be calculated based on the Weight of the product. For example, if FRPUW is set to 2.25 and Weight of the product in the cart is 4.25 then the calculation will be like this: 2.25*4.25=$9.56
    • Estimated Delivery (days) – Specifies the estimated delivery days for the shipping method. The days here will be inserted in the {day} variable which you can use in the Name field.


  

  1. Configuration
    For configuring the extension, log in to Magento 2, move to Stores > Configuration > Sales > Shipping Methods where you can find various settings to enable the extension.
  • Enabled for Checkout: Set YES to enable Shipping Table Rates.
  • Title: Enter the title of the shipping method.
  • Ship to Applicable Countries: Select countries to allow the use of this shipping method.
  • Displayed Error Message: Enter error message for shipping unavailability.
  • Allow Free Shipping Promotions: Select YES to allow free shipping rule from shopping cart price will be applied.
  • Ignore Price and Quantity of Virtual Products: Select YES to ignore price and quantity of virtual products while calculating shipping.
  • Numeric Zip: Set YES to allow numeric zip codes in CSV.
  • Use price AFTER discount: Set YES to use price after deducting discount.
  • Use price INCLUDING tax: Set YES to use price inclusive of tax.
  • Use only one shipping type for shipping method: When setting to YES, if the shopping cart is having products with different Shipping Types, the rate with 'Shipping Types = All' will be applied instead.
  • Sort Order: Set sort order of the shipping method to show in frontend.


 

  1. Create Shipping Types Options
  • Create Shipping Type Attribute Options
    To create the options for ‘shipping type’ attribute please go to Catalog > Products > Attributes Action > Edit Product Attribute "Shipping Type“ > Manage Label/Options.


  

  • Shipping Types Options
    Navigate to Properties tab in the Attribute Information menu. As shown below, click the “Add Option” button to add shipping type options.


  • Assign Shipping Type to Product
    Once the shipping options are created, assign the value of the attribute to the product to calculate the shipping rate based on.


  

 

  1. Shipping Table Rates in Frontend
    Once the extension settings are done, add a product to cart to see Shipping Table Rates enabled in the frontend.
     
  • Shipping Table Rates on Cart Page
    When a customer adds products to cart and proceeds to make payment, the shipping table rates is displayed on Cart Page as shown below.


  

  • Shipping Table Rates on Checkout Page
    Check the Shipping Table Rates details in order summary as shown below.


  • Shipping Table Rates in My Account Page
    As shown below, the shipping table rates method name is displayed in My Accounts page from the “My Orders” menu.


  

  1. Shipping Table Rates in Backend
    The Shipping Table Rates method name and value can be viewed from the Order View backend as shown here.