Resetting MemberPress Data
MemberPress does not currently have 'reset' button that will erase all data found in MemberPress. However, if you need to reset the Subscriptions, Transactions, Members, and settings data you can run the following queries *:
Warning: This will delete all subscriptions, memberships, groups, rules, reminders, coupons, and transaction data as well as all settings in MemberPress. Your users WordPress accounts will remain in-tact - but they will no longer be seen as active members in MemberPress.
Note: your database may use a different prefix than "wp_" - if so you'll need to change all instances of "wp_" below to match your prefix before running these queries.
TRUNCATE TABLE wp_mepr_subscriptions; TRUNCATE TABLE wp_mepr_transactions; TRUNCATE TABLE wp_mepr_events; TRUNCATE TABLE wp_mepr_members; TRUNCATE TABLE wp_mepr_jobs; TRUNCATE TABLE wp_mepr_rule_access_conditions; TRUNCATE TABLE wp_mepr_tax_rates; TRUNCATE TABLE wp_mepr_tax_rate_locations;
Then, you can run the following (they MUST be run in this order):
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('memberpresscoupon','memberpressgroup','memberpressproduct','mp-reminder', 'memberpressrule')); DELETE FROM wp_posts WHERE post_type IN ('memberpresscoupon','memberpressgroup','memberpressproduct','mp-reminder', 'memberpressrule'); DELETE FROM wp_options WHERE option_name LIKE '%mepr%';
Also, you should run the following if you have the Corporate Accounts Add-on installed:
TRUNCATE TABLE wp_mepr_corporate_accounts;
*Please note that we will NOT run these for you on your site. If you are unsure how to run these queries, then please contact your host for help.