Consolidated pricing allows price lists to be configured with an option to group orders that match a set consolidation criteria. Grouping these orders allows for beneficial pricing, automatically apply the enhanced rate.
Configuration
When creating a new rate card, you can specify which method of consolidation you want to use.
After creation, the consolidation method is NOT editable anymore.
When adding charges, under certain conditions, you will have the option of selecting the consolidated metric within price tables
Selecting the consolidated version of the metric is only supported if all of the following conditions are met:
The rate card has a consolidation method selected
It’s within a price table that is evaluated as Fixed amount or as Per metric per order
The selected metric in the column of the price table is a Goods metric
How does consolidation work?
Once assigned to a trip, we will look for other orders that match the consolidation method that is selected on the order’s rate card. The customer and rate card of the orders also needs to be the same. These orders will then get grouped together in order to access the grouped goods metrics in the price tables.
In the examples below, there are 3 orders which match the consolidation criteria, in this case Same collection & same trip (in addition to the same rate card and customer). This matches the consolidation method on the rate card of those orders so they are grouped together.
Fixed amount price table result
The transport charge uses a fixed amount price table and uses the consolidated quantity of the goods to select the price from the table. The result of the table is 80GBP but since it’s a fixed amount, this amount is distributed equally across the orders in the group.
Multiplied by a metric per order result
When a price table is used where the result is multiplied by a metric (in this case ordered quantity) of the order, the quantity of goods are combined and this value is used to select the appropriate rate on the price table. This form of consolidation allows all orders to benefit from the volume discount. In this pricing model, each order is priced separately using the adjusted rate.
👇 Important stuff
The consolidated price can be outdated
For performance reasons, we do not recalculate all orders’ pricing within one consolidation group if one of the orders in the group is adjusted.
Right before invoicing, we recalculate the orders with the ‘Ready to invoice’ task so that can be used as a synchronisation point for the orders within a group.
The consolidation method on the rate card can not be adjusted after creation
Consolidation is only available for fixed amount price tables and for multiplied by metric price tables per order
It is NOT available for conditions.
It is NOT available for formulas.
It is NOT available for price tables where the result is evaluated per stop, per good or per country.
Consolidation assumes you invoice the orders within the same invoice at the same time
Since charges can become locked once you start invoicing, you should invoice all the consolidated orders at the same time to avoid issues. Orders on an invoice are still taken into account for consolidation.
Charge might not be present on all orders that are consolidated if it needs to be added manually
If you can try to avoid manually add charges since the consolidation does not take into account if the charge is on the order or not to add it to the consolidation group.
For example:
Order A: has transport charge + surcharge X
Order B: has transport charge + surcharge X
Order C: has transport charge
All orders are according to their price list consolidation method within the same group. The transport charge will use the consolidated metrics of the entire group. But surcharge X will also use the consolidated metrics of the entire group
Consolidation is only available on the main consignment collect/delivery stops
So not possible on the pickup/drop/couple/uncouple empty container/trailer stops
Consolidation is currently not compatible with payant pour/pour en pay configuration
Payant pour/pour en pay can not combined with order consolidation.
Multi consignment order consolidation might lead to undesired results
The same collection/delivery address we look at for grouping order is the first collection/last delivery of the order.
If you have multiple consignments, it starts to become ambiguous into which consolidation group the order belongs to. So it is therefore advised to have 1 consignment = 1 order.