Rule Explanation
- 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.
CSV Examples
Extension |
---|
Product Matrix |
Shipping Override |