When you access to most of the pages in Membership Pro backend, at the right, there is a menu called Tools which you might need to use in some special cases as explained below:
This tool is usually used when you update from old version of Membership Pro to new version but the update process was failure for some reasons (or when you import Membership Pro data from a different site - using an older version of Membership Pro than the current site). Access to this menu item will help updating database schema to latest version and make sure Membership Pro works properly on your site.
In case you could not access to Membership Pro for some reasons (because SQL error), the tool can be accessed directly via this URL https://domain.com/administrator/index.php?option=com_osmembership&task=update.update (of course https://domain.com/administrator needs to be replaced with administrator URL of your site)
Membership Pro stores all of it's URLs in database table called #__osmebership_urls. These urls are cached URLs, mean urls might still point to old resources in some special case (for example, when you imported Membership Pro data from a differnt site to this new site or you created a plan with same title in the past, then delete it for some reason and re-create a new plan with exactly same title/alias)
That's when you have to Purge URLs so that Membership Pro will re-create new URLs and point it to new resource. Access to Tools -> Purge URLs usually help solving these issue.
In case you could not access to Membership Pro for some reasons (because SQL error), the tool can be accessed directly via this URL https://domain.com/administrator/index.php?option=com_osmembership&task=tool.reset_urls (of course https://domain.com/administrator needs to be replaced with administrator URL of your site)
By default, Membership Pro only allow sorting and searching subscriptions for core fields (such as first_name, last_name, email....). If for you want to search for subscription records base on data of a custom field, you can use this tool
By default, Membership Pro only allows you to setup Price, Tax Rate...with 2 decimal number. If for some reasons, you want to setup price with more decimal number, use this tool. Just login to administrator area of your site and access to this URL
https://domain.com/administrator/index.php?option=com_osmembership&task=tool.alter_price_fields
(Replace https://domain.com/administrator/ with administrator URL of your site)
Sometime, you might want to trigger onMembershipActive for active subscriptions on your site (for example, you have active subscriptions and now want to assign them to certain user groups via Joomla Groups Plugins - you did not setup Joomla Groups plugin before)
For this, you can run this URL https://domain.com/administrator/index.php?option=com_osmembership&task=tool.trigger_active_event
The above URLs will trigger onMembershipActive event for all active subscriptions and run it for every plugins. If you want to limit it to process certain plugin only (for example, joomlagroups, mailchimp,acym,acymailing....), you can pass that plugin in the URL like https://domain.com/administrator/index.php?option=com_osmembership&task=tool.trigger_active_event&plugin=joomlagroups
Sometime, you might want to trigger onMembershipExpire for expired subscriptions on your site (for example, you have active subscriptions and now want to assign them to certain user groups via Joomla Groups Plugins - you did not setup Joomla Groups plugin before)
For this, you can run this URL https://domain.com/administrator/index.php?option=com_osmembership&task=tool.trigger_expired_event
The above URLs will trigger onMembershipExpire event for all active subscriptions and run it for every plugins. If you want to limit it to process certain plugin only (for example, joomlagroups, mailchimp,acym,acymailing....), you can pass that plugin in the URL like https://domain.com/administrator/index.php?option=com_osmembership&task=tool.trigger_expired_event&plugin=joomlagroups
Sometime, you might want to change price of your recurring subscription plan. Normally, when you change that price, that new price will only affect new subscriptions, existing subscriptions will still have old price. However, in some special cases, you would want existing subscriptions will use new price for next payment, too. For that, you will have to:
In most cases, you would only care about the amount users have to pay for each recurring payment (no tax, no discount amount, no payment processing fee...) and in that case, the URL will just be simple like this
https://domain.com/administrator/index.php?option=com_osmembership&task=tool.update_recurring_payment_amounts&plan_id=[ID_OF_PLAN]®ular_amount=[AMOUNT]
Note that:
https://domain.com/administrator/ needs to be replaced with administrator URL of your site [ID_OF_PLAN] needs to be replaced with ID of the subscription plan which is needs to change price [AMOUNT] needs to be replaced with the price/amount subscribers have to pay for each recurring payment
Membership Pro stores state data for each subscription uses state 2 code (2 characters length). If for some reasons (for example, the data is imported from CSV file), you have state data with full state name instead of state 2 code and want to correct it, you can use this tool:
https://domain.com/administrator/index.php?option=com_osmembership&task=tool.fix_state_2code_data
(Replace https://domain.com/administrator/ with administrato URL of your site)
On a multilingual website, specially when you have many languages installed, the system will need to add more fields to it's database tables to store data for these additional languages and could cause this Row size too large (> 8126) error. When it happens, you can follow the instructions below to get the issue sorted:
If invoice is enabled on your site, it will be generated for each paid subscription and stored on a folder on your server. If you want to have these PDF invoices deleted to save server space, you can use this tool.
If member card is enabled on your site, it will be generated and stored on a folder on your server. If you want to have these PDF member cards deleted to save server space, you can use this tool.