Bulk Import Tracking information on Sellercloud via Excel or CSV

Last Updated on January 28, 2020 by

In this article, we will discuss how to upload tracking information on Sellercloud using Excel or CSV feed files in bulk.

Order Management is one of the important feature of Sellercloud. If we use Sellercloud we must need to import tracking information to Sellercloud so that information will import to Marketplace through Sellercloud. SellerCloud offers a template that can be used to import the tracking information. Let’s see how we can upload Tracking Information on SellerCloud. We can obtain a Tracking information file from FedEx or anywhere else. You need to update the Tracking information on SellerCloud in four steps.

  1. Exporting Unshipped Orders from SellerCloud
  2. Collecting Tracking Information from FedEx
  3. Processing Tracking Information
  4. Importing Tracking Information into SellerCloud  

1) Exporting Unshipped Orders from SellerCloud: 

To download or export order from Sellercloud, we need to go to Order tab on Sellerclod

Click on Advanced Search.

Filter with the following parameters according to your requirement like below

  • DateRange: Last 120 Days
  • OrderStatus: InProcess
  • Exported: Exported
  • PaymentStatus: Charged or Partial Refund
  • ShippingStatus: Unshipped
  • Confirmed: Confirmed

Click on the Search button.

The next page will seem. Check the select all pages’ box at the right corner and click on the Excel export Symbol.

Confirmation required to Export. Select the Format General and File Type Excel, you can choose the file type according to your preferred type. The order number column is only required from this Order Export file.

Note: Do not mark orders as exported, make sure the checkbox is unchecked.

To download the file click on the Output file.It will take several minutes

2) Collecting Tracking Information from Shipping Carrier:

If you have tracking information in a file then you can upload that file into SellerCloud. Here we are collecting the tracking Information from FedEx as we use this Shipping Carrier to ship our products. But you can have the information from any place. To collect Tracking Information from FedEx, you need to log into FedEx. After logging into FedEx, you will find a Customized Views button at the upper right corner.

Click on the Customized Views button and then click on the Company’s name.

Click on Download Results and then the Submit button.

A CSV file will be downloaded, open the downloaded document with excel.

3) Processing Tracking Information

Open the Order Export file, that you have downloaded from SellerCloud. Copy Order Numbers (First Column).

Paste Order Numbers into the PO# Column on the FedEx sheet. 

Apply conditional formatting, Highlight Cells Rules.

Click on Duplicate Values. Leave it with the default setting of “Light Red Fill with Dark Red Text”.

Filter for duplicate PO#s. This will pull up tracking information that needs to be imported into SC. 

4) Importing Tracking Information into SellerCloud

Go to SellerCloud, hover over Orders and click on Import Tracking Info

Click on Download Sample to download the template.

Copy and paste the data from the FedEx Sheet into the Import Tracking file. Columns that need to be populated are:

Order-ID (PO#), Ship-Date, Carrier-Name, Ship-Method, and Tracking-Number. Leave all other columns blank.

Save the file and Upload it into SellerCloud. Select the Company name from the dropdown and select the Plugin Default. Choose the file and click on Import Tracking Details.

Monitor the Job within a few minutes you find the job is complete.

We hope this article will help you to import Tracking information on Sellercloud via Excel or CSV. If you need any assistance, please feel free to ask. We are here to assist you.

Leave a Comment

BLOG CATEGORIES

BOOK FOR FREE CONSULTATION

Sign Up For Our Newsletter

Keep yourself updated with latest trends to maximize revenues across all of your sales channels.

POPULAR TAGS

What Clients Say About Us?

Wow, their team has been great! I have been working with freelancers and remote marketing agencies for about a decade and they are among the best.

Isaac Curtiss

Office Furniture Outlet INC.

Helped overcome difficult tasks that would have taken us a lot of time. We do recommend their services!

Blake Tanner

Tanner International INC.

I’ve been working with Fred and his team for the past few months and have been very happy with their work.

Dan Hawkins

Mixles Limited

Great help/addition to our business. All tasks are fully completed in a timely manner.

Maurice Embry

Sam Tucker LLC

Used for years now and wil continue to use for many more years. I also have no doubt recommending friends and colleagues to use too.

Nathan Reeves

Xenons Online Limited

Our company has worked with Ecomclips for over a year now. I’ve found the team to be very flexible, easy to coach, and adaptable. You won’t regret working with them.

Abraham Kwan

PG Incorporation

The team at Ecomclips has served all my needs with excellence. They are very attentive to my requirements. Communication is fast and crystal clear. I definitely recommend them.

PR

Right Parts Group INC.

So far I have hired Freddy and his team has been excellent, they are guiding me as grow my business. I will continue to work with them.

Bev Matushewski

FiTTeck INC.

Excellent friendly prompt service

Ahmedani

Ahmedani Canada INC.

We’ve been working with Ecomclips for a couple of years now and we are more than happy and appreciative of the their service. Definitely recommend.

Michael Burnley

Zooshoo INC.

A+++ Perfect!!

Imran Hassam

Amedeo Apparels Limited

RECENT BLOG POSTS

Bulk search by a list of multiple SKUs on Sellercloud from Excel

In this documentation, we will show you how we can search multiple SKUs on SellerCloud at

Read More

Step by Step Process of Creating Manual PPC Campaign on Walmart

In this article, we will show the complete process of how to run Walmart Manual Sponsored

Read More

How to Upload variation product on Shopify from Ecomdash

In this article we will discuss how to add variation product on Shopify using Ecomdash. Wh

Read More