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
In your excel, add two columns -
- Set name: add the name of the set
- Set Quantity: number of pieces in that set
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
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,
enter the set name in the Sizes column
enter the parent product Sku
mention the set quantity in the Sizes set quantity column
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,
enter the set name in the Colors column
enter the parent product Sku
mention the set quantity in the Colors set quantity column
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,
enter the set name in the Flavors column
enter the parent product Sku
mention the set quantity in the Flavors set quantity column
Price and available quantity of the variant should be entered as per set and not as per piece
Excel Format