So here's the thing...we have a great site with some beautiful products but the time has come to give our potential clients a little incentive. We want to be able to offer a % discount on about half our products which are our area of focus. We don't want to offer a % discount on any of the others. So products 1-50 are to be discounted but not products 51-100.
We want to be able to offer two different % discounts dependent on the order value. So for example 10% on products 1-50 for orders over £500, and 20% on products 1-50 over £1000.
It seems that at present, we can EITHER offer a %discount on a selection of products (but without any option to take account of order value) OR we can offer a %discount allowing order value parameters (but only if selected on 1 product or all products).
Suggested solutions would be gratefully received.