/** * Bulk update all users to have an expiration date that belong to a specific membership level. * This code should be run directly inside your WordPress database. * Please update the wp_ prefix to match that of your database as well as the membership_id and enddate value (YYYY-MM-DD). * * IMPORTANT: Have a backup of your site before running this code. */ UPDATE wp_pmpro_memberships_users SET enddate = '2020-12-31 00:00:00' WHERE status = 'active' AND membership_id = 1;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter