I have a bit of a complex question, I want to apply three Catalog price rules to a category with products that are in multiple categories, however the three rules are different percentages off 15%, 20% and 30%. Since Magento applies the rule on a product level not the category it keeps applying the rule on all the categories the product is in and not the one category I want it to. Is there a way around this?
tl;dr Apply multiple catalog price rules too a single category with products that are in multiple categories.