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.
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.
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.
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.
Figure 3: Products File
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.
Figure 4: SKU File
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.
Figure 5a: Sample Product File Figure 5b: Sample SKU File
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.
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.
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.
Step 7: Click Create at the top-right corner as shown below in fig. 8.
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.
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.