Video Tutorial for Bulk uploading shipments
For better understanding, you may also refer the steps as mentioned below -
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 “Download 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 “Click to upload” 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, click on the “Import data” button. You can see all the shipments from the Excel sheet uploaded on the platform.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article