Step 2: Prepare the table rate data

  1. 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.
  2. Change the Condition as needed.

  3. Click Export CSV.

    Export CSV

  4. Save the tablerates.csv file to your system.

  5. Open the file in a spreadsheet application.

  6. 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.

    Weight vs. Destination (Australia)

  7. Save the tablerates.csv file.

Step 3: Import the table rate data

  1. Return to the Table Rates section of your store configuration.

  2. In the upper-left corner, set Store View to the website where this method is used.

  3. For Import, click Choose File and select your completed tablerates.csv file to import the rates.

    Import Table Rates

  4. 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.

COUNTRYREGION / STATEZIP / POSTAL CODEORDER SUBTOTAL (and above)SHIPPING PRICE
USAHI*10010
USAHI*5015
USAHI*020
USAAK*10010
USAAK*5015
USAAK*020
USA**1005
USA**5010
USA**015

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.

COUNTRYREGION / STATEZIP / POSTAL CODEWEIGHT (and above)SHIPPING PRICE
AUSNT*939.95
AUSNT*019.95
AUSVIC*919.95
AUSVIC*05.95
AUSWA*939.95
AUSWA*019.95
AUS**929.95
AUS**09.95

Example 3: Restrict free shipping to the continental United States

  1. Create a tablerates.csv file that includes all the state destinations to which you are willing to provide free shipping.

  2. Complete the table rate configuration with the following settings:

    SettingValue
    ConditionPrice v. Destination
    Method NameFree Shipping
    Ship to Applicable CountriesSpecific Countries
    Ship to Specific CountriesSelect only United States
    Show method if not applicableNo
  3. In the upper-left corner, set Store View to Main Website, or to any other website where the configuration applies.

  4. For Import, click Choose File and select your completed tablerates.csv file to import the rates.

Commerce