how to setup customer group discounts with discount % depending on amount spent in a certain category

[KennethB.]

Is the following possible and if so how?

We have the following situation:

3 types/groups of customers:

- normal customers
- societies
- wholesale

and loads of products divided into 3 categories, each product belonging to either of the 3 categories:

- category 1
- category 2
- category 3

Now on paper our discount scheme for the societies and wholesale is roughly as follows:

Customer group 'societies':
spend less than 250 € (VAT included) on products of category 1 -> 0 % discount
spend between 250 and 500 € (VAT included) on products of category 1 -> 10 % discount
spend more than 500 € (VAT included) on products of category 1 -> 20 % discount

spend less then 150 € (VAT included) on products of category 2 -> 0 % discount
spend more than 150 € (VAT included) on products of category 3 -> 15 % discount

buy less than 25 pieces of product A in category 3 -> 10 € / each
buy more than 25 pieces of product A in category 3 -> 7,15 € / each
buy less than 25 pieces of product B in category 3 -> 13 € / each
buy more than 25 pieces of product B in category 3 -> 9,59 € / each

Customer group 'wholesale':
spend less than 350 € (VAT included) on products of category 1 -> 0 % discount
spend between 350 and 500 € (VAT included) on products of category 1 -> 15 % discount
spend more than 500 € (VAT included) on products of category 1 -> 25 % discount

spend less then 200 € (VAT included) on products of category 2 -> 0 % discount
spend more than 200 € (VAT included) on products of category 3 -> 21 % discount

buy less than 25 pieces of product A in category 3 -> 9 € / each
buy more than 25 pieces of product A in category 3 -> 6,25 € / each
buy less than 25 pieces of product B in category 3 -> 11,50 € / each
buy more than 25 pieces of product B in category 3 -> 10,33 € / each

The buy 'less than' or 'more than' for both groups I should be able to define as specific pricing on the product itself linking this specific price to the customer group and using the minimum order quantity, correct.

But how do I setup the % discount? 

Setting a single discount % in the customer group will not work since I have different discount for different product categories and the height of the discount is dictated by the amount spent within that category and there is only 1 discount field on that screen. 

I looked into discounts aka cart rules defined in the catalogue and there I can setup a discount %, link it to a specific customer group, define a minimum amount, link it to one or more categories etc, BUT I have different amount spent treshholds for different categories and the cart rule setup seems to restricted expecting same group, same amount, same percentage.

Does anyone have a suggestion? Is there a module that can tackle this (I looked for modules related to discounts but was not able to find a match)? 

Edited October 5, 2021 by KBruyninckx (see edit history)