Upload Bundle Product on Channel Advisor using Excel in Bulk

How to Bulk Import / Create Kit or Bundle Items in ChannelAdvisor Through CSV Feed

ChannelAdvisor is a great system to stand out from the competition and increasing store average order value. It can attract customer who is seeking those products

To create bundles, first, you should know the basics of ChannelAdvisor and bundle or kit.

Channel Advisor:

ChannelAdvisor is an eCommerce-based software solutions service. Significantly serving over 2800 customers worldwide. Serving big giants like Timex, Samsung, Dell, Under Armor etc. Universally ChannelAdvisor supports hundreds of e-commerce channels, such as eBay, Amazon etc. It provides amazing support for e-commerce companies around the world.

Bundle or Kit:

Product bundling is a method of offering two or more products for sale which can together serve a common purpose to the customer. Most of the time these items are a few related products that are often bought together by the customers. To save the hassle of the customer and give them a better service buyer bundles those items together. A bundle is also known as kit There are two main types of Bundle. They are –

  • Bundle
  • Bill of Materials “BOM”

For example, a gift shop sells a bundle product that includes various products like coffee maker, coffee mug, coffee filters, and a travel cap. They sell all of the components individually. But they offer a bundle also. That includes all the components together. As you can see all of these items are related and connected to a similar purpose.

Why Use Bundles

  • It allows you to create a new product that other sellers will not easily duplicate
  • Increase your average order value
  • Delivers simplicity and value to your customers
  • Customers satisfaction- many customers often prefer to get a certain type of items together. This also raises the level of customer satisfaction. It also proves that you know about the customer needs well so you have bundled them up. Customers are more comfortable to buy a well-made bundle.

Type of create Bundle items

We can create bundle items in 2 way. One is manually and other is via csv feed as a bulk.

Here we will discuss about creating bundle via csv feed as a bulk.

Say for example we want to create a bundle product for those following items.

Included: Bath Towel 24×48, Hand Towel 16×24, Face Wash Towel 12×12. Contour Rug 21×24 Bath Rug 21×32. Color: Lilac

We can create a parent image for those products. Example:

We need to set those products price. Example

  • Towel set price-  $20
  • Contour Rug – $10
  • Bath Rug-  10$

So, we can set the price for this bundle $20+$10+$10 = $40

Creating Process of Bundle:

Create an Excel file with those following columns as shown in image below

The Column headings are –

  • sku
  • Bundle Components
  • AUCTIONTITLE
  • Short Description
  • Feature1
  • Feature2
  • Feature3
  • Feature4
  • Feature5
  • Brand
  • SUPPLIERSKU
  • Distribution Center
  • Collection
  • Color
  • CATEGORYED
  • AMZITEMTYPE
  • UPC
  • Cost
  • Material
  • Image_1
  • Image_2
  • Image_3
  • Image_4
  • Size
  • Width
  • Length
  • Pattern
  • Weight
  • Supplier
  • Search Terms
  • Use
  • Care Instructions
  • Room

In Bundle Components column just only use those products SKU by using comma (,) Example

After filling up all the required information in the Excel file completely, save the file. Then we will upload the file in ChannelAdvisor. The steps are described below –   

Step 1:  Goto ChannelAdvisor then Click on Import a File under Products tab

Step 2: Select the feed file (Excel file)  under Select a File tab then click on Import

Note: Make sure your uploaded feed file is in CSV format and maximum allowed file size is 20MB. Larger files can be imported via FTP configurations on the Automated Imports page.

Final bundle product would look like https://www.amazon.com/dp/B07FLQHVN6?ref=myi_title_dp

Bundles Limitations:

  1. Up to 10 component items can be assigned per bundle. Every account (PID) can create up to 60,000 bundles.
  2. When a Bundle is active or live in a marketplace listing then you cannot add or delete component items of that bundle or change the number per bundle of existing component items. If you need to add or delete component items than you must first withdraw the listing.

I hope this documentation will be very helpful in creating Kit or Bundle items on Channel Advisor.

keep reading our blogs. We will bring many other important topics for ChannelAdvisor very soon.

For any queries, let us know in the comment box.

We are the professionals at Channel advisor Data Entry; our team is always here for your business support.

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

Integrate Responsive eBay Listing Template with Linnworks

As you are reading this article, so it is obvious that you are using Linnworks to manage y

Read More

Ecomdash new User Interface UI and system update overview

In this article, we will discuss about the newly released User Interface and system update

Read More

Integrate Responsive eBay Listing Template with Ecomdash

This tutorial will help you integrate eBay template inside Ecomdash, so any item you list

Read More