Overview:

Below is the process that any user (customer or supplier) with access to the Leverage portal can follow to upload ASN (Advanced Shipment Notice) data in bulk across multiple purchase orders. This allows you to submit shipment, package, tracking, weight, and dimension data in a single CSV upload, linked down to the purchase order and PO line.

Steps to Upload ASN Data to Leverage:

1. You must be logged in to the Leverage portal

2. In the bottom left of the screen, click your user icon to pull up your user menu and select IMPORT DATA

3. The Manual File Upload screen will populate with a File Type drop down to select the bulk action you would like to take

There are also two tabs at the top, the second of which is labeled History. This shows all prior file uploads and their upload status (success/error)

4. Under the UPLOAD tab, select ASN (Advanced Shipment Notice) from the File Type dropdown:

5. The screen will adjust based on the file type selection with all the instructions and the template required to successfully upload ASN data to Leverage:

6. You can download a copy of the Leverage ASN upload template (leverage_sample_asn.csv) directly from the Import Data page under Instructions:

7. Please confirm prior to upload that:

The file is in CSV format
You've selected the correct CSV Date Format that matches your file
You've selected the correct Target Integration
All required columns for all rows have data
Column header names match the template exactly, and are in the same order

8. Once the above are all correct, and the file is attached, click IMPORT DATA

9. You will receive an email confirming the status of the upload (success/error). If there are errors, the email will outline where they were so you can resolve and re-upload

You can also review the file status on the HISTORY tab of the Manual Import page

Understanding the ASN Template

The ASN CSV behaves differently from other bulk upload templates because a single ASN can include multiple line items and multiple packages. Two columns control how rows are grouped:

shipment_id_number — Rows that share the same shipment_id_number become one ASN. Every line item on a single shipment should share the same value in this column.
package_index — Use this to split items into multiple packages within the same shipment. If left blank, it defaults to 1 (one package per ASN). Use different values (e.g. 1, 2, 3) to break items into separate packages.

Header fields (shipment date, carrier, tracking, weight, dimensions, etc.) are taken from the first row in each shipment_id_number group.

Examples:

One ASN with three line items = three rows sharing the same shipment_id_number
One ASN with two packages = rows split by package_index (1 and 2)

Available Fields

The CSV template includes the columns below, in this exact order. The in-app Required Columns section on the Import Data screen indicates which fields must have a value in every row.

shipment_id_number
package_index
po
po_line
quantity
shipment_date
expected_delivery_date
transportation_method
tracking_type
tracking_number
carrier
additional_reference_number
asn_ext_id
packaging_code
container_reference
package_lading_quantity
weight
weight_unit
weight_qualifier
volume
volume_unit
length
width
height
dimension_uom

Need Additional Help?

If you encounter any issues during this process, contact our support team via our Help Desk or email us at support@tryleverage.ai.

Bulk Upload ASNs (Advanced Shipment Notices)