OpenTrack allows you to upload containers via Master Bill of Lading through your account dashboard. But what if you want to add multiple containers using a spreadsheet?

In this guide, we will review how you can easily add multiple containers to your account along with the ability to add additional fields.

In order to bulk upload containers, please navigate to the Bulk Upload screen from the Start Tracking page.

In order to bulk upload containers, OpenTrack requires three columns: Master Bill, Container ID, and Carrier SCAC Code.

Good:

Please note that all three values must be present for the bulk upload to work for that container. Here is an example of an upload that would be invalid:

Important: In the example above, the first row would upload successfully but the second row would not. You'll receive a message upon uploading your container letting you know which rows did not successfully upload and why.

Please note: If any of these Master Bills or containers already exist in your account, they won't be added.

Once you've formatted your spreadsheet, select your file using the upload widget. Simple click upload, select your file, and view your results in the Start Tracking page.

Important: Once you have selected a file, remember to click on the upload icon!

Ocean Carrier Master Bill of Lading (MBL): The ocean carrier master bill of lading is required for successful tracking. When an MBL is added for tracking, the OpenTrack system validates this value against several rules to prevent bad input:

Container ID: A container added for tracking must conform to the ISO 6346 standard.