Column Header

Description

How to fill the cell in the Excel Sheet?

GROUP_ID

Upon downloading, you will be provided with a unique ID consisting of a string of letters and numbers, which will be associated with the respective group name.

All existing GROUP_ID's can be determined by downloading pricings sheet from workplace

This field can be left blank, requiring no input of letters or numbers.

GROUP_NAME

Groups can be created within the workplace. When applying the rate to a particular group, it is essential that the group name directly corresponds with the applied rate.

Please refer to the following examples when filling out this field, allowing them to serve as helpful guidelines.

Example 1: Default (all rates are applied to a generic group called "Default". Every new user that is created a shop is included automatically to the default group unless you assign it to a different group).

Example 2: Nordic countries (if you have created a group called ‘Nordic countries’ specifically for customers located in these regions).

Example 3: Special Tariff (if you are offering a special rate to a specific group of customers, please fill the column with the name "Special Tariff").

TRANSSHIPMENT

This cell includes transshipment city along the route. Please note that transshipment details will not be reflected in the final quotation.

 Please refer to the following examples when filling out this field, allowing them to serve as helpful guidelines.

TRANSIT_TIME

This is corresponding transit time in days.

 Please refer to the following examples when filling out this field, allowing them to serve as helpful guidelines.

Note: This cell can also be left blank.

EFFECTIVE_DATE

Indicates the effective start date of the rate or the validity date.  

Please fill it in using a long date format. Applicable formats include YYYY-MM-DD, DD.MM.YYYY, DD-MM-YYYY

EXPIRATION_DATE

Indicates the expiration date or end date of the rate validity.

Please fill it in using a long date format. Applicable formats include YYYY-MM-DD, DD.MM.YYYY, DD-MM-YYYY

ORIGIN_LOCODE

(optional) Column indicates the United Nation's LOCODE for the respective hub

Examples include DEHAM, BEANR

DESTINATION_LOCODE

(optional) Column indicates the United Nation's LOCODE for the respective hub

Examples include CNSHA, USHOU

MOT

MOT (Mode of transportation) associated with the rates

Please use any of the following MOT that are supported by our system

I-e, Ocean, Air, Rail

CARRIER

Indicates the name of the shipping line, airline, or trains depending on the MOT (Mode of transport) being used.

Please refer to the following examples when filling out this field, allowing them to serve as helpful guidelines.

Note: Cell contents can also be left blank.

SERVICE_LEVEL

Indicates the option to distinguish the rates from other rates by selecting a specific service level.

Please refer to any of the following examples when filling out this field, allowing them to serve as helpful guidelines.

Option 1: Standard

Option 2: Priority

Note: This cell can also be left blank.

LOAD_TYPE

Indicates the categorization or classification of cargo or freight based on its characteristics and handling requirements

Please refer to any of the following examples when filling out this field, allowing them to serve as helpful guidelines.

Option 1: LCL

Option 2: FCL

Our system has the availability of these load types fcl_10, fcl_20, fcl_40, fcl_45, fcl_40_hq, fcl_45_hq, fcl_20_ot, fcl_40_ot, fcl_20_rf, fcl_40_rf 

RATE_BASIS

refers to the factors or criteria that are used to calculate the cost of shipping goods. It's the method or basis on which freight rates are determined. These factors can include things like the weight of the goods, the volume they occupy, the distance they need to travel, or the type and size of the shipping container. The rate basis helps determine how much you'll need to pay for shipping services based on these factors.

The pricing engine of the IMC platform is built off of many different rate calculations. All fees associated with making a quote have many different methods of measurement in which they should be applied. Here are the list of pricing rate basis, broken down per what rates are available per IMC template.

RANGE_MIN

Defines the lower bound of the range for which the rate is applicable.

Please refer to any of the following examples when filling out this field, allowing them to serve as helpful guidelines.

RANGE_MAX

Defines the upper bound of the range for which the rate is applicable.

Please refer to any of the following examples when filling out this field, allowing them to serve as helpful guidelines.

FEE_CODE

Indicates the fee code of the rate

Please refer to any of the following examples when filling out this field.

FEE_NAME

Indicates the fee name of the rate

Please refer to any of the following examples when filling out this field.

CURRENCY

Indicates currency in the three-letter acronym capitalized.

Please refer to any of the following examples when filling out this field.

FEE_MIN

Please refer to any of the following examples when filling out this field

Please refer to any of the following examples when filling out this field.

FEE

This indicates the tariff without the currency symbol

 Please refer to any of the following examples when filling out this field.

REMARKS

This column is for any text you wish to include with your fee. It is ONLY for free text -

Please refer to any of the following examples when filling out this field, remarks will be shown on the PDF.

Note: no pricing information stored in this column will be considered in the rate calculation. 

WM_RATIO

Here you can edit your WM Ratio for each fee.

The standard is 1000. If you have a special fee with a different WM ratio you can insert that ratio here. 

STACKABLE

"stackable" refers to the capability of goods or cargo to be safely stacked on top of one another during storage or transportation

Please refer to any of the following examples when filling out this field.

DANGEROUS

“dangerous” are substances or articles that possess inherent properties or characteristics that can pose a risk to health, safety, property, or the environment.

Please refer to any of the following examples when filling out this field.