The shipping Table Rates method refers to a table of data to calculate shipping rates based on a combination of conditions explained below.
To configure the Table Rates, you need to go to Admin -> Stores -> Settings -> Configuration -> Sales -> Delivery Methods -> Table Rates
1. Table Rates
Enable [Yes / No] Enable or Disable the Table Rates shipping method from the Checkout Page.
Title Change the title of the shipping method from Flat Rate to your own custom title.
Method Name You can set a name to appear next to the calculated rate in the shopping cart.
Condition Set one of the following methods of calculation:
- Weight vs. Destination
- Price vs. Destination
- # of Items vs. Destination
Calculate Handling Fee You can set a handling fee, it will be an additional charge added to the shipping cost. If you want to set it, choose one of the options below:
Handling Fee Set the amount to be charged based on the method that you have chosen Fixed or Percent.
Displayed Error Message You can set an Error message to display if Table Rates is not available.
Ship to Applicable Countries [All Allowed Countries / Specific Countries] If you select Specific Countries, you can select below on Ship To Specific Countries only the countries that you want the shipping to be available.
Ship to specific Countries Works only if you select Specific countries from Ship to Applicable Countries, and you can select the countries where shipping is available.
Show Method if Not Applicable [Yes / No] Enable or Disable this if you want to show or not the Method if not applicable.
Sort Order Set the order you want the shipping method to appear( For example "1", so it will appear as the first option).
Save Config and flush all caches available and refresh the website after the changes are done.
2. Prepare the data for the table rate
Go to Admin -> Stores -> Settings -> Configuration -> Sales -> Delivery Methods -> Scope: Select the Website that this applies to.
Note: Use the system value checkbox first if necessary to modify the following settings.
a. Set the Condition as needed.
b. Export Click Export CSV. -> Save the file tablerates.csv into your computer.
c. Open the file in a spreadsheet application.
d. Complete the table with the proper parameters for the condition of the shipping calculation.
To represent all possible values in every category, use an asterisk (*) as a wildcard.
A valid three-character code for each row shall be present in the country column.
- Sort the data by Region/State so the specific 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.
e. After making the changes save the file tablerates.csv
3. Import the tablerates.csv file
a. To import the file tablerates.csv click Browse -> Select the saved file -> Open
b. Save Config.
4. Check the rates Check the payment process with several different addresses, to ensure
that shipping and handling rates are properly calculated and see if the table rate data is correct.