Has anyone created criteria for List Manager that will allow you to exclude someone who has used a pricing rule from getting the pricing rule again?
Michele
That's a great idea, although timing is going to be tricky:
1) You'll need a mechanism for updating the list: it's not going to regenerate until some process operates on it.
2) When you come up with that mechanism, you'll need to be sure that you do not include people who have that price rule on one of their sub line items but have not yet completed their order.
Since list regeneration can be expensive, I'd be tempted to start with a manual list, and then add a stored procedure to LP_CUSTOMER_RANK that determines if a pricing rule has been used by that customer, and if so, add them. There you can pare down your queries to only look for a specific customer and also time limit the searches over orders (LP_CUSTOMER_RANK will fire, among other times, at the completion of an order, so you can limit to orders last updated within a few minutes) to minimize the process time.
Interesting...I was going the generate a list route, but this gives me food for thought as we're going to have a BUNCH of lists re-generating constantly to meet all of our rules.
In that case you'd probably want to add a System Table that matches a Pricing Rule with a List (and perhaps a ticket count? any other data points of interest?): that way you'd have an easy client configuration when pricing rules change, and also your stored procedure would be able to make the updates in one pass, rather than having a separate query/insert/update per pricing rule.
Oh, and one last thing: what this process would not handle easily (which a regenerated list might) would be refunds/exchanges that remove the pricing rule from the customer's ticket history. It would depend on how you expected it to behave in those circumstances, of course.