Table Rate Shipping

The table rate shipping method lets you calculate shipping rates for a combination of conditions using editable data. The shipping rate can be based on the following calculations:

  • Weight vs. Destination
  • Price vs. Destination
  • Number of Items vs. Destination

🚧

Only one set of table rate data can be active at any time. The data that is used to calculate the rate is prepared in a spreadsheet and imported into your store.
If you need more flexible rates, look at the Matrix Rates Shipping method.

Complete the Default Settings

Add Table Rates to your shipping methods

In your Control Panel, go to Set-up > Shipping. If Table Rates is not shown, click on Add Shipping Method. Choose the Table Rates box, and click the Add Shipping Methods bar that appears at the bottom of your page.
Next, click on Set-Up next to the Table Rates section to view your configuration settings.

Modify the following settings:

Setting

Value

Enabled

Yes

Title

Enter a name that will be used to refer to this shipping option during checkout (example: Recommended Shipping)

Method Name

Enter a name that best describes how these are being shipped such as "Standard Shipping".

Condition

Choose from one of the three options:

  • Weight vs. Destination
  • Price vs. Destination¹
  • Number of Items vs. Destination

Calculate Handling Fee (optional)

Fixed (amount per order ) or Percentage (of the order total price)

Handling Fee

Numeric value to calculate amount or percentage (e.g. 10 for $10 or 10%)

Displayed Error Message

You can enter a message, which appears when a selected method is unavailable.

Ship to Applicable Countries

Select one of:

  • All Allowed Countries²
  • Specific Countries

Sort Order

Use a numeric value to determine the sequence in which this shipping method appears when listed with other shipping methods during checkout.

¹ If you are using Price vs. Destination to determine the shipping cost, you can choose to Include Virtual Products in Price Calculation. The prices for these items will be added to those that are being shipped and used in the calculations.

² Remember, any countries you allow this rate to be used for either must be specified in your CSV file or use * for all unspecified countries.

When complete click the Save button to save your changes.

Here's an example of what this may look like once you're done:

Prepare the Data

🚧

Before you start

The table rates are entered by importing a CSV file, but first you need to export the file by selecting the Export CSV button. You will need to change the store view to see this setting.

When you click on the green Export CSV button, it will save the file to your computer and you can open and edit it in any spreadsheet editor of choice E.g. Excel or Google Spreadsheets).

📘

Country and US State Codes

Please refer our article for Country Codes or US State Codes.

Table Rate Examples

Price vs. Destination, all countries allowed:

Weight vs. Destination, USA only with different Regions:

The same way you would set up the CSV file when using Number of Items vs. Destination.

Import the Data

Once you have your file ready, you need to import it into your Table Rates shipping method. The upload file buttons is right underneath the Export CSV file button.

❗️

Don't see an import button?

You will need to change the Store Scope on the Top Right from "Default Config" to "Website".