Skip to main content

Creating a Custom Discount

Here you can specifically select the products or SKU on which you want to apply the discounts. Unlike basic discounts where the percentage value is fixed, custom discounts allow you to apply different discounts on the products or SKU.

Video: Creating Custom Discounts

Steps To Create A Custom Discount

Step 1: Enter the name of the discount along with its validity, i.e., the start date & time and end date & time. Next, select Custom Discount under Discount Type.

QG1

Figure 1: Custom Discount Name and Validity

Step 2: Download an Excel/CSV file and fill the details. There are 3 types of files, basis your requirements for custom discounts, you can download any of the following files.

QG1

Figure 2: Downloading Excel or CSV File

  • Download Products: This file contains all the products created in your company. It has columns such as Item code, Brand, Discount Type (Flat or Percentage), and Value. Applying a discount on the product (item-code) would ensure that all the sizes of the product will have the same discount.

    QG1

    Figure 3: Products File

note

If you select Discount Type as Flat, enter the new selling price in the Value column, i.e., enter 350 for getting ₹50 off on an MRP of ₹400. Whereas, if you select Discount Type as Percentage, enter the percentage value in the Value column, i.e., enter 10 for 10% off on the MRP.

  • Download SKUs: This file contains all the SKU created in your company, e.g. if a product is available in 3 sizes, all 3 SKU will be present in the file. An advantage of using an SKU file is, users can create separate discounts for different sizes of the product. It has columns such as Seller Identifier, Discount Type (Flat or Percentage), Value, Item Code, Brand, and Price to select from the available sizes and apply discount value accordingly. As the price may vary for each size, so can the discounts. QG1
    Figure 4: SKU File

note

It's mandatory to fill all the details in the downloaded file (especially Product and SKU file). You may remove the unnecessary rows if you aren't offering a discount on particular products/SKU rather than keeping any Excel/CSV field empty.

  • Download Sample: On downloading the sample file, you'll get two separate files - an empty Product file and an empty SKU file. Depending on your requirement, you may use any one of the files and manually specify the products/SKU on which you want to run a discount. The Product file contains columns such as Item Code, Brand, Discount Type (Flat or Percentage), and Value. On the other hand, the SKU file contains columns such as Seller Identifier, Discount Type, and Value.

    QG1

    Figure 5a: Sample Product File

    QG1

    Figure 5b: Sample SKU File

info

Upon clicking the Download Sample option, 2 files will be downloaded. Therefore, if your browser has multiple download/concurrent downloads disabled, you need to turn it ON.

Step 3: Upload the Excel/CSV file.

QG2

Figure 6a: Uploading Excel or CSV File

Once you upload the file, a pop-up will appear and it will display the content of the file. Close the pop-up after previewing.

QG2

Figure 6b: File Preview Pop-up

Step 4: (Mandatory) Choose the desired sales channels (websites and marketplaces) where you want the discount to be active.

Step 5: (Optional) You can choose one or more selling locations where the Products/SKU will be discounted. If you don't select any, the default option will be All, which means discounts will be applicable at all the selling locations of your company.

Step 6: (Optional) You can choose one or more delivery zones where the Products/SKU will be discounted. If you don't select any, the default option will be All, which means discounts will be applicable at all the delivery zones of your company.

QG2

Figure 7: Selecting Sales Channels

Step 7: Click Create at the top-right corner as shown below in fig. 8.

QG1

Figure 8: Active Discount

The uploaded file will be checked and validated by the system. If all the entries in the file are valid, a Custom Discount would be created successfully and it will be visible under the Active tab.

QG1

Figure 9: Active Discount


What if my uploaded file has mistakes or errors?

In case a field is missing or a value is incorrectly entered in the Excel/CSV file, the validation check at the time of discount creation would fail and you can use the Download errors file option to view the error(s). Then you may re-edit the original file, fix the error(s) and upload it again.

QG1

Figure 10: Failed Validation

QG2

Figure 11: List Of Errors