Navigate to a users profile as a moderator then go through the subscribe process on their behalf and be sure to use the offline gateway when doing so. This will generate a normal and valid frontend invoice. There is no way to do this from backend at this time.

How can you find expired members from the front end lists when you can't even sort or filter members by their CBSubs subscription or if their CBSubs subscription has expired?

You can create a Userlist that has an Advanced Filter to reduce the list down to expired users. This is done with a custom query. Examples as follows.

Active Plans:
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'A' ) >= 1 )

Expired Plans:
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'X' ) >= 1 )

The first one displays a list of users with at least 1 active plan. The second displays a list of users with at least 1 expired plan. It can be extended further to be specific to a certain plain id, etc.. Review the _cbsubs_subscriptions table for its table structure.

You'd just add it to the query with an AND statement. So after that query you'd have the below for example.


So for example you could have the below.


The _users table is aliased as "u" and the _comprofiler table is aliased as "ue".