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.
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.
Please sign in to leave a comment.