About tier tables

A tier table is an n-dimensional table that consists of:

A Group Name column
A Range column
A set of one to five string or number output columns
A set of rows

When creating a tier table, you use:

The Group Name column to create groups of numerical intervals
The Range column to represent the numerical intervals of each group
The output columns to assign number or string values to each interval

Note: Remember that:

You can create as many groups as you want
You can create in each group ranging from -∞ to +∞ as many numerical intervals as you want
You can use negative or decimal numbers
You cannot create discontinuous or empty numerical intervals
You cannot delete or rename the default group
You must arrange the numerical intervals in increasing order
The numerical intervals cannot overlap
Each group of intervals is independent of the other ones

Tier tables are objects that you can reuse in price plans, costs, or pricing macros.

Example

A company sells postal services which are delivered by subcontractors. The parcel postal tariffs are priced according to the subcontractor, the region of the world, and the weight of the parcel (weight in gram: ]-∞, 200[, [200, 500[, [500, +∞[). All prices are calculated in USD.

In this example, if the subcontractor is unknown, the default group is used to determine the price of the postal service.

Using a tier table

Because a tier table cannot be inserted in a price plan, you need to insert a tier table operator component in a price plan, a cost, or a pricing macro to reuse an existing tier table.

The tier table operator allows you:

Select a tier table
Select one of the groups of the tier table
Select the property value to compare with the numerical intervals of the group