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)?