I am new to magento . I want to add catalog price rule to have different discounts for different categories . Currently i can select one or multiple categories from conditions tab and then enter discount amount but that will be only for those specific categories and for rest there will be no discount .
I found out that on adding catalog rule it calculates and saves all product prices under selected category to 'catalogrule_product_price' table .
I want to have discount say 15% for category id 4 and 20% for rest . How can i achieve that .