Ability to assign a pricing rule to a user

[thisisjamessmith]

Whilst it's already possible to assign an individual user to a pricing rule, you can't do it the other way around - in other words, when on a user profile edit screen, I'd like to be able to directly assign/relate them to a pricing rule. The problem with assigning users on each pricing rule page is one of scalability - with a potentially unlimited number of users needing to be assigned to a particular rule, the UI will become unwieldy.

I'm planning on working around this limitation by having a section of "Sales" entries which will effectively duplicate each pricing rule, and then create a regular Entries relationship field against the users to relate them to those Sales entries, and then use the pricing rules' "Related To" condition to tie everything together. This seems like a lot of convoluted work for an editor though, so I was wondering if anyone has any other thoughts about approaches here?

The current Craft 4 site from which I'm upgrading uses User Groups to achieve this functionality, but it's a nightmare for the editors, not least because creating User Groups requires them to be super admins, and they have a lot of pricing rules (think e.g. "41% Discount", "22% Discount", "33% Discount but only on a certain product category" etc etc.

[sjcallender]

Glad you posted this. This is an issue for sure. We've worked around it for now as you've described with the Related To using an entries section. The current catalog pricing hits limits quickly on multiple fronts and needs to new attention to rethink it. We have a situation where pricing rules per account are managed in an external ERP and we need to programmatically recreate them in Commerce. That becomes quite the gymnastics in the current model.