Company Y is a Danish company sending packages to Poland. Their prices are calculated per package and based on a combination of weight and the recipient postcodes in Poland. Occasionally the company needs to send Express packages. This service has a fixed fee of 25 Euro which is added to the base price.
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:
The main settings of the file.
For a detailed explanation of each field, see CPC Excel template: PriceCalculationSet tab explained
Zones and country code:
Postcode ranges are defined in three zones:
Routes are defined based on the zones:
The SenderZone is not defined because it is irrelevant to the price calculation in this example.
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.
The ServiceId is the value in the system pointing to the correct service. In this case, it is a fictional ID illustrating an Express service. See this article to learn how to find a service ID: CPC Lesson 6: Setting up Fees and Discounts.
Download sample file
The "Weight Per Package" file contains all the values from the use case.