.png)
Service Rates
Service rate template
Once a contract has been created, rates must be added. Manage rates by downloading a service template from the contract, which includes every available service for the selected carrier, along with all injection points. Edit the template as needed and upload it back to the contract.
Navigate to the Management settings and select 'Contracts' from the menu. Now select the contract you want to add rates to and click ‘Download rate template.’
The contract will now be downloaded in a .csv format. Depending on the number of services the carrier has in our database, this may take a several minutes.
Service rates
There are two types of rate sheets based on the selected carrier:
Dynamic: The prices are updated in real-time, based on the data sent and received from the carrier.
Manual: These require you to manually input the purchase and selling rates.
Dynamic rates
Some carriers offer real-time rate retrieval, known as dynamic rates. With dynamic rates, you only need to define the margin, flat fee, or both to apply to the rate returned by the carrier. By default, each row is one service.
service code: The MyParcel.com code mapped to the carrier’s product.
zone from: The origin zone code.
zone from name: The origin zone name.
zone to: The destination zone code.
zone to name: The destination zone name.
include_origin_from_destination_zone: If the destination zone includes the origin zone, this will determine if shipping from origin to origin is allowed or should be excluded.
package_type: The package type as defined in the MyParcel.com API.
weight min: The minimum weight for the service.
weight max: The maximum weight for the service.
length max: The maximum length allowed for the service.
width max: The maximum width allowed for the service.
height max: The maximum height allowed for the service.
volume max: The maximum volume allowed for the service.
is_dynamic: Always set to true. It can be changed to false and replaced with a manual rate, but in that case, the service should be added to a new sheet and contract.
dynamic_price_percentage: The percentage margin to be added to the rate. For example, 40 equals 40%.
dynamic_price_fee: The flat fee to be added as a margin. For example, 140 equals €1.40.
ℹ️ For carriers that charge based on volumetric weight, the weight max specified should be set high enough to account for shipments with larger dimensional weights.
For example, if the maximum weight is set to 10000 (10 kg) and the carrier uses a volumetric divisor of 5000, a shipment measuring 50 cm x 50 cm x 50 cm would calculate to 25 kg volumetric weight. In this case, no services would be returned because the platform is only allowing up to 10 kg.
ℹ️ The dynamic_price_percentage is applied first, followed by the dynamic_price_fee. Below is an example showing how margins are applied:
The first image shows only the dynamic_price_percentage being applied.
The second image shows only the dynamic_price_fee being applied.
The third image shows both being applied together.
If you do not want any margins applied, set both values to 0.
ℹ️ If any service options or dimensions should not be shown, replace the cell value with null.
ℹ️ Any rows of origins, destinations, or services that are not offered can be removed from the rate sheets.
ℹ️ Delivery options for dynamic rates, such as option|liability-coverage, do not need to be modified. When a shipper selects a specific service option, an updated rate request is sent to the carrier, ensuring the service change and updated price are confirmed.
The example below shows a UPS Standard service with a base price of £12.21. Once the liability option is selected and a coverage amount is entered, the rate can be refreshed to display the updated selling price - in this case, £26.06.
Manual rates
For carriers without a rate endpoint, purchase rates must be manually added to the rate sheet. These are referred to as manual rates.
service code: The MyParcel.com code mapped to the carrier’s product.
zone from: The origin zone code.
zone from name: The origin zone name.
zone to: The destination zone code.
zone to name: The destination zone name.
include_origin_from_destination_zone: If the destination zone includes the origin zone, this will determine if shipping from origin to origin is allowed or should be excluded.
package_type: The package type as defined in the MyParcel.com API.
weight min: The minimum weight for the service.
weight max: The maximum weight for the service.
length max: The maximum length allowed for the service.
width max: The maximum width allowed for the service.
height max: The maximum height allowed for the service.
volume max: The maximum volume allowed for the service.
amount: The selling price of the contract holder.
purchase amount: The cost of the rates from the carrier to the contract holder.
fuel surcharge: Is a percentage of the purchase amount.
ℹ️ The fuel surcharge can either be shown as included in the total displayed rate or as an additional amount added on top.
For example, in the first row of the image below, 55:110|false means:
The €5.50 carrier rate had a 10% fuel surcharge applied.
A 20% selling margin was then added, creating the 55:110 value.
The final part specifies whether the fuel surcharge is included in the selling price (true) or added on top (false).
If set to true, the selling rate shown on the platform will be €7.50 (as shown in cell N2).
If set to false, the fuel surcharge will be added on top, making the total shown in the platform €8.60.
If you do not want to apply a fuel surcharge, simply enter null.
The surcharge is labeled clearly on the service selection cards.
ℹ️ Each carrier offers different delivery options, and any available for a specific carrier are included in the downloaded rate template.
Most carriers apply a flat additional fee for these service options, which can be added directly to the sheet along with the corresponding selling price.
For example, in the first row of the image below:
The base purchase cost of the service is €5.50, with a selling price of €7.50.
If a delivery before 10 AM option is selected (cell Q2), the carrier charges an extra €10.00, bringing the total purchase cost to €15.50.
The selling price for this delivery option (cell Q2) is set to €15.50, resulting in a total selling price of €23.00 displayed on the platform.
If you do not want to offer a delivery option, simply enter null.
The example below shows a DHL Parcel next day service with a base price of £9.06. When a delivery option is selected - in this case, Before 10:30, which costs £10.10 - the displayed price updates to £19.16.
ℹ️ There are hundreds of delivery options available in the database. Below are a few examples. These options will always appear at the end of the rate sheet - after the fuel surcharge in the manual rate sheets and after the dynamic_price_fee in the dynamic rate sheets.
option|bulky-goods
option|cash-on-delivery
option|delivery-method:assembly:adjustment
option|delivery-method:demount:white-goods
option|delivery-method:disposal:electrical-appliances
option|delivery-window:before-09-00
option|delivery-window:before-12-00
option|delivery-window:custom-date
option|paperless
option|proof-of-delivery
option|secure-delivery:id-check
Maximum length surcharge
There are two columns that can be included in the manual rates sheets and they are:
oversize_surcharge: Is the length that needs to be exceeded before the oversize_purchase_price is calculated.
oversize_purchase_price: The extra price that is charged if the maximum legth exceeds that as stated in the oversize_surcharge column.
For example, in the manual rate sheet below, the base selling price is £6.92. The oversize_surcharge is set to 52 cm, with an oversize_purchase_price of £30.86. This means that if this service is selected and the entered length exceeds 52 cm, the oversize_purchase_price will be added to the selling rate. A label will also be applied to the service card to indicate the surcharge.
Importing rates
Once the rate sheet has been updated, it must be imported into the selected contract.
Navigate to the Management settings and select 'Rates' from the menu. Then, click ‘Import rates’ on the right-hand side.
Select the carrier and contract you want to update.
Service rate templates can be saved locally as a CSV file or stored on a shared drive. If using a shared drive, ensure the general access is set to ‘Anyone with the link can view,’ and be sure to copy the direct URL to the file, not the share link.
When uploading service rates to a contract, all existing rates are removed and completely replaced with the new import by default. If you don’t want to overwrite the current data and instead add additional service rates to the existing ones, select 'Keep existing rates.'
The service rates will now begin importing, and the status will show as In progress. Depending on the file size, the import may take anywhere from a few seconds up to 45 minutes. This process runs in the background, so you can safely navigate away from the page.
Once the service rates have been imported, the status will update to Success.
Failed imports
If a file fails to import, an error message will appear explaining the issue. In the example below, a service has been added that isn’t recognized, or some data on the service row has been altered - such as the package type being changed from letterbox to parcel. If you encounter these errors, please double-check the data or raise a service & rates ticket in our support portal to request new zones to be added.
