Where Does the MemberPress Plugin Store Membership Details in Your WordPress Database?
Understanding the MemberPress Database Structure
When you install the MemberPress plugin on your WordPress site, it creates a set of custom database tables to store all the membership-related data. These tables are prefixed with wp_mepr_
(where wp_
is your WordPress table prefix).
The MemberPress database structure consists of the following tables:
wp_mepr_jobs
: This table stores information about scheduled jobs or tasks that the plugin needs to perform, such as sending expiration notices or processing recurring payments.
wp_mepr_members
: This table stores the basic information about your members, such as their username, email address, and membership level.
wp_mepr_subscriptions
: This table stores the details of each member's subscription, including the start and end dates, the subscription plan, and the payment method.
wp_mepr_tax_rate_locations
: This table stores the tax rate locations that are used to calculate the appropriate sales tax for each transaction.
wp_mepr_tax_rates
: This table stores the actual tax rates that are applied to transactions.
wp_mepr_transactions
: This table stores the details of each transaction that has occurred on your site, such as the amount, the payment method, and the subscription that was purchased.
Let's take a closer look at each of these tables and understand how they store the membership data.
wp_mepr_jobs
The wp_mepr_jobs
table is used by the MemberPress plugin to schedule and manage various tasks, such as sending expiration notices, processing recurring payments, and more. Each row in this table represents a scheduled job, and the table stores information like the job ID, the job type, the job status, and the scheduled time for the job to run.
This table is important for ensuring that the membership-related tasks are executed at the appropriate times, and it can be useful for troubleshooting any issues with these tasks.
wp_mepr_members
The wp_mepr_members
table is the primary table for storing information about your members. Each row in this table represents a single member, and the table stores the following information:
user_id
: The ID of the WordPress user associated with the member.
email
: The email address of the member.
status
: The current status of the member (active, pending, inactive, etc.).
created_at
: The date and time when the member was created.
updated_at
: The date and time when the member's information was last updated.
last_active
: The date and time when the member was last active on the site.
signup_ip
: The IP address used by the member when they signed up.
signup_method
: The method used by the member to sign up (e.g., through a registration form, social login, etc.).
This table is essential for managing your membership base, as it provides a centralized location for storing all the member-related data.
wp_mepr_subscriptions
The wp_mepr_subscriptions
table stores information about the subscriptions that your members have purchased. Each row in this table represents a single subscription, and the table stores the following information:
id
: The unique identifier for the subscription.
user_id
: The ID of the WordPress user associated with the subscription.
product_id
: The ID of the membership product that the subscription is for.
gateway
: The payment gateway used to process the subscription.
subscr_id
: The unique identifier for the subscription provided by the payment gateway.
txn_type
: The type of transaction (e.g., new, renewal, trial).
status
: The current status of the subscription (active, suspended, cancelled, etc.).
created_at
: The date and time when the subscription was created.
start_date
: The date when the subscription began.
expire_date
: The date when the subscription is set to expire.
trial_start_date
: The start date of the subscription trial period, if applicable.
trial_end_date
: The end date of the subscription trial period, if applicable.
last_payment_date
: The date of the most recent payment for the subscription.
last_payment_amount
: The amount of the most recent payment for the subscription.
This table is crucial for tracking and managing your members' subscriptions, as it allows you to monitor the status, expiration dates, and payment history for each subscription.
wp_mepr_tax_rate_locations
The wp_mepr_tax_rate_locations
table stores the tax rate locations that are used to calculate the appropriate sales tax for each transaction. Each row in this table represents a single tax rate location, and the table stores the following information:
id
: The unique identifier for the tax rate location.
country
: The country associated with the tax rate location.
state
: The state or region associated with the tax rate location.
zip
: The zip or postal code associated with the tax rate location.
created_at
: The date and time when the tax rate location was created.
updated_at
: The date and time when the tax rate location was last updated.
This table is used in conjunction with the wp_mepr_tax_rates
table to determine the appropriate sales tax to apply to each transaction.
Get a Free AI Website Audit
Automatically identify UX and content issues affecting your conversion rates with Flowpoint's comprehensive AI-driven website audit.
wp_mepr_tax_rates
The wp_mepr_tax_rates
table stores the actual tax rates that are applied to transactions. Each row in this table represents a single tax rate, and the table stores the following information:
id
: The unique identifier for the tax rate.
label
: The label or name of the tax rate.
rate
: The percentage value of the tax rate.
shipping
: Indicates whether the tax rate applies to shipping charges.
created_at
: The date and time when the tax rate was created.
updated_at
: The date and time when the tax rate was last updated.
This table is used in conjunction with the wp_mepr_tax_rate_locations
table to determine the appropriate sales tax to apply to each transaction.
wp_mepr_transactions
The wp_mepr_transactions
table stores the details of each transaction that has occurred on your site. Each row in this table represents a single transaction, and the table stores the following information:
id
: The unique identifier for the transaction.
user_id
: The ID of the WordPress user associated with the transaction.
subscription_id
: The ID of the subscription associated with the transaction, if applicable.
product_id
: The ID of the membership product associated with the transaction.
amount
: The amount of the transaction.
currency
: The currency used for the transaction.
type
: The type of transaction (e.g., payment, refund, trial).
gateway
: The payment gateway used to process the transaction.
txn_id
: The unique identifier for the transaction provided by the payment gateway.
status
: The current status of the transaction (complete, pending, failed, etc.).
created_at
: The date and time when the transaction was created.
This table is essential for tracking and reporting on the financial aspects of your membership site, as it provides a detailed record of all the transactions that have occurred.
Integrating MemberPress with Your WordPress Site
Now that you understand the MemberPress database structure, let's discuss how you can integrate the plugin with your WordPress site.
When you install the MemberPress plugin, it automatically creates the necessary database tables and sets up the required infrastructure for managing your membership site. This includes creating custom post types, custom taxonomies, and various shortcodes and templates that you can use to build your membership pages and functionality.
To integrate MemberPress with your WordPress site, you'll need to follow these general steps:
- Install and Activate the MemberPress Plugin: Start by installing the MemberPress plugin from the WordPress Plugin Directory or by downloading the plugin from the MemberPress website.
- Configure the Plugin Settings: Once the plugin is installed, you'll need to configure the various settings, such as your payment gateway, membership levels, and access rules.
- Create Membership Pages: Use the MemberPress shortcodes and templates to create the necessary pages for your membership site, such as the registration page, login page, and member dashboard.
- Integrate MemberPress with Your Theme: Customize your WordPress theme to seamlessly integrate the MemberPress functionality and branding.
- Monitor and Manage Your Membership Data: Use the MemberPress dashboard and reporting tools to monitor your membership data, track transactions, and manage your members.
By following these steps, you can effectively integrate the MemberPress plugin with your WordPress site and start leveraging the powerful membership management features it provides.
In conclusion, the MemberPress plugin stores all the membership-related data in a set of custom database tables, each with a specific purpose. Understanding this database structure can help you better manage and maintain your membership site, as well as troubleshoot any issues that may arise. By properly integrating MemberPress with your WordPress site, you can create a robust and scalable membership platform that meets the needs of your users.
Flowpoint.ai can help you identify all the technical errors that are impacting conversion rates on your WordPress site and directly generate recommendations to fix them, including issues related to your membership plugin integration