Really extreme lot of discount variations - need urgent help!

[Abraka]

Hello everybody,

 

my problem is the overburdening method of discount rule creation at several parameters. Is there any faster way (modules, etc.) to create really lot of rules? Is it possible to prevent the accumulation of discounts? 

Here is the exact job I need to do at a bookstore:

 

Discount groups:

1. guests and normal members: 0% basic 

2. institutes: 10% basic

3. club members: 20% basic

 

Discount parameter one:

every year of publishing means n*10% discount:

1. 2013-2012: 10%

2. 2011-2010: 20%

 

and so on till the maximum 50% (it means 5 different types). But the 2. and 3. group (institutes/club members) basic discount shall NOT to add to these discounts, which means every group shall get the same (or if the basic is higher than that) discount percentage (i.e. if a book was published in 2011 it gives 20% discount to all three groups, and the club members don't get a total 40%!)

The main problem starts here:

 

Discount parameter two:

not every, just some book categories are discounted (total 8)

 

Discount parameter three:

not every, just some exact publishers are discounted (total 10).

 

 

So, now I would had to create

5*8*10 (every goup except the institutes and club members) + 4*8*10 (institutes) + 3*8*10 (club members) discount rule, which is insane and impossible to create manually without fails in an acceptable time.

Because it means 400 + 320 + 240 = 960 different discount rules!

It's easier to give discount item by item, which is unacceptable because a massive amount of books.

So have you any advise how to solve it?

I would love to have a simple way:
In one discount rule the AND and OR function together 

HELP please!

 

 

[Abraka]

The current system, as far as I know, works as the following (with the above mentioned criterias):

1. 10% discount if

1. publishing year: 2011
AND
2. publisher: XYZ

AND

3. category: non-fiction

 

OR
 

2. 10% discount if

1. publishing year: 2011
AND
2. publisher: XYZ

AND

3. category: yound adult 

OR

...
960. 50% discount if...


It simply couldn't be, would make the whole admin side a mess

What I (and anybody with the same problem) need:

1. 10% discount if
1.  Publishing year: 2011 OR 2010
AND
2. Publisher: XYZ OR ZYX OR YXZ OR ABC OR...
AND
3. Category: Young Adult OR Non-fiction OR Short stories OR...

OR

2. 20% discount if
1.  Publishing year: 2009 OR 2008
AND
2. Publisher: XYZ OR ZYX OR YXZ OR ABC OR...
AND
3. Category: Young Adult OR Non-fiction OR Short stories OR...
 

Than it would be say 7 or 8 cart rules. Instead of 960!

Technically I need a discount module where the OR could be implemented in the selected rule next to the AND.