You can upload the rates to our system by using this Link.
Rate template (IMPORTANT)
------------------------------------------
Only rates with valid dates will be uploaded. Expired rates will not be displayed.
To ensure that your uploaded rate files can be integrated quickly, it needs to have the following format:
Here is the rates template in case you need it --> Rates Template 2024.xlsx
These fields are (respectively):
Status (Default shows ACTIVE)
Options are ACTIVE, INACTIVERate Type (Default shows MARKET)
Options are CONTRACT, PROMO, INTERNAL, SELLINGIATA CASS
IATA CASS is required only for CONTRACT rates. This has 11 numbers; e.g. 1234567-1234*Airline (2 letter Airline IATA Code)
*Origin (3 letter IATA Code)
*Dest (3 letter IATA Code)
*Commodity :
Options are General Cargo / Perishable / Dangerous Goods / Live Animals / Pharmaceuticals / Valuables, Express, Human Remains, Others
(AVI, DGR, DGX, PER/FRESH, GCR, HUM/LHO, PHARM, VAL/VUN, XPS, etc.)Service (Default shows ALL)
Options are LD, MD, NBDensity (Default shows 1:6)
Options are <1:5, <1:4, <1:3, <1:2FlightNo (Default shows ALL)
This is the Flight Number.
Options are XXXNNNN (where XXX is alphabet and NNNN are numbers)Day (Default shows 1234567)
Indicate days when flight is available (where 1 is monday, 2 is tuesday, etc.)ULD Type
Options are LDP, MDP, AKE*Start Date
(Input in format YYYY-MM-DD, e.g. 2024-12-31)*End Date
(Input in format YYYY-MM-DD, e.g. 2024-12-31)Min-amount
(Minimum amount)Norm-pivotWeight
(Normal amount)45-overPivot
Rates +45kg100-maxWeight
Rates +100kg300
500
1000
3000
Currency
E.g. EUR, USD, etc.Fuel Surcharge
Security Surcharge
MSC
Miscellaneous chargesSeller IATACASS
(Leave this blank - 11 numbers; e.g. 1234567-1234)ID (Leave this BLANK/EMPTY)
Note that:
'*' indicates MANDATORY fields
Norm-pivotWeight = 0 to 45 kg
Commodity = Product Type
Do not change the spelling of the column titles/header
Do not re-arrange the columnsCommodity = Product Type
Do not type any words within the rates section; i.e. columns O to 3000kg )
UPLOAD MARKET RATE & Terms and Conditions
------------------------------------------------------------------------
Upload the rates to our system by using this Link
Input the 2 letter Airline Code
Select option 'Choose a file' to select the required formatted rates file to upload
Once file is selected, the filename will appear in the 'Name'
Remember to paste the Terms & Conditions in the box
Select the arrow pointing to the LEFT
Complete the information and click SUBMIT once you are ready to send the information.
You will see hereunder once your rates and terms & conditions have been successfully submitted:
Your rate sheet will be uploaded to us and published as soon as possible.
We hope you find this article useful!
Note: Images shown here are for illustrative purposes only.
CargoAi reserves the right to change the actual screen layout without prior notice.