How to bulk import shipping costs or tracking details

Kelly
Kelly
  • Updated

Introduction

If you have the need to bulk import tracking details and(or) shipping costs, Onport can support this action through multiple types of file. This is an easy way for you to ensure the tracking details and costs are always updated, when this action can't be performed automatically.

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

  1. Automatically import files via Google sheets/XML/API/FTP.
  2. Vendor manually imports files via their vendor portal.
  3. Upload the file in your Onport account, on behalf of the Vendor.

Disclaimers

In case you already sync tracking but need to import shipping costs, this feature can be used to only upload shipping costs in bulk.

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.

mceclip0.jpg

 

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

❗️When listing the order reference, do not at the "#".

 

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 

mceclip1.jpg

 

If you still have questions, feel free to open a ticket with our Support team.

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.