Efficiently managing your ocean freight rates is crucial for seamless operations and accurate quoting. The Tariff Manager on WebCargo Ocean provides a comprehensive solution, allowing you to upload and manage your Ocean main leg rates using Excel templates.
This article will walk you through the steps to effectively use the Tariff Manager, to ensure you upload, review, and update your rate files with ease.
To get started, navigate to the side menu and select Rate management.
Then expand the Ocean mainleg dropdown and click on Tariff Manager.
Here you will see the Files tab, where you will find any files that have been previously uploaded.
You can quickly view the number of rates each file contains, as well as how many are currently valid and how many have expired. Hover over the numbers in the Rates column to see more details. The example below shows that out of the 5 rates in the file, 2 are valid (shown in green) and 3 are out of date (shown in red).
The Valid from and Valid to columns provide specific dates or display Multiple for files with rates having different validity periods.
Switch to the Rates tab to view all individual rates from your uploaded files.
To begin uploading your rates, return to the Files tab and click Upload file.
A side panel will open on the right-hand side of the screen, allowing you to drag and drop your file or browse your device to select it. You can choose to use a custom file format or download and fill out the provided template (our standard FOT Freightos template).
Once you’ve selected your file, you’ll be prompted to choose the Supplier these rates apply to. You have the option to select a specific carrier or, if there are rates for several different carriers, you can choose the multicarrier options. Ensure you specify whether your rates are for FCL or LCL.
Finally, click Upload to begin the import process.
Our system will then process your file. While this takes place, the status of your file will be Pending. It may take up to five minutes for the file to be processed, but this will depend on the size of your file.
Once processed, the status will change automatically to Completed, Error, or Need attention.
You can filter all your files by status using the filter on the top left-side.
A Completed status means that the system has been able to properly process the file and that there are no issues with the uploaded data.
When the status changes to Error, this means that the system has not been able to read any of the data in the file, such as when the data entered does not match the required fields. In this case, a new file will need to be uploaded.
For files where most of the data has been properly read, but there are some discrepancies, the status will change to Need attention. In this case, the fields where errors have been found can be corrected without the need to enter all the information again.
Click anywhere on the row to edit a file. In the case of a file that requires attention, click to see which fields need to be corrected. The rates in these files will not be valid or quotable until they are corrected and the upload can be completed. The red circular icon indicates which rates need to be reviewed, alongside incorrect details highlighted in red.
For larger files, toggle the Show only errors option to only display rates with errors that need to be corrected.
The data can be edited manually, simply by clicking on the field. In the example below, a new date can be selected.
To edit several rates at once, use the Find and Replace tool.
This will open a pop up where you can select which column needs to be edited.
Once the column is selected, enter the value that needs to be corrected and the data with which it needs to be replaced.
Finally, select whether you want to Replace the date one by one or Replace all, then click on Done.
Once the data is corrected, the red icon will no longer appear next to the rate.
Click on Upload to update the corrected data within the system. You will then see the status change from Need attention to Completed.
To learn how to search, compare and quote with WebCargo Ocean, read this article.
If you have any questions, start a conversation with our support team using the chat bubble on the bottom right-hand corner.