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

Default

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

Ranges

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:

Cart Price >$500 and <=1000 costs $50

Cart Price <$10 costs $4.95

Cart Price >10000 costs $0.00

Bed Price > $100 costs $100

Advanced Options

Product Matrix also supports filtering the price based on:

Individual Product Price

Row Total of Individual Product

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