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:

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.