Step 2: Prepare the table rate data
-
In the upper-left corner, set Store View to
Main Website
, or to any other website where the configuration applies.NOTE
If necessary, first deselect the Use system value checkbox to change the following settings as described. -
Change the Condition as needed.
-
Click Export CSV.
-
Save the
tablerates.csv
file to your system. -
Open the file in a spreadsheet application.
-
Complete the table with appropriate values for the shipping calculation condition.
- Use an asterisk (*) as a wildcard that represents all possible values in any category.
- The Country column must contain a valid three-character code for each row.
- Sort the data by Region/State so the specific locations are at the top of the list, and the wildcard locations at the bottom. Using this method processes the rules with the absolute values first, and the wildcard values later.
- Zip/postal code ranges are not supported. Use an asterisk (*) to allow all codes within the region/state, or specify a single code for a specific location in the Zip/Postal Code column.
- Values in the Weight (and above) column can have a maximum of four decimal places (such as
2.5075
). Using more decimal places in the data causes the import to fail.
-
Save the
tablerates.csv
file.
Step 3: Import the table rate data
-
Return to the Table Rates section of your store configuration.
-
In the upper-left corner, set Store View to the website where this method is used.
-
For Import, click Choose File and select your completed
tablerates.csv
file to import the rates. -
Click Save Config.
Step 4: Verify the rates
To make sure that the table rate data is correct, go through the payment process with several different addresses to make sure that the shipping and handling rates are calculated correctly.
Example 1: Price and destination
This example uses the Price v. Destination condition to create a set of three different shipping rates based on the amount of the order subtotal for the continental United States, Alaska, and Hawaii. The asterisk (*) is a wildcard that represents all values.
COUNTRY | REGION / STATE | ZIP / POSTAL CODE | ORDER SUBTOTAL (and above) | SHIPPING PRICE |
---|---|---|---|---|
USA | HI | * | 100 | 10 |
USA | HI | * | 50 | 15 |
USA | HI | * | 0 | 20 |
USA | AK | * | 100 | 10 |
USA | AK | * | 50 | 15 |
USA | AK | * | 0 | 20 |
USA | * | * | 100 | 5 |
USA | * | * | 50 | 10 |
USA | * | * | 0 | 15 |
Example 2: Weight and destination
This example uses the Weight v. Destination condition to create different shipping rates based on the weight of the order.
COUNTRY | REGION / STATE | ZIP / POSTAL CODE | WEIGHT (and above) | SHIPPING PRICE |
---|---|---|---|---|
AUS | NT | * | 9 | 39.95 |
AUS | NT | * | 0 | 19.95 |
AUS | VIC | * | 9 | 19.95 |
AUS | VIC | * | 0 | 5.95 |
AUS | WA | * | 9 | 39.95 |
AUS | WA | * | 0 | 19.95 |
AUS | * | * | 9 | 29.95 |
AUS | * | * | 0 | 9.95 |
Example 3: Restrict free shipping to the continental United States
-
Create a
tablerates.csv
file that includes all the state destinations to which you are willing to provide free shipping. -
Complete the table rate configuration with the following settings:
Setting Value Condition Price v. Destination
Method Name Free Shipping
Ship to Applicable Countries Specific Countries
Ship to Specific Countries Select only United States
Show method if not applicable No
-
In the upper-left corner, set Store View to
Main Website
, or to any other website where the configuration applies. -
For Import, click Choose File and select your completed
tablerates.csv
file to import the rates.