Table rate shipping lets you calculate shipping rates with 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

---

Set up your Table Rate Shipping Method

Add Best Way to your shipping methods

In your Control Panel, go to Settings > Shipping Methods. If Table Rate is not shown, click on Add Shipping Method. Choose the Best Way method, and set Enabled to Yes.

• You can now adjust the settings of your Table Rate and import the rate sheet.

Modify the following settings:

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

³ A rate that specifies a Service Name in the CSV file displays that name instead. See Account IDs and Service Names.

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

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

Table Rate Surcharges

A different surcharge can be set per table rate through the Surcharge and Surcharge Type columns.

• Surcharge - Percentage or flat amount that gets added to the Shipping Price.
• Surcharge Type - Can be set to "Fixed Amount", or "Percent of Order Subtotal" to determine how the surcharge is calculated
  These shorthand codes can also be imported: amount, percent

---

Shipping Rate for specific Account IDs

One CSV file can cover many customer-specific pricing and services so they're all managed through one CSV. Enter the account IDs, comma-seperated, to limit that rate to certain customer orders.

• Account IDs - A comma-separated list of the Account IDs the rate applies to (for example 1024,1085). Leave the cell blank to apply the rate to all Accounts.

Example: Mixed general use and account specific Shipping Rates

The first two rows leave Account IDs blank, so every Account sees both "Standard Ground" and "2-Day Air" at checkout. The third row applies only to Accounts 1024 and 1085, who also see a "Contract Ground" rate of $8.

These columns are not required and are excluded from the examples below. These columns are all exported by default from the Table Rate shipping method settings.

---

Table Rate Examples

Price vs. Destination:

CLICK HERE TO DOWNLOAD

---

Weight vs. Destination:

CLICK HERE TO DOWNLOAD

---

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.