Filtering based on Price Range

Rule Explanation

You can filter on the total price of the following:
  • Cart
  • Shipping Group
  • All items not in a shipping group

In general terms the filtering is done based on the shipping group specified.  So if you have the shipping group set to a particular set of products (E.g.: BEDS) then the price rule applies to the total price of those beds.

If you use an asterisk (*) in the shipping group then depending on how you configure the store wide rules this will either be the total price of cart or total price of all items not in a shipping group. See the shipping group article for more information (Product Matrix/Shipping Override only).


By default use * in these fields to filter without a price limit.

I.E.: “Price from” * refers to any price below the “price to” column. “Price to” * refers to any price above the “Price from” column and an asterisk (*) in both columns means any price at all.

Note: In Matrixrates you cannot use *, a price value must be specified e.g. price from 0 price to 10000.00


In the extensions the following ranges are used, which also applies to the weight columns:

Extension Ranges   Example  Description
MatrixRate, PremiumRate   price >=,price<= price >=100,price <=200 Price is equal to or greater than 100 and less than or equal to 200
All other extensions price >,price<= price >100,price <=200 Price is greater than 100 (I.E. 100.01 or more) and less than or equal to 200

Quick Examples

You may have the following types of rules:

  1. Cart Price >$500 and <=1000 costs $50
  2. Cart Price <$10 costs $4.95
  3. Cart Price >10000 costs $0.00
  4. Bed Price > $100 costs $100

Advanced Options

Product Matrix also supports filtering the price based on:

  1. Individual Product Price
  2. Row Total of Individual Product

These are managed via the totalling algorithms. Most of our customers do not need these additional rules.

CSV Examples

0 votes

Leave a Reply

Featuring WPMU Bloglist Widget by YD WordPress Developer