Company X is based in Denmark. They ship pallets to Norway and the carrier's prices are calculated based on pallet type and postcode in Norway. In addition to the base prices they also pay a diesel fee.
The price sheet from the carrier:
Below, you can see how this setup is made in the Excel template. You can download the sample Excel file, 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 be able to read and convert the Excel sheet to XML.
PriceCalculationSet
The main settings of the file.
For a detailed explanation of each field, see CPC Excel template: PriceCalculationSet tab explained
Zones-CountryList
Zones and country code:
CountryList-ZipCodeInterval
Postcode ranges are defined in 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
The BasePrices are set to 0 because Pallets are defined as goods types and are considered a fee the way the prices are calculated.
GoodsTypes-1
The price of the HalfPallet is defined for each route. Order determines the order in which different values are calculated to make up the total price.
GoodsTypes-2
Euro pallet and the price for each route. Prices differ depending on the number of pallets.
Fees-1
The diesel fee of 33% is defined here. Notice that is set to ToPreviousValue which means that it will calculated based on the price for the pallets. Order is higher than under the previous tabs to make sure that the diesel fee is calculated after the price for each goods type.
Download sample file
The "CustomerName - CarrierName - Pallets" file contains all the values from the use case.