Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases

Contents

5
(3)

Shipping is not a simple matter, even for simple store. WooCommerce (the plugin) does a good job offering some basic shipping cost calculations such as free shipping, flat rate… However, if your shipping cost is based on weight or price or number of items or a mix of all those things, you will need a help from an additional plugin. In this post, I’m going to introduce you to a plugin called table rates shipping for WooCommerce. With this plugin, you can

  • Setup shipping cost based on cart’s weight
  • Calculate shipping cost based on number of items in cart
  • Setup shipping cost based on products’ price, line total and cart total

Let’s get started.

Download and install WooCommerce table rates shipping

As mentioned in the beginning of this post, you’ll need the plugin called WooCommerce table rates shipping to follow along.

Download table rate shipping plugin

After activating the plugin, when you go to add shipping method, you’ll see the table rates shipping method is added, along with WooCommerce’s default shipping methods (flat rate, free shipping and local pickup).

As you can see that table rates shipping is just another shipping method. That’s why:

  • It must exists inside a shipping zone.
  • You can have multiple table rate shipping method per shipping zone.

How to setup WooCommerce shipping by weight

Let’s learn how to add shipping by weight using WooCommerce table rates shipping. In this example, I’m going to setup shipping cost by weight for the shipping zone US. As the method’s name suggest, it only works with items that have weight.

Here are the scenarios we are going to cover

Scenario 1:

 Order’s weightShipping cost
1Less than 3kg$20
2From 3kg to 20kg$40
3More than 20kg$1 per kg

Scenario 2:

  • If the order’s weight is less than 10, offer free shipping
  • If the order’s weight is more than 10, charge $0.5 per kg

First of all, let’s add the table rates shipping method for our shipping zone.

Let’s go to WooCommerce->Settings->Shipping->Shipping zones:

edit shipping zone to add shipping method

Under United State, I’ll click on edit.

In the next screen, click on Add shipping method and select Table rates:

select table rate shipping as shipping method for zone

Then, you’ll see the table rates shipping added to the list of shipping methods. Currently, I have only one.

list of shipping methods

Hover the cursor on the word Table rate, you’ll see an Edit link. Click on that to start configure the options.

table rates shipping settings - general
table rates shipping settings - rates
table rates shipping settings - table

You’ll find the detailed explanation for each fields in this post .

Setup the rules for scenario 1

Here is the place we are going to work:

Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases 1

As you can see, there isn’t any rule setup yet. The first column, Shipping class is visible if you have shipping classes setup. If you don’t have any shipping class (which is pretty normal), then you will not see this column.

Let’s review the shipping rules:

 Order’s weightShipping cost
1Less than 3kg$20
2From 3kg to 20kg$40
3More than 20kg$1 per kg

So, here is how we are going to set this up:

Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases 2

Let me explain the rules. We have three rows here. They are the result of three times I clicked on Add Shipping Rate button. You can add as many rules as you like.

Let’s look at the first row, Shipping class is set to Any class. I select this option for the sake of simplicity. However, you can see that you can combine shipping class with table rates shipping to create very complex shipping rules.

On the condition column, I set it to weight. This is obvious since we are setting up weight based shipping cost.

On the row cost, I set the number 20. Since we are calculating the shipping fee per order. This amount will be applied to the whole order, not just a single line in cart.

Every other columns are left as default.

The second row is similar to the first one. The on difference is we set the number 40 for row cost and the weight range is from 3 to 20

The third row corresponds to our third rule,  I set the minimum weight is 20 and in kg cost column, I set the number 1 to match with the condition $1/kg.

Let’s make a test order to see if the rules work as we expect.

First, I’m going to order 3 CPUs, two Intel’s and one AMD’s. One Intel’s CPU weights 0.4kg and one AMD’s CPU weights 0.5kg. The total weight is 1.3kg.

As you can see, the shipping cost falls into the first tier (for order which has weight less than 3kg):

shipping cost for first tier

Now, let’s add some more items to make the weight of the order more than 3 but less than 20kg. I’m going to add a desktop to the cart. The desktop weights 6kg so now, the total weight is 7.3kg. As you can see, the shipping cost has changed to reflect the change in shipping tier:

shipping cost for second tier

Finally, let’s add some more items to make the weight of our cart more than 20kg. I’m going to add three more desktops. That’s 18kg more and makes our cart now weights 25.3kg (18 + 7.3). As you can see, the shipping cost is now $25.3:

shipping cost based on cart weight by kg

Everything worked as we expected. That’s great!

Setup the rules for scenario 2

Now you know how to setup the rules for scenario 1, it’s super easy to setup the rules for scenario 2. Let’s review the requirements of scenario 2:

  • If the order’s weight is less than 10, offer free shipping
  • If the order’s weight is more than 10, charge $0.5 per kg

There are two rules you need to setup in this case:

table rates shipping rule for scenario 2

You can see that I added a label for the first row called Free shipping. This label will up when the rule in this row is applied.

Now, if I look at the cart (which still weights 25.3 kg), the shipping cost would be:

shipping cost for scenario 2

That’s 25.3/2 = 12.65

If I remove the desktops to make the weight less than 10, the shipping cost should be $0.

Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases 3

I hope you see the power of WooCommerce table rates shipping plugin in setting up weight-based shipping cost. However, that’s not the only capability of this plugin. You can also setup shipping cost based on items count and items’ price.

Using table rates shipping to setup shipping cost based on number of items

There are times you want to calculate the shipping cost based on the number of items in cart. One of the most common scenarios is you want to encourage the customers to buy a larger quantity. In such case, you may want to offer free shipping for orders that meet a certain amount of items in cart. Let’s discuss the following scenarios:

Scenario 1:

 Items in cartShipping cost
1Less than or equal 10$10
2From 11 upFree shipping

Scenario 2:

 Items in cartShipping cost
1Less than 10$1 per item
2From 11 up0.5$ per item

In scenario 2, we will also set a maximum shipping cost at $100. So, when the customers order more than 200 items, the shipping cost is still $100.

Rules for scenario 1: Free shipping when cart count reaches a certain amount

From the rules of the scenario, you can see that we need to set two rules. The first one is to set a flat shipping fee at $10 for orders than have up to 10 items. The second rule would be offer free shipping for orders that have more than 10 items. Here are the rules set in table rates shipping:

setting up table rates shipping rule for free shipping when cart count reaches certain amount

As you can see that, on both rows, I set the condition to Item count.

On the first row, I set the max items count is 10 and the row cost is $10 based on the requirement of the first rule. I also set a label named Flat rate so the customers can easily understand the kind of shipping fee is applied to their order.

On the second row, I only need to set the min item count to 11 and the label to free shipping.

Let’s check out cart.

Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases 4

Since I have only 3 items on my cart, the flat rate £10 is applied. Now, let’s increase the order of AMD Ryzen to 8 more. That’ll make our cart has 11 items. The shipping fee now should be 0 as the Free shipping condition is met:

free shipping when cart amount passes 10 items

Easy enough? Let’s discuss scenario 2.

Rules for scenario 2: Shipping cost per items changes when cart count reaches a certain amount

Scenario 2 is a bit different from scenario 1 since we don’t offer free shipping. Instead, we reduce the shipping cost per item from $1 to 0.5 when our customers order more than 10 items. In addition, there is a maximum shipping cost applied.

Let’s find out how to setup the shipping fee for this scenario.

First of all, we need to set the maximum shipping cost at $100. This step is quite simple. Let’s go up the screen and you’ll see a field called “Maximum shipping cost”. Enter 100 in that field:

setting up maximum shipping fee

Now, let’s go down and setup the rules:

setting shipping cost per item using table rates shipping

I hope the rules are visual enough so you’ll have no problem understanding them.

On the first row, I set the max item is 10 and item cost is one. That means for orders that have up to 10 items, the shipping cost per item is $1. I also set the label to $1/item so the customers will have an idea what kind of shipping fee is applied on their order.

On the second row, I set the min number to 11, max number to 200 and the label to $0.5/item.

Technically, I don’t have to add the third row since we already have the maximum shipping cost at $100. However, if I don’t set the third row, orders that have more than 200 items still have the label $0.5/item, which is very confusing to customers.

Test the rules on the shopping cart

Here, I have 9 items in my cart, the first rule is applied. The shipping cost is £9. Easy to understand, right?

Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases 5

Now, let’s increase the number of the first row to 173 items. That makes our cart 180 items in total. The shipping cost would be £90:

shipping cost discount on large item order

Finally, let’s make the cart count more than 200 items. I’m going to set the total order of the AMD CPU to 30. That’ll make our cart have 203 items. Due to our settings, the shipping cost should be £100 (the maximum amount):

Ultimate WooCommerce Table Rates Shipping Tutorial & Use Cases 6

As you can see, things work as we expected and that’s great.

Besides offering the ability to set the shipping cost based on weight, cart count, table rates shipping plugin also let you set the shipping cost based on cart or line total. I think you have no problem understanding calculating shipping cost based on cart total. However, what is line total? Let’s find out in the next section.

Using WooCommerce table rates shipping to set shipping cost based on items’ price, line total, cart total

First, let’s clear some terminologies.

Item’s price: the price of a particular item.

Line total: Let’s consider the following screenshot:

cart lines

This order has two lines. Normally, one product will occupy one line. The first line’s total is £48,440 and the second line total is £11,010.

Cart total: This term is simple enough. This is the total amount of the order and equals to the sum of all line total.

Now, let’s consider some scenarios:

Scenario 1: Setting up shipping fee based on cart’s total

 Cart totalShipping cost
1Up to £10,0005%
2More than £10,0002%
3Max shipping cost£700

Scenario 2: Shipping cost based on products’ price

Only charge a 2% shipping fee for products that have price less than £100.

Scenario 3: Shipping cost calculated based on line’s total

Only charge a 5% shipping fee for lines that have total less than £30,000.

Let’s setup the rules for each scenario using table rates shipping.

Scenario 1: Shipping cost is a percentage of cart total

First thing first, we need to setup the maximum shipping cost at £700. You should be able to do this since we have done it previously with item based scenario.

set maximum shipping cost

Next, set the calculation type to Per order since we calculate the shipping fee based on cart total:

set calculation type

Now, let’s set the rules:

set shipping cost based on cart total

The first row, I set the condition to price. The word “price” may sound confusing since we are talking about cart total. However, I think there aren’t many better choice for the developer since this name will also represent the price of a product if we set the calculation type to “per item”.

I also set the % cost to 5. This means the shipping cost will equal to 5% of the total order.

On the second row, I set the range from 10,000 to 35,000. Why 35,000? Since our max shipping cost is £700 (equals to 35,000 * 2%), setting 35,000 as the upper bound of the second line makes senses.

On the third row, I set the min to 35,000 and the row cost to 700. Since we have already set the maximum shipping cost to £700 previously, this row is not technically necessary. However, it will help the customers understand what kind of shipping cost is applied to their order.

Now, let’s go and check our cart. My cart total is £7,340. It’s less than 10,000 so the shipping cost should be equal 5% of cart total:

shipping cost based on cart total tier 1

Now, let’s add some more items to make the cart total pass £10,000. Let’s add 10 more items:

shipping cost discount on large order

Sure enough, the second tier is applied. The shipping cost is now only 2% of cart total.

Finally, let’s make the cart total exceed £35,000. I’m going to add 100 items more to the cart:

apply maximum shipping cost when cart total reached certain amount

As you can see, the flat rate £700 is applied as we expected.

Scenario 2: Charge a 2% shipping fee per item that has price less than £100

In this case, we are going to set the shipping fee based on product’s price. Specifically, the charge is 2% for products that cost less than £100. For products that cost more than that, we offer free shipping.

I’m not going to cover the maximum fee in this case since you know how to do that already. Let’s go straight to calculation type and set it to per item:

set calculation type to per item

Now, let’s set the rule:

set shipping cost based on products price

The rules are quite simple. On the first row, I set the % cost to 2 and the Max price of the item is 100. The second row states that for items that cost more than 100, there will be no shipping fee.

Let’s check our cart to see the rules in action:

shipping cost based on a percentage of products price

The calculation is not shown explicitly here. However, you can see that the cost for a single Samsung SSD is £46, which is less than £100 while the cost for an AMD CPU is more than £100. So, only the SSD price is used to calculate the shipping cost.

Sure enough, £4,600 * 2% = £92.

Scenario 3: Calculate shipping cost based on line total

Let’s discuss the final scenario. What if you want to charge a 5% fee based on lines that cost less than £30,000 only? Lines that cost more than that are eligible for free shipping.

Setting up the rules for this scenario is quite simple. First, we need to change the calculation type to “Calculate rates per line item”:

calculate rate per line item
setting up shipping cost rules based on line total

Now, let’s set the rules:

On the first line, I set the condition to Price, the Max value to 30,000 (you only see 3,000 in the screenshot because of the field to enter the number is quite narrow). The % cost is set to 5%.

The second is responsible for making lines that cost more than 30,000 eligible for free shipping. I only need to set the Condition to Price and the min amount is 30,000.

Let’s inspect this cart:

shipping fee based on line total

As you can see that, we have two lines that cost less than £30,000, that’s the second and third line. As the rules dictate, the shipping cost equals to 5% of the sum of these two lines:

Shipping cost = 5% * (4,600 + 7,447) = 602.35

That’s the number we see in the shipping cost field of the cart.

Conclusion

Table rates shipping plugin for WooCommerce is a very powerful tool for stores that need flexible, complex shipping calculation. You can set the shipping cost based on cart total, number of items in cart, cart’s weight or even single product’s price. Hopefully the tutorial and the specific scenarios presented in this post is helpful to you. If you need a specific scenario that you have trouble setting up, please don’t hesitate to write in the comment section below.

Click on a star to rate it!

Average rating 5 / 5. Vote count: 3

No votes so far! Be the first to rate this post.


Leave a Reply

Your email address will not be published. Required fields are marked *