Dropship: Tracking Import for Orders and POs

Overview

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


Import Tracking Information

  1. Go to Orders > Tools > Import Order Info > Import Tracking.
  2. Download the template and populate its fields.The image shows the Download Template button.
  3. Conditions:
    1. If OrderID is provided, then there is no need for Order-SourceOrder-Source-Order-ID or PO-Number.
    2. If PO-Number is provided, then Order-IDOrder-Source or Order-Source-Order-ID aren’t needed.
    3. If both Order-ID and PO-Number are not available, then you will need both OrderSource and OrderSourceOrderID.
  4. In Sellercloud, return to the Import Tracking panel.
  5. Select Company > Click to upload file > Upload the saved template > Import.
All column headers must be in the file, whether or not the column is populated with data.

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.
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 that the P&L is correct on the order.
  • Warehouse Name can be entered to change the ShipFromWarehouse on the order, which determines the warehouse from which inventory will be deducted.

Import Tracking via Profile

  1. Go to Orders > Tools > Import Order Info > Import Tracking via Profile.
  2. Select a company, a profile, import a template file, and press Import.The image shows the import via profile option.

Import Tracking via Plugins

You can import orders based on the plugin they use. If the vendor has a different format, contact Sellercloud Support to create a custom Import Tracking Plugin.

  1. Go to Orders > Tools > Import Order Info > Import Orders Via Plugins.
  2. Select a company and a plugin.
  3. In the file field, upload a template format that corresponds to the plugin itself. If you are unsure about the template format, contact Sellercloud support.
  4. Click Import.The image shows the Import via Plugin option.

Create 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. Go to SettingsScheduled Tasks > Manage Scheduled Tasks.
  2. Click the plus icon at the lower-right corner to create a new scheduled task.
  3. Set the Task Type as Import Order Tracking.
  4. Fill in the other fields and click Create.The images shows the Create New Scheduled Task pop-up window.
  5. Click on the notification to open the scheduled task.
  6. Click Edit and in the Import Options panel, select FTP.
  7. Enter FTP credentials.
  8. You can also select a Recurrence or use a custom Plugin.
  9. Save any changes.

Email 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

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.

Was this article helpful?

Related Articles