The CPC interface provides functionality for exporting existing price data to Excel and also uploading Excel sheets containing new data for "Custom Price Calculation". This article explains the PriceCalculationSet tab which is always present in the Excel templates.

PriceCalculationSet

This tab is used for basic information about calculation.

Name

The name entered here will appear in the CPC user interface. A good practice is to name the file according to the Actor - Carrier - Product. For example, "Webshop123 - SuperCarrier - Pallets".
 

PriceCalculationType

The "PriceCalculationType" determines whether the price is calculated based on each individual package or for the entire shipment. It is important to understand this distinction as it will affect the final price. In the below example, a package weighing 8 kilos falls within the 5 EURO price range. If there are 2 packages, each weighing 8 kilos, and the price is calculated on a "Per Package" basis, then the price would be 2x5=10 euros. If the calculation is "Per Shipment", it would instead be 8 euros.

 
VolumeWeightFactor

The VolumeWeightFactor is a conversion factor used by carriers to determine the weight of bulky items based on their volume. This prevents trucks from being loaded with lightweight but space consuming materials that would be invoiced as weighing very little.

For example, if the carrier uses a conversion factor of 1 cubic meter (CBM) equals 250 kilograms (KG), then 1 CBM of goods will be billed as weighing 250kg, if the actual weight is lower. If the actual weight is higher, then the price will be calculated based on that.

To calculate the VolumeWeightFactor, divide 1000 by the weight value assigned to 1 CBM. For instance, if 1 CBM equals 250KG, the calculation would be 1000/250 = 4, and the VolumeWeightFactor to input would be "4".

LoadmeterWeightFactor

The LoadmeterWeightFactor is a concept that indicates the minimum weight equivalent of one loadmeter (LDM).

For example, a carrier may specify in their price sheet that 1 LDM=1500, which would be entered as 1500 in the "LoadmeterWeightFactor" field.

EntryIntervalType

"EntryIntervalType" defines if the price calculation is based on Weight, Volume, Loadmeter, GoodsTypes, etc. Some of the types here depend on the "PriceCalculationType" selected above.

If "PerPackage" is selected, then the following EntryIntervalTypes will work:

• Weight - Means the price is calculated on inputted weight on each package. 
• Package - The price will be calculated based on the number of packages.
• Pallet - Calculates the price on the number of pallets. This type can be used if the price on certain goodstypes is based on weight. 
• Volume - Means the price is calculated on the inputted volume of each package. Note: the volume is entered in cubic millimeters!
• GoodsType - Price is calculated on the number of inputted goodstype. Can use multiple goodstypes.
• Loadmeter - Means the price is calculated on inputted loadmeter of each package.
  
• MaxTWeightAndTVolumeWeightAndTLoadmeterWeight - Means the intervals must be weight, but the calculation will perform a loadmeter to weight conversion, and a volume to weight conversion, and use the highest weight of the three. Can also be used with only volume or loadmeter factor.

If the PriceCalculationType is set to "PerShipment", then the following EntryIntervalTypes can be chosen:

• Weight - Means the price is calculated on the inputted total weight of the shipment.
• Volume - Means the price is calculated on the inputted volume of the entire shipment. Note: the volume is entered in cubic millimeters!
• Loadmeter - Means the price is calculated on inputted loadmeter of the shipment.
• MaxTWeightAndTVolumeWeightAndTLoadmeterWeight - Means the intervals must be weight, but the calculation will perform a loadmeter to weight conversion, and a volume to weight conversion, and use the highest weight of the three. Can also be used with only volume or loadmeter factor.

CurrencyType

Here you can simply input the currency in which the price will be displayed in a 3 letter format. EUR, for Euros, GBP, for Great British Pounds, USD for United States Dollars etc.

MinPrice

Optional field.

It is possible to input a minimum price here to be displayed even if the calculated price is lower.

MaxPrice

Optional field.

Similar to the above, a maximum price can be used if you want to ensure the price can never go above a certain value.

StartDate

Optional field.

Can be used to upload a file that needs to activate at a specific date. For example, if you wish an updated file to take effect on January 1st of a new year. The format is YYYY-MM-DD, for example, 2024-01-01.

ExpireDate

Optional field.

Can be set if the file should stop working at a set date. Same procedure as above. If set to "*", it will never expire.

Description

Optional field

Can be used to write a short description of the configuration, note when the latest changes where made or similar. 

FormatVersion

Refers to the version of the CPC template version. Should be "1.1". Do not change.