Skip to main content

Flat File Integration

Kargo can ingest a flat file of expected shipments and automatically create scheduled shipments to validate. This is our quickest, simplest integration path. We can accept files via email or Secure File Transfer Protocol (SFTP).

Once the file is processed, Kargo will update the database for the Shipments and Orders with the desired information, and we will create a scheduled shipment on the customer dashboard(example below)

scheduled shipments

As the shipment passes through Kargo towers, our system will validate the content against the order information.

Email

Email Kargo a shipment report as an attachment from a company email address. The sender email addresses and filename format need to be consistent. You can send the file manually, or automatically at any frequency that makes sense for your operations team.

SFTP

Kargo will provide a facility-specific username and server information for uploads.

Guidelines

  1. Aim to keep the file in a consistent format, with all columns present.
  2. The minimum required fields are:
    1. Shipment Number (the shipment ID in your WMS)
    2. Appointment Date
    3. Order Number
    4. An identifier for each order item ( e.g., SKU or LPN)
  3. The column names and values can be whatever they are set as in your WMS

Example

Download Flat File Integration