Bulk Upload products through Excel
Rhitam Dutta avatar
Written by Rhitam Dutta
Updated over a week ago

Uploading and updating hundreds of products one-by-one can become a tedious and time-consuming task which is why QuickSell gives you an option to upload the products in bulk using Excel.



In this section:



Creating a new catalog using Excel

Before we upload the product information, we first need to upload all the product pictures.

To import products pictures-

1. Go to our web version (web.quicksell.co) and login to your account.

2. Create a new catalog by clicking on the + button and give the catalog a title

3. After giving the title, the product list screen will open up where you'll get three options to add products

4. Select File system -> select all the pictures you have to upload in this catalog.
When uploading the products, make sure that the image name is either the products' title or the SKU code (whichever is unique) and it exists in your excel file in the exact same format.

5. Once you've selected all the images, click on Open and a dialog box will appear wherein you can use the file name to auto-fill the product information by clicking on the Arrow marked in the screenshot below. If your image name is the SKU code of the product, then select SKU and likewise for the product title.

6. Click on the Upload products button and wait for a few seconds for the images to get uploaded.


After the images have been uploaded, we need to add the product details.


In case you already have an excel file ready with all the product information, here's how to upload it -

1. Click on the Edit button
2. Select Excel option from the Upload new products dialog
3. Open the file with the product information from the file system
4. Bulk import product modal will open up where you need to map the excel columns with QuickSell fields.
5. After mapping the desired fields, click on Next
6. The Product Identifier will open -here you need to choose whether the product identifier has to be the Product title or the SKU based on the information you had uploaded while adding the product pictures
7. Click on Upload now.


In case you do not have an excel file ready-

1. Click on the Share button and select Excel
2. An excel template will get downloaded


3. Enter all the relevant product information and save the file


4. Come back to QuickSell and open the desired catalog
5. Click on the Edit button
6. Select Excel option from the Upload new products dialog
7. Open the file with the product information from the file system
8. Bulk import product modal will open up where you need to map the excel columns with QuickSell fields.
9. After mapping the desired fields, click on Next
10. The Product Identifier will open -here you need to choose whether the product identifier has to be the Product title or the SKU based on the information you had uploaded while adding the product pictures
11. Click on Upload now




Updating an existing catalog using Excel

You can not only create new catalogs, but update an existing one as well through excel by following these simple steps.

To begin with, open web.quicksell.co on your desktop and login to your account.

1. Open the desired catalog and click on the Share button
2. Click on Excel to export the catalog in excel format


3. Once the excel is downloaded, open it and make the necessary changes
4. Save the changes
5. Go back to QuickSell and click on the Edit button
6. Select Add/ Remove
7. Select Excel option from the Upload new products dialog
7. Open the file with the product information from the file system
8. Bulk import product modal will open up where you need to map the excel columns with QuickSell fields.
9. After mapping the desired fields, click on Next
10. The Product Identifier will open -here you need to choose either SKU or Product title (whichever is unique for each product)
11. Click on Upload now.




Understanding the columns in the custom template downloaded from QuickSell

COLUMN

DESCRIPTION

Product image

Image of the product which you can refer to while updating the product details

Product name

Name of the product

SKU

A unique code for the product - Stock keeping unit/ tag number/ design code

Product price

MRP of the product

Discounted price

Price at which the product will be available to the customers after the discount

Sizes

Size variants available for the product

Colors

Color variants available for the product

Parent product SKU

Parent product SKU is used when you have variants of a product. It helps in identifying which variants belong to a single product

Tax type

Type of tax applicable on your products (For example - GST, VAT)

Tax percentage

Tax % you'll be charging on your products

Weight

Used for calculating the shipping cost to be charged on the products

Product description

Details and information about the product

Product picture URL

Publicly available URL for the picture

Available Quantity

Stock in hand/ inventory

Private notes

Personalized notes for each product which are not visible to your customers on the catalog

Set name

Name of the set/bundle of the product

Set Quantity

Number of units in a set

Sizes set quantity

Number of units in a set based on sizes

Colors set quantity

Number of units in a set based on colors

Tag 1

The sub-category under which the product falls



Adding Product Images to QuickSell from cloud storage URL like Google Drive, Dropbox

In case you have the product images stored in Google Drive, Dropbox, or any other cloud storage instead of having them on your device, you can simply add their downloadable links in excel and the images will be uploaded along with the rest of the product information.

How to add links-

  • If you're using QuickSell's template, you already have a column named Product Picture URL. In case you're using your own excel or have multiple images for a product, simply add a new column for the image links.

  • All the images for one product should be in a single row but each link has to be in a different cell



  • While importing the excel on QuickSell, map these columns with Product Picture URL




Applying Taxes on products


In order to apply a tax on your products, you will have to add two columns -
1. Tax type - Name of the tax (for example - GST, VAT, etc)
2. Tax Percentage - The tax percent that has to be applied (for example - 5%, 18%, etc)

Note: You can have a different tax profile for different products

Please do not add a % sign while adding the tax percentage.


Mapping while importing the excel file on QuickSell:




Adding product weight for shipping cost calculation


While adding a weight,

  • The value has to be in either Kilograms or Pounds.
    For example, if the weight of the product is 100 grams, the value to be entered is 0.1

  • Do not mention the weight units like gms or kgs




Adding Tags/ Sub-categories

The process of adding tags is very similar to adding product picture URLs.

If you're using QuickSell's template, you already have a column named Product Tags. In case you're using your own excel, simply add a new column for each sub-category.

  • All the tags for one product should be in a single row but each tag has to be in a different cell

  • Special characters and line breaks should be avoided







Did this answer your question?