-
Click the required EML number from the EML Management page.
-
Click Import Price List
and select the .XLSX file.
-
The .XLS file needs to have the following header row items: EML Number, Category 1 Code, Category 1 Description, Category 2 Code, Category 2 Description, Category 3 Code, Category 3 Description, Category 4 Code, Category 4 Description, Category 5 Code, Category 5 Description, Category 6 Code, Category 6 Description, Price Code, Description, Shipment Phase, MOT Code, HLO Criteria, Tag Number, Tag Description, Geographical Area, Country of Loading, Port of Loading, Country of Discharge, Port of Discharge, Container Type, Container Provider, Container Out of Gauge, Price Base, Base Unit, Unit Rate, Base Unit 2, Currency, Grace Period, Range, Minimum, Minimum Chargeable.
-
Mandatory columns are : EML Number, Category 1 Code, Category 1 Description, Shipment Phase, MOT Code, HLO Criteria, Price Code, Description, Price Base, Base Unit, Unit Rate, and Currency.
-
While it is fine if there is no corresponding data for some of the optional header row items, there should not be any blank data row in the spreadsheet. If there is any blank data row, all the price list data after that data row is ignored during the import process.
-
-
Click Save.
-
You can only import a price list for EMLs that are assigned with a freight forwarder.
-
After importing a price list, you can no longer modify the freight forwarder (in the Company box) for that EML.
-