Legacy How do I remove items purchased by usergroup the member is no longer a member of?

[William Longworth]

On my site, we have a VIP membership group. They are allowed to purchase more items than the registered group. However when their membership expires, they go back to the registered group, but the items which were meant for VIP only are still active. Is there a way to automatically remove items when there is a usergroup change? if not, is there an SQL command I can run to do this?

 

[Fillip H.]

There's no way to automatically remove items on usergroup change, no

You can manually remove the items from users via the Inventory - tbh I can't see a way of doing this any faster via SQL.

 

[William Longworth]

is this a feature you could include ? and when selecting items to remove from a user, could you code in some checkboxes so multiple items could be removed at once?

 

[Fillip H.]

I've changed this thread to a Feature Request