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".
Updated about 5 years ago