Bulk Upload shadow SKUs on Sellecloud via Excel or CSV file

Last Updated on April 3, 2021 by

In this article, we will show the complete process of how to import Shadow Products (SKUs) on SellerCloud using excel or CSV feed file in Bulk.

By the term of ‘Shadow’ anyone can easily assume what it can be. Shadow is always a reflection of another. Here in Sellercloud the concept is same. It is a  shadow of a real product – it’s inventory count is linked to an actual Product, but it can have its alternative product profile. By an example it will be easy to understand. Like most of the marketplace do not accept duplicate products where SKUs are the same, but sometimes we need to create one product in multiple ways with different information in the marketplace. For this type of issue sellercloud build a feature which will be the same product but with another existence as well as another unique ID (SKU) so that that can be listed as another unique listing on marketplace.

How does a Shadow Product work?

For example, an SKU may have one profile while the shadow SKU will have different Product ID, description, images, and title. This is an innovative and very useful method by which to list a product in alternative venues. Like Amazon and eBay only allow a single SKU to be listed once. Also, in Shopify, you can create the same SKU but SellerCloud will sync quantity for only one SKU. By creating a shadow SKU, or multiple shadows, the product can be listed in multiple categories, we can sync quantity to all similar items.

To do this we need to create an SKU first on SellerCloud and then we will assign the SKU under the original SKU as a shadow. That means quantity will sync from the original SKU.

We can create shadow SKUs in two ways- Manually and Bulk import. 

We have another article where we describe the process of how to create shadow SKUs manually.  You can visit here for more details – https://ecomclips.com/blog/create-shadow-products-sku-manually-on-sellercloud/

Today we will discuss how we can bulk import shadow SKUs on SellerCloud.

Bulk Import Shadow Product

You can create lots of shadows at a time by bulk import. This is very easy, just follow the below steps.

Step 1: Once logged into SellerCloud, you can see that on the top side of the screen SellerCloud features are grouped into categories that you can use. Click on “Manage Inventory” from “Inventory”.

Click on “Import Product Info” from the “Manage Inventory” page.

After choosing Import Product Info you need to choose “Import Shadows”.

Step 2: In this step, you need to download the template and after completing the fill-up template you will upload the file again here. At first “Download Template”. Select file type Excel.

Step 3: Open the downloaded excel file template. The template will look like this below picture.

Now you need to fill-up the template.

  • Put original SKUs under the ParentSKU column. 
  • Create a shadow SKU name and put it under the ShadowSKU column.

Note: You must carefully put the created shadow SKU name in the same row where the parent SKU exists.

Step 4: Upload the template once you completed and save the excel file. Select Company, File type as excel and Choose the created file.

After clicking Import Shadows, import has been scheduled you can monitor from here.

Step 5: Once the import is completed this will show status Completed. If any error message showing then download the output file, check and fix the issue and re-submit the file in the same procedure.

Search your newly created shadow product on Inventory.

Enter the product and this will show a message like Shadow of BD-2AW38-BKBL (parent SKU). 

You have successfully imported shadows SKU by bulk. You can create a huge amount of shadows at a time by bulk import on SellerCloud. This will save your time as well. If you need any further assistance, please let us know by commenting on the below section. We are always here to assist you.

Leave a Comment



Sign Up For Our Newsletter

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


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.


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 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


How to Update Sears Order Preparation Time/Lead Time/Handling Time

When a customer orders something online, s/he always wants to know when s/he will receive

Read More

How To Update Pricing in Bulk on Amazon and Walmart through ChannelAdv ..

For marketplaces like Amazon, Walmart and others, we can easily update the price through C

Read More

How to Integrate Marketplaces with ChannelAdvisor | ChannelAdvisor Int ..

ChannelAdvisor can help you to centralize the marketplace integrations that allow you to o

Read More