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
Consolidation of Charges for Order Groups
Consolidation of charges is supported for two main types of calculation methods:
1. Fixed Calculation Methods: For charges with a set, fixed amount.
When you use a fixed amount price calculation, Qargo offers flexible distribution, allowing you to either split the total fixed charge equally across all linked orders or assign the entire amount to a single order within the group.
2. Metric-Based Calculation Methods: For methods using a formula or a price table that is calculated based on a specific metric (e.g., distance, time) measured per order or per stop.
Metric per stop
When using a metric per stop, it is only possible to choose between:
Consolidate: the total price of all orders will be added to each order
Don't Consolidate
Metric per order
When using a metric per order, it is possible to choose between:
Consolidate, everything on a single order: the total price of all orders in the order group will be added to only one order.
Consolidate, split by metric: the total price of all orders in the order group will be divided amongst all orders based on the metric. Ie. if the metric total distance per order is used, the total price will be divided based on the total distance of each order.
Consolidate, split equal: the total price of all orders in the order group will be divided equally amongst all orders in the order group.
Don’t consolidate
📚 When an order is added to an Order Group with consolidation enabled, the price of the new order will be recalculated, but the prices of the existing orders in that group must be recalculated manually.
📚 Reminder: orders are only consolidated if they use the same rate card and have the same customer
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.