Importing Tracking for Orders and Dropship POs Overview

Click here for information on this function in Sellercloud’s original interface.
Importing tracking info

When dropshipping, a vendor will often send tracking information in a file. Sellercloud provides a template which can be used to import the tracking, provided that the vendor is willing to use that format. The tracking will import on the the customer order, not the PO that was auto generated by the dropshipped request, and will be uploaded to the order source with the next automatic feed. This import does not support multi-package orders. Tracking numbers can be updated to multiple packages on the Sellercloud interface. On the order, select Ship Items from Action Menu, then place the tracking number on each package and ship. Under Orders > Import Tracking Info > Select a format type > Download the sample template.

  1. If OrderID is provided, then there is no need for OrderSource or OrderSourceOrderID or PO#.
  2. If PO# is provided, then OrderID, OrderSource or OrderSourceOrderID aren’t needed.
  3. If both OrderID and PO# are not available, then you will need both OrderSource and OrderSourceOrderID.
Important Note: All column headers must be in the file whether or not the column is populated by any data.
  • Any standard date/time format is acceptable (e.g. 7/12/2013 4:45 PM / July 12 2013 4:45 PM)
  • The Carrier and Shipping method should match what is set on the order in Sellercloud
  • The Shipping Cost can be entered to make sure the P&L is correct on the order.
  • Warehouse Name can be entered to change the ShipFromWarehouse on the order, which determines which warehouse inventory is deducted from.
If the vendor has a different format, contact Sellercloud Support to create a custom Import Tracking Plugin.
Scheduling an automatic DropShip PO Tracking import
  1. Settings > Toolbox >Scheduled Tasks.
  2. Select Import Order Tracking.
  3. Assign name to task.
  4. Enter Start time.
  5. Set recurrence.
  6. Enter FTP info.
  7. If using a custom plugin, select it from drop-down.

Importing tracking info

When dropshipping, a vendor will often send tracking information in a file. Sellercloud provides a template which can be used to import the tracking, provided that the vendor is willing to use that format. The tracking information will import on the customer order, not the PO that was auto-generated by the dropshipped request, and will be uploaded to the channel with the next automatic feed.

 This import does not support multi-package orders. Tracking numbers can be updated to multiple packages on the Sellercloud interface. On the order, select Ship Items from Action Menu, then place the tracking number on each package and ship.
  1. Go to Orders > Tools > Import Order Info > Tracking Info. Download the template.
  2. Populate the following fields:Sellercloud orders import order info tracking excel template example
  3. Conditions:
    1. If OrderID is provided, then there is no need for OrderSource or OrderSourceOrderID or PO#.
    2. If PO# is provided, then  OrderID, OrderSource or OrderSourceOrderID aren’t needed.
    3. If both OrderID and PO# are not available, then you will need both OrderSource and OrderSourceOrderID.
  4. In Sellercloud, return to Import Order Info > Tracking Info.
  5. Select Company > Click to upload file > Import. All column headers must be in the file whether or not the column is populated by any data.   If the vendor has a different format, contact Sellercloud Support to create a custom Import Tracking Plugin.

Important Note: All column headers must be in the file whether or not the column is populated by any data.

COLUMN HEADER DESCRIPTION
Order-ID

Sellercloud order ID

Entering the Channel’s OrderID will result in an error
Order-Source

Channel name. For example, if the order is from Amazon, this column needs to be filled up with that name

Please note that if the channel is Shopify, BigCommerce, CommerceHub the order source is going to be Website
Order-Source-Order-ID

Channel order ID

If there are more than one channel order ID’s, enter the first one
PO-Number Only required if you want to link a PO 
Ship-Date

Date of shipping order

Must be in the mm/dd/yyyy format
Carrier-Name Carrier name
Ship-Method Chipping carrier service name
Tracking-Number Tracking number provided by the shipping carrier
Shipping-Cost Price for the shipping paid to the shipping carrier
Company-ID

Sellercloud company ID under which the order exists
Warehouse-Name Name of the Sellercloud warehouse that you would like inventory deducted from for this order
  • Any standard date/time format is acceptable (e.g. 7/12/2020 4:45 PM / July 12 2020 4:45 PM)
  • The Carrier and Shipping method should match what is set on the order in Sellercloud
  • The Shipping Cost can be entered to make sure the P&L is correct on the order.
  • Warehouse Name can be entered to change the ShipFromWarehouse on the order, which determines which warehouse inventory is deducted from.

Creating a scheduled task

If you want to regularly import order tracking information, you can create a scheduled task in Sellercloud. This will automate the import to run on a schedule of your choosing.

  1. Access Settings > Companies > Manage Scheduled Tasks.
  2. Select the plus icon.
  3. Set the Task Type as Import Order Tracking.
  4. Create a Task Name > Select the Company > Choose Start Time > Create.Sellercloud settings companies scheduled task import order tracking
  5. Clicking on the notification allows you to edit this scheduled task.
  6. Click Edit > Import Options > Import From > FTP.
  7. Enter FTP credentials.
  8. You can also select a Recurrence or use a custom Plugin.
  9. Save any changes.

Emailing POs for dropshipped orders

In Sellercloud, this feature lets you email POs to different vendors when orders are dropshipped. 

  1. Access your desired PO > Actions > Send PO via Email. sellercloud po actions send po via email
  2. In the General panel, fill out the required credentials. You can add attachments or choose a pre-existing email template. sellercloud po send po via email email credentials
  3. Enter your email into the Message panel > Send. 

 

Was this article helpful?

Yes No