How to Track Shipments Via Email

Add shipments to your Terminal49 account by sending us an email with a list of shipments in a CSV attachment

Akshay Dodeja avatar
Written by Akshay Dodeja
Updated over a week ago

In addition to adding your shipments via Terminal49's Dashboard or API, you can add shipments to your account by sending an email to [email protected]. The email must include an attachment (CSV or Excel) with a list of your shipments.

You can use this functionality to automate shipment tracking on Terminal49 by sending a periodic report generated by your software. Many software systems (ERP/TMS/homegrown) support the ability to send a daily reports via email.

Setting it up is easy:

  1. Create a CSV or Excel file (formatted with the column headers in this CSV template) and enter your shipments

  2. Draft a new email to [email protected] and attach the file

  3. Make sure the sender is set up as a user on your account on Terminal49. You can do that in the Account Settings.

  4. Send email!

  5. Wait for confirmation email that your files have been processed (you should receive this within a few minutes)

What happens next?

Once we receive the email, Terminal49 will automatically parse the attachment, add these shipments to your account, and attempt to start tracking all the shipments and their containers. If there is an issue with the file, we will send you a follow-up email with a list of the issues.

Requirements:

  1. Make sure the sender is setup as a user in your Account on Terminal49.

  2. The first row of the spreadsheet must have the following headers (see table 1).

Table 1: Spreadsheet attachment column headers (CSV or Excel)

Column header

Required

Notes

shipment_number

Required

Master Bill of Lading or Booking number.

shipping_line_scac

Required

Ocean Carrier SCAC or name.

reference_numbers

optional

Internal reference numbers (comma seperated), i.e.: PO12345678, IO-ABC5678

shipment_tags

optional

Shipment labels and/or tags (comma separated), i.e.: Hot, Urgent, Warehouse-New Jersey, ProductName, ProductSKU

customer

optional

Customer Name

Support for custom spreadsheet column headers

We understand that you might not be able to format your spreadsheet with Terminal49's required column headers. You might have container-level rows or multiple reference numbers or tags that need to be collapsed into a single column. We can provide support for custom column headers to automatically parse the attachments you send us - please email [email protected] with your requirements and we can customize this workflow for your account.

Go to this page to see different ways of initiating shipment tracking on Terminal49.

Did this answer your question?