All Collections
Airlines
Rates
How to upload market & contract rates (Airlines)
How to upload market & contract rates (Airlines)
Fanny Leong avatar
Written by Fanny Leong
Updated over a week ago

If you have existing Market and/or Contract rate lists which you would like to upload and use, you can upload them to our system via your Airline Account or by using this Link (https://www.cargoai.co/market-rate-upload/)

Pls follow hereunder steps to create the require rates sheet for upload.

A. Rate template (IMPORTANT)

To ensure that your uploaded rate files can be integrated quickly, it needs to have the following format:

The fields are (respectively):

  1. Airline (2 letter airline code)

  2. Origin (3 letter IATA Code)

  3. Destination (3 letter IATA Code)

  4. Commodities MUST have the EXACT spelling as shown :
    General Cargo / Perishable / Dangerous Goods / Live Animals / Pharmaceuticals / Valuables, Express, Human Remains
    (AVI, DGR, DGX, PER/FRESH, GCR, HUM/LHO, PHARM, VAL/VUN, XPS, etc.)

  5. Start Date (input in format DDMTHYR, e.g. 01JAN23)

  6. End Date (input in format DDMTHYR, e.g. 31MAR23)

  7. Fuel Surcharge

  8. Security Surcharge

  9. M = Minimum

  10. N = Normal

  11. 45 + kg

  12. 100.0 + kg

  13. 300.0 + kg

  14. 500.0 + kg

  15. 1000.0 + kg

  16. 3000.0 + kg

  17. Currency

  18. Status - leave this blank

  19. **IATA CASS (11 numbers; e.g. 1234567-1234)
    (IATA CASS is required only for CONTRACT rates. Just ADD a column at the end and input the IATA CASS - not shown in above picture)

  20. MSC (or miscellaneous charges)

Note that:

  • Normal = 0 to 45 kg

  • Commodity = Product Type

Do not type any words within the rates section between columns M to 3000kg (example circled in white in hereunder screenshot example):


If the Market/Contract rate files being uploaded are not in the above format, it will take a while before they can be integrated on our platform for your use.
We do apologize for the delay.

B. Market rates

RENAME your Market rate file/s by adding "Market" in front of filename.

Select the 'rates' menu at the top of the screen and upload the file/s using the PDF/XLSX box.


C. Contract rates

Rename your Contract rate file/s by adding "Contract" in front of filename.

Ensure you ADD your **IATA CASS in the table/rate list.

Select the 'rates' menu at the top of the screen and upload the file/s using the PDF/XLSX box.

IMPORTANT: The rates data being uploaded needs to be in PDF/XLSX format

D. UPLOADING MARKET & CONTRACT RATES via your Airline Account

Login to your Airline Account

Select RATES from the pull-down menu

Select UPLOAD PDF/XLSX

Select BROWSE FILES

Navigate to the location of your rate file and select it

You should see your rate sheet file name (please see hereunder example)

Select UPLOAD

To ensure that your uploaded rate files can be integrated quickly, it would be good to have them formatted as shown in point A above.

E. Upload Rates and Terms & Conditions

Upload the rates to our system by using this Link (https://www.cargoai.co/market-rate-upload/)

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.

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?