How to Import and Create a Ratecard to be linked to a Surcharge

How to Import and Create a Ratecard to be linked to a Surcharge

There will be certain instances where a carrier will provide you will surcharges which are based on the volume of the consignment or its charge weight. As such, there is a need to utilise MachShip's internally built ratecard pricing in order to calculate the correct surcharge for these consignments. 

Below we will describe how you can look to import the base pricing ratecard to MachShip  via a ratecard. 

First, you will need to create your surcharge ratecard template. This will be created using the standard MachShip ratecard template. The article and video below will outline how this can be completed. 

How to Create the Ratecard Template

How to Navigate to Import surcharge Ratecards

Select the Admin drop-down and click on Import Ratecards


How to Import Ratecards

Click on Add files, search and select the file(s) you would like to import.


Click on Upload to start the process of importing the new ratecard. At this point, the rate card will be validated for any errors. Common errors and their explanation can be found in this article


Once successful, a green 'Worksheet was uploaded successfully' notification will show in the top right corner of the screen. The file will then be available in the Import section.


To import the file(s), select the file(s) by clicking on the tick which is located in the far left column. Then select Import Selected Ratecards.


This will prompt the Import Ratecards Modal to appear. 

Import Ratecards Modal

The Import Ratecards Modal will have the following features. 

1. Import File Information

Listed along the left-hand side will be all the files that you are attempting to import. 


  • Ratecard Abbreviation

Number of Rates being imported and what action is being completed. This will indicate the ratecard being created, adjusted and detail what the system will be looking to do. As an example in the image above MachShip will be creating 94 new rates. 

  • File Name

The name of the CSV file being imported.

  • Carrier

This will be the name of the Carrier you are importing rates for.

To remove a file from the import, select the red cross icon as shown below:

2. Import Options

If you are importing a Ratecard Template which has its abbreviation (the text is shown in column 2) not match with any existing Ratecard in MachShip then the screen will appear as below:


The only option that you will be presented with is to Create a New Ratecard.

How to Import and Create a New Ratecard

When you look to import a file without a matching ratecard abbreviation then the import modal will look like the image below.


To create a new ratecard, provide the following details:

  • Set to be Surcharge ratecard:
    By default, MachShip will create a new Ratecard as a Cost RateCard. This will be indicated by the below:

Because we wish to import and create a Surcharge ratecard, simply select the switch and it will change to be the below:


  • Effective Date

By default, MachShip will assume that the rates being imported are to be the Original Rates. Being the Original Rates they will be effective from all time. As a result, the Effective Date switch is set to be No.


If you need to make the new rates effective from a set date you will need to. 

1. Set the effective date switch as Yes.


2. Set the Effective Date

To set a date, select the Calendar Icon and the date. The date will then appear as below:


  • Ratecard name

This is a free text field, you can set the name of the new ratecard.


Once completed, select Import Ratecards.


A green 'Ratecard(s) imported successfully' notification will show in the top right corner of the screen when the import is successful.

    • Related Articles

    • How to Create a Surcharge and Price via a Ratecard

      There will be certain instances where a carrier will provide you will surcharges which are based on the volume of the consignment or its charge weight. As such, there is a need to utilise MachShip's internally built ratecard pricing in order to ...
    • How to create a Surcharge in MachShip

      When a carrier provides pricing, the figures are calculated and provided based on standard freight. When we describe standard freight, this will be either the type of freight the carrier wants to transport or alternatively, the freight types you have ...
    • How to exclude a Company from a Surcharge

      There will be times when a surcharge needs to be assigned to a large set of companies but not to all of your available companies. In order to make the process more efficient, the MachShip team suggests that you link the surcharge to all of your ...
    • How to assign out a different prices for surcharges

      MachShip has enabled the ability for a user to be able to assign out different prices on existing surcharges with pre-saved configurations. This will be relevant for all surcharges but particularly for configurations such as Hand Unloads, Tailgates ...
    • Common Scenarios to Check when creating, editing or updating Carrier Surcharges

      Below the MachShip team will look to outline a few different scenarios and things to think when looking to test any surcharge that you have created or adjusted in the MachShip platform. 1.) Adjusting the Automatic Flag Surcharges that are created can ...