Database Script: Apply a Membership Level to All Users Without a Level

This advanced code recipe contains a SQL script to run against your WordPress site’s database. You can use Adminer, phpMyAdmin, or your host’s MySQL management tool of choice to execute the query.

The script will apply a membership level (by ID) and expiration (optional) to all users in the wp_users table that do not already have a membership level. This is useful for sites that already have a large number of “users” that you would like to be placed into a default membership level or a grandfathered-in membership level from an older system.

The Code Recipe

	#give all non-member WP users level 1 with a specific start and end date set
	#change the level (1) below and start (2017-01-01) and end (2017-12-31) dates below to per your needs
	INSERT INTO wp_pmpro_memberships_users (user_id, membership_id, status, startdate, enddate)
	SELECT
	u.ID, #ID from wp_users table
	1, #id of the level to give users
	'active', #status to give users
	'2017-01-01', #start date in YYYY-MM-DD format
	'2017-12-31' #end date in YYYY-MM-DD format, use '' for auto-recurring/no end date
	FROM wp_users u
	LEFT JOIN wp_pmpro_memberships_users mu
	ON u.ID = mu.user_id
	AND status = 'active'
	WHERE mu.id IS NULL

view raw insert_members.sql hosted with ❤ by GitHub

Adding the Recipe to Your Website

You can add this recipe to your site by creating a custom plugin or using the Code Snippets plugin available for free in the WordPress repository. Read this companion article for step-by-step directions on either method.

Update line 3 and line 10 if you are using a database prefix other than the default ‘wp_’.

Update line 6 with your membership level ID.

Update line 8 and line 9 with the membership level start (any date in the past or today) and end dates respectively. The format for these values is YYYY-MM-DD.

For membership with no expiration date, change the second date on line 9 to just ” or NULL.