With a large number of products, creating sets of each product one by one can become a really time-consuming task.
QuickSell gives you an ability to create sets of the products in bulk through Excel


Learn how to:



Creating sets of products with no variants

  1. In your excel, add two columns -
    - Set name: add the name of the set
    - Set Quantity: number of pieces in that set

  2. In the price column, add the price of the entire set, not the price per piece. While importing the file, QuickSell will automatically divide the price with the set quantity

  3. The available quantity will also be the number of sets available instead of the total number of pieces


    Excel format

    Product detail screen

    Product Inventory screen

    Customer view



Creating sets of products with variants

In order to create Size sets,

  1. enter the set name in the Sizes column

  2. enter the parent product Sku

  3. mention the set quantity in the Sizes set quantity column

  4. Price and available quantity of the variant should be entered as per set and not as per piece

Excel format

Bulk import

Variant Inventory screen

Customer view



In order to create Color sets,

  1. enter the set name in the Colors column

  2. enter the parent product Sku

  3. mention the set quantity in the Colors set quantity column

  4. Price and available quantity of the variant should be entered as per set and not as per piece

    Excel format

Bulk import



For creating sets of a custom variant, taking flavors as an example,

  1. enter the set name in the Flavors column

  2. enter the parent product Sku

  3. mention the set quantity in the Flavors set quantity column

  4. Price and available quantity of the variant should be entered as per set and not as per piece

Excel Format




Did this answer your question?