Skip to main content
Uploading market rates
Fanny Leong avatar
Written by Fanny Leong
Updated this week

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 October 2024.xlsx

These fields are (respectively):

  1. *Status (Default shows ACTIVE)
    Options are ACTIVE, INACTIVE

  2. *Rate Type (Default shows MARKET RATE)
    Options are MARKET, PROMO, CONTRACT, CONTRACT_PROMO, INTERNAL, SELLING

  3. IATA CASS
    IATA CASS is required only for CONTRACT rates. This has 11 numbers; e.g. 1234567-1234

  4. *Airline (2 letter Airline IATA Code)

  5. Country - Origin country

  6. *Origin (3 letter IATA Code)

  7. *Dest (3 letter IATA Code)

  8. *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.)

  9. Prod Code - Special product codes/names specified by airline for their commodities

  10. SHC - Special Handling Codes where you can specify XPS for express or PAX and CAO for commodity Dangerous Goods

  11. Service (Default shows ALL)
    Options are ALL, LD, MD, NB

  12. Density (Default shows 1:6)
    Options are 1:6, <1:5, <1:4, <1:3, <1:2

  13. FlightNo (Default shows ALL)
    This is the Flight Number.
    Options are XXNNNN (where XX is the airline code and NNNN are the numeric flight number

  14. Day (Default shows 1234567)
    Indicate days when flight is available (where 1 is monday, 2 is tuesday, etc.)

  15. ULD Type
    Options are LDP, MDP, AKE

  16. *Start Date
    (Input in format YYYY-MM-DD, e.g. 2024-12-31)

  17. *End Date
    (Input in format YYYY-MM-DD, e.g. 2024-12-31)

  18. *Min-amount ​(Minimum amount)

  19. Norm-pivotWeight ​(Normal amount)

  20. 45-overPivot (​Rates +45kg)

  21. 100-maxWeight (​Rates +100kg)

  22. 300

  23. 500

  24. 1000

  25. 3000

  26. *Currency (​E.g. EUR, USD, etc.)

  27. Fuel Surcharge

  28. Security Surcharge

  29. MSC
    Miscellaneous charges (per KG)

  30. Seller IATACASS
    (Leave this blank - 11 numbers; e.g. 1234567-1234)

  31. Remarks - Airline remarks showing additional info about the rate, e.g. routing info, aircraft type info, etc.

  32. Ref - Airline rate info or identifier that can help us trace the original airline raw rates

  33. 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 columns

    Commodity = 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.

Did this answer your question?