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
- Go to Orders > Tools > Import Order Info > Import Tracking.
- Download the template and populate its fields.
- Conditions:
- If OrderID is provided, then there is no need for Order-Source, Order-Source-Order-ID or PO-Number.
- If PO-Number is provided, then Order-ID, Order-Source or Order-Source-Order-ID aren’t needed.
- If both Order-ID and PO-Number are not available, then you will need both OrderSource and OrderSourceOrderID.
- In Sellercloud, return to the Import Tracking panel.
- Select Company > Click to upload file > Upload the saved template > Import.
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
- Go to Orders > Tools > Import Order Info > Import Tracking via Profile.
- Select a company, a profile, import a template file, and press Import.
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.
- Go to Orders > Tools > Import Order Info > Import Orders Via Plugins.
- Select a company and a plugin.
- 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.
- Click Import.
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.
- Go to Settings > Scheduled Tasks > Manage Scheduled Tasks.
- Click the plus icon at the lower-right corner to create a new scheduled task.
- Set the Task Type as Import Order Tracking.
- Fill in the other fields and click Create.
- Click on the notification to open the scheduled task.
- Click Edit and in the Import Options panel, select FTP.
- Enter FTP credentials.
- You can also select a Recurrence or use a custom Plugin.
- Save any changes.
Email POs for Dropshipped Orders
In Sellercloud, this feature lets you email POs to different vendors when orders are dropshipped.
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.
- If OrderID is provided, then there is no need for OrderSource or OrderSourceOrderID or PO#.
- If PO# is provided, then OrderID, OrderSource or OrderSourceOrderID aren’t needed.
- If both OrderID and PO# are not available, then you will need both OrderSource and OrderSourceOrderID.
- 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.
- Settings > Toolbox >Scheduled Tasks.
- Select Import Order Tracking.
- Assign name to task.
- Enter Start time.
- Set recurrence.
- Enter FTP info.
- If using a custom plugin, select it from drop-down.