Difficult to look for the right title ...
Customers (few thousand) are devided by pricelists (about 20), this works fine except for some divergent discounts that are needed.
Certain customers receive larger discounts on certain products, and there are no 2 customers with the exact same discounts. It would be a solution to make up a pricelist for every customer, but that is a huge job while ther are only a few variable discounts. On average about 10 products on a total of 3000 products that are listed on each pricelist require a divergent discount. Those 10 products are not the same for customer A and customer B, nor customer C.
Example:
Customer Abigail is entitled to "pricelist10" and gets a discount of 10% on all products. By purchasing product "X" she receives a 10% discount. However product "Y" is purchased a lot and a discount of 15% on this product should be received every time.
Customer John is also entitled to "pricelist10" and gets the same overall discount of 10%. By purchasing product "X" he receives a 10% discount. He does purchase product "Z" a lot and should receive a discount of 20% for this item every time.
Customer Amanda is also entitled to "pricelist10" and gets 10% discount on all products.
Customer James is entitled to "pricelist5" and gets 5% discount on all products.
Just try to use the Promotion program for those products. You can assign a particular percentage of discount if they are purchasing above a certain quantity.
@Balagopal, my examples weren't clear in the meaning of quantities. The divergent discounts we use are based on annual purchases by the client. For example a customer can purchase 60 pieces of a certain product in a single order, but this is their only purchase during a year. Another customer purchases 10 pieces, but has an order every two weeks.