Website Membership System Review & Improvement Plan
Updated 1-May-2026
1. Current Membership System – Issues Identified
The existing membership system, built using the Ultimate Member (UM) platform, has not met the operational needs of the Association. The key issues are outlined below:
a) Subscription Management Limitations
- The system does not support clean, automatic annual renewals.
- Memberships must be manually recreated or reissued each year.
- There is no reliable way to align memberships to a fixed annual period (1 January – 31 December).
- This creates confusion for members and increases administrative workload.
b) Administrative Complexity
- Managing members, renewals, and access requires multiple manual steps.
- The system is not intuitive for ongoing administration.
- Reporting and tracking active memberships is limited.
c) Security and Maintenance Concerns
- The system has been operating on a free version, which has restricted access to updates and enhancements.
- This has meant:
- Limited ability to address known vulnerabilities in a timely manner
- No access to premium support or security patches when required
- Over time, this introduces increased risk to the website and member data.
d) Integration Limitations
- The current setup does not integrate well with payment systems for recurring subscriptions.
- Newsletter and communication tools are not seamlessly connected to the membership database.
2. Proposed Solution – Paid Memberships Pro (PMPro)
To address these issues, it is proposed that the Association transitions to Paid Memberships Pro (PMPro), a purpose-built membership platform.
PMPro will provide:
a) Automated Membership Renewals
- True recurring subscriptions (annual billing)
- Members automatically renew without manual intervention
- Reduced administrative overhead
b) Fixed Membership Periods
- Memberships can be aligned to a standard annual cycle (e.g. 1 Jan – 31 Dec)
- Consistent experience for all members
c) Improved Security and Reliability
- Actively maintained platform with regular updates
- Access to supported upgrade paths
- Reduced exposure to vulnerabilities
d) Integrated Payment Processing
- Seamless integration with Stripe/PayPal
- Automated invoicing and payment tracking
e) Better Member Management
- Clear visibility of active, expired, and pending memberships
- Simplified reporting and administration tools
f) Newsletter Integration
- Clean integration with email/newsletter systems
- Ability to segment members and communicate more effectively
3. Planned Improvements & Actions
The following steps will be undertaken to implement and improve the system:
Phase 1 – Transition & Setup
- Install and configure Paid Memberships Pro
- Define membership structure (annual membership cycle)
- Configure payment gateway for recurring subscriptions
- Create new membership sign-up and renewal pages
- Test full membership lifecycle (join → payment → renewal)
Phase 2 – Migration & Clean-up
- Transition existing members into the new system
- Disable Ultimate Member membership functionality
- Remove redundant plugins and dependencies
- Ensure all legacy pages and links are updated
Phase 3 – User Experience Improvements
- Simplify the membership sign-up process
- Ensure mobile-friendly and easy-to-use forms
- Provide clear instructions for members joining or renewing
Phase 4 – Newsletter System Enhancement
- Implement a streamlined newsletter system (integrated with membership data)
- Ensure Carole Gale can:
- Easily create and send newsletters
- Select recipients (all members or specific groups)
- Manage subscriber lists without technical complexity
- Provide a simple, step-by-step guide for ongoing use
Phase 5 – Ongoing Management & Reliability
- Establish a regular update and maintenance routine
- Monitor membership activity and renewal rates
- Provide basic reporting to the Association as needed
4. Expected Outcomes
- Reduced administrative workload
- Improved member experience
- Reliable annual renewal process
- Stronger security and system stability
- Easier communication with members
- A system that is sustainable and manageable long-term
Membership System Migration & Data Preparation (Pre-Import)
Overview
A new membership data structure has been designed and prepared for migration from Ultimate Member (UM) to Paid Memberships Pro (PMPro).
This release focuses on data integrity, household structure, and future-proofing, ensuring a reliable and maintainable membership system before import.
Key Improvements
Household Membership Model (Redesigned)
Introduced a true household structure based on property (ESN)
Household members are now:
Linked via household_primary_email
Treated as a single membership unit
Eliminates previous reliance on discount codes
Intelligent Data Reconstruction
Rebuilt membership records using:
Master member list
ESN (property identifier)
Payment history
Automatically determined:
Household vs single memberships
Membership duration (1 year vs 2 year)
Membership status (active)
🏷 Membership Assignment Logic
Membership levels are now inferred consistently:
Household Memberships
1 Year → membership_id = 5
2 Year → membership_id = 6
Single Memberships
1 Year → membership_id = 3
2 Year → membership_id = 4
Membership Status & Expiry
Membership status set to active for all members paid through 2026
Membership end dates calculated using payment records:
Latest payment year determines expiry
Standardised to YYYY/12/31
Email Normalisation & Recovery
Resolved duplicate and missing email issues:
Shared emails split using ESN-based aliases
Missing emails generated using:
[ESN]@berowrawaters.org
[ESN].1 / .2 for multiple unknowns
Ensures all members have unique, valid identifiers
Payment Data Interpretation
Parsed mixed-format payment data (EFT, Stripe, Cash)
Derived:
Membership duration
Payment method (membership_gateway)
Standardised inconsistent historical records
Data Integrity Safeguards
Only members from the original master list were included
Any unmatched payment records were:
excluded from import
logged in a review report for validation
PMPro Compatibility Cleanup
Removed unsupported or unnecessary fields:
membership_billing_amount
membership_cycle_period
membership_initial_payment
Ensures full compatibility with PMPro’s level-based configuration
Deliverables
Import-ready PMPro CSV file
Separate review/report file for:
unmatched emails
data anomalies
Status
Data prepared but NOT yet imported
Final validation pending before production import
Next Steps
Review generated CSV and flagged records
Confirm household pairings where required
Perform test import (staging recommended)
Proceed with full production import
Summary
This work replaces a workaround-based membership system with a structured, scalable, and auditable model, significantly reducing risk of:
data inconsistency
household misalignment
manual errors