Company Z is a German company sending many heavy and large-sized shipments. Their prices are calculated per shipment and according to weight. Additionally, the carrier charges a loading meter equivalent to 1500 kg and a cubic meter equivalent to 250 kg. There are also minimum and maximum prices in place.
Pricesheet from the carrier:
Below, you can see how this setup is made in the Excel template. You can download the sample Excel file in the bottom of this article, replace the prices with the prices from your carrier, and add more rows. Once the Excel template has been filled in, it can be uploaded using the CPC interface. Read more about file upload here: CPC Lesson 1 - Activation and file upload
Tabs in the Excel template
The following shows the tabs in the Excel sheet that are used to configure this use case. Names of fields and columns must remain exactly as in the template for the system to read and convert the Excel sheet to XML.
PriceCalculationSet
The main settings of the file.
The VolumeWeightFactor is 4. This is calculated by dividing 1000 by the cubic meter weight from the price sheet -> 1000/250=4.
The LoadmeterWeightFactor is set to 1500 kg as specified in the price sheet from the carrier.
The EntryIntervalType is set to MaxTWeightAndTVolumeWeightAndTLoadmeterWeight to account for volume weight and loadmeter weight in the calculation.
For a detailed explanation of each field, see CPC Excel template: PriceCalculationSet tab explained
Zones-CountryList
Zones and country:
CountryList-ZipCodeInterval
Postcode ranges are defined as ranges in three zones:
Routes
Routes are defined based on the zones:
The SenderZone is not defined because it is irrelevant to the price calculation in this example.
BasePrices
BasePrices are defined according to the weight intervals:
It is important to specify intervals correctly to avoid missing prices.
ValueFrom = included in the interval
ValueTo = up to but not included in the interval
The values in ValueFrom and ValueTo in consecutive intervals must always be identical to avoid intervals without prices.
Download sample file
The "Weight Per Shipment" file contains all the values from the use case.