This is not a problem, just a question/suggestion.

Is there a way of moving a member from one plan to another that does not involve 'upgrade to another plan'. I know I can do it by changing the database directly via Paid Subscriptions/Subscriptions, but our administrators are reluctant to do it this way (mainly because I've put the fear of God into them of what can happen if they mess around with things they don't understand!).

For example, we have two membership plans which are identical in every respect, except that one is free. This is a concession to a member who takes on a formal (volunteer and unpaid) role in running the non-profit Club for the duration of their service in that role. Changing them from the paid to the free plan using the 'upgrade this plan' route also changes the subscription date and renewal date, which means that I have to change these back directly on the database. Obviously, when they leave the role the same thing happens because they revert to the paid plan.

We have no need for the additional subscription records that result each time this happens either, as it's basically just an edit to the plan_id of the comprofiler record.

Despite my decades in IT software design and development this is not something with which I am comfortable - it's not my system, and there can be unforeseen consequences to this kind of interference.

So it's just a question/suggestion, and I'd appreciate your comments.

Thank you

You have understood the basic need exactly - just a change of plan (and therefore the rate), nothing else changes at that point. The waiving of the subscription is for people who are elected to the position of committee member. Their election and commencement of duties are very unlikely to coincide with their renewal date, so they will have paid for the current year by the time they are elected. Subs are waived for as long as they stay on the committee, so their next renewal (and probably some subsequent ones as well) is free. Similarly, when they leave the committee they are part way through their subscription year and it is not until the following renewal date that subs are payable again.

It might seem a bit of a strange way of doing it, but it minimises mistakes and simplifies administration - in the original paper-based system the current committee members didn't pay subs when their renewal came due, it was as simple as that.

We have another situation where this 'sideways move of plan' also applies but that has more to do with credit control and restriction of membership benefits, both of which are beyond the scope of CBSubs. However, which plan a member has does inform the actions taken.

I need to keep this simple for the users - I won't always be here or available to fix things.

I appreciate your giving this your time, and if you say 'not possible right now' that's fine

Thank you

It's a concept worth trying out on my test system and it's certainly a mechanism that would fit the bill perfectly in other situations that could arise.

Thank you for the suggestion. We don't use Promotions at present, so it would never have occurred to me.

Thanks you for your time and your help.