ok lets say ,
we are giving a discount (20%) to a certain Category so when we search for a product in the web the sticker should be 20% like "new" so the customer will know that this product has 20 discount if he buy it
if we can get the cart-rule name or the percentage of the discount to the sticker that will be great

thanks in advance

@rahul hi can you show me how to do this too

@rahul thank a lot bro it helped to get the % to the sale items

@vishalK thank you very much for the help
but what i need is i want to show the percentage discount when we apply a promotion in cart-rule
the discount amount (20%)

i have all the updated version of bagisto
but unfortunately it takes huge time (more than 12s per page) to load a category page and i cannot find why is that http://test.sarasavi.lk/english/childrens

@rahul
can you please assist me hot show the percentage of the discount in the product badge
as shown in the image i want to show the percentage of the discount instead of "new"

can you help me to solve this matter

hello i am facing a problem after the launch of my web MySQL is query very slow
MySQL query taking huge time
with the two queries being used to fetch products

mysql cpu usge goes up to 1000%

@rahul
am sorry my mistake i have asked the question ina wrong way
this is the real problem

I was trying to show the cart rule percentage or the name on the product badge so that the coustomer can see the given promotion to the product but I couldn't

i want it to show on the product badge