Price, Weight, Items To/From Ranges

Many customers get confused around what the actual range is for each of price, weight, items "From" and "To". Let's try to clarify.

Firstly decide what you are wanting to achieve. Let's use price as an example. Do you want to say everything from 0-$70 is charged price X and everything over $70 is charged price Y, or alternatively do you want to say everything up to $70 is charged X, $70 or above is charged Y? Unless you know this it's hard to define your ranges in the CSV file.

There is an additional complication in that some of our CSV files work differently to others. This is done for backwards compatibility reasons - a lot of our clients have come from Matrixrate which has had 17000+ downloads, we need to ensure it's easy for them to transition to a new CSV file. For other extensions where people tend to write from scratch we have refined the ranges to work slightly better.


Range Approach A


This approach applies to the following extensions:

  • Matrixrate
  • Premium Matrixrate
  • Customer Rate
  • Percentage Rate
The fields are defined as follows:
  • Condition From - Greater than or equal to "From" value
  • Condition To - Less than or equal to "To" value

Taking above example lets say we want to charge everything upto $70 X, $70 or above Y. This is implemented as:

 Price From
 Price To
 Shipping Price
 0 69.99 X
 70 100000 Y


Range Approach B


This approach applies to all other extensions including:
  • ProductMatrix
  • Shipping Override
  • Handling Matrix

The fields are defined as follows:
  • Condition From - Greater than "From" value
  • Condition To - Less than or equal to "To" value

Taking above example lets say we want to charge everything upto $70 X, $70 or above Y. This is implemented as:

 Price From
 Price To
 Shipping Price
 0 69.99 X
69.99 100000 Y