How to bulk import shipping costs or tracking details

  • Updated

If you have decided not to provide shipping labels to your vendors, one option is to import their tracking details via File to Onport. This is an easy way for you to have the information link up with the items in Onport.

You can import shipping files in one of the following four ways:

  1. Automatically import files via Google sheets/XML/API/FTP
  2. Have your vendor import files for you via their vendor portal
  3. Upload in Onport on behalf of the Vendor
  4. In case you already sync tracking but need to import shipping costs, this can be done too.

Step-by-Step Guide

1. Go to Contacts > Vendor name > Shipping Tab

2. Select the File type, and enter the URL or Endpoint of the file you want to import from. If using a CSV this can be uploaded by clicking "Upload tracking file" at the bottom.

  • FTP
  • API feed
  • Google Sheet
  • CSV Upload
  • Don’t import
  • XML file



3. Select Default or Custom mapping

*Here is a sample template with default mapping. If you need to add additional headers you will need to choose Custom Format.



4. Choose Shipping Endpoint grouping:

Order: This will mark the entire vendor order as shipped

Line item: This will allow you to mark certain SKUs or certain quantities of a SKU as shippedJetti_2021-12-03_at_12.09.58_PM.jpg

5. If using "Custom Mapping" you will need to map your headers. 

*Required headers

Order - Reference, Tracking number, Tracking Company

Lineitem - Reference, sku, quantity, Tracking number, Tracking Company



6. If using a CSV you or your vendor will need to upload the file each time.

Marketplace: Go to Contacts > Vendor Name > Shipping tab > Upload tracking file

Jetti 2021-12-08 at 11.54.16 PM

Vendor: Go to Vendor portal > Orders Tab > Upload Tracking file 



Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request



Please sign in to leave a comment.