Bulk Upload

Step 1 - To add shipments in bulk click on the “Bulk Upload” button on the screen.

Step 2 - A new dialogue box will pop up as shown below 

Step 3 - Click on the “Trackings Import Template” button to download the excel file. Once the template is downloaded, open the template and fill in the data as per your requirement. Note - Always download fresh bulk upload Excel template while using the "Tracking Bulk Upload".

Step 4 ­ - Fill the Excel template

Column A --> Mode (Mandatory): Select the type of mode for the shipment from the dropdown (Ocean or Air).

Column B -->Reference no. (Optional): Mention the reference name/no. for the shipment.

Column C --> Tracking Number (BL, Booking or Container Number) (Mandatory): Mention the tracking no. by the shipment can be tracked on the shipping line website.

Column D --> Carrier (Mandatory): Mention the shipping line/airline name of the shipment by which it will be transported.

[Note: If you are adding the ocean shipment using the HBL number, kindly add the name of the Freight Forwarder/NVOCC and not the shipping line]

Column E --> Container Numbers (Optional): Mention the container numbers.

Column F --> Factory Dispatch Date (Optional): The dispatch date of the shipment can be mentioned.

Column G --> POL: Name of the Port of Loading 

Column H --> POD: Name of the Port of Destination

Column I --> Star Marked/Piority 

Column J--> Team unique code (optional): If you have multiple teams for multiple locations, you can update the unique code in this column which will provide only the relevant data to the respective teams.

Column K --> Customer unique code (optional): If you have multiple consignees companies for multiple locations, you can update the code in this column which will display only their shipments on their dashboard.

Column L--> Carrier Code: Once you mention the carrier name, the carrier code will be automatically updated. Note: Do not make any changes in the cells of column L as it is a formulated column used for detecting if the user has added the correct carrier name in column D

Column M --> Share With: Team code of the team with which a particular shipment is supposed to be shared

Column N --> Vessel Name: For shipments where the carrier requires vessel name, the field will be highlighted and needs to be filled

Step 5  - Once you update the mandatory data in the excel sheet (Column A, C, and D), save the file on your PC and upload the same by clicking on the “BROWSE FILES” button to upload the file.

Step 6 – Once you upload the file, the system will check for any errors present in the file. If there is any error, the system will help you identify the errors. Once the errors are identified, you can rectify those errors and re-upload the file.

Step 7 – Once the file is completely error-free. You will see all the shipments from the Excel sheet uploaded on the platform.