Thanks Ben

So to confirm; If I create a new user role called Premium Vendor, use a plugin to copy the same properties across and assign that role Premium Vendor to a user, they can have all the functionality of Vendor but with whatever else I need it to do?

Hi Ben,

I wanted to follow up on this as its been a while.

Ok, so for me I have the following installed:
– WC Vendors
– WooCommerce
– WooCommerce Subscriptions
– WooCommerce Groups
– Groups
– User Role Editor
– Advanced Custom Fields

What I need to achieve:
The ability to run WC Vendors but also allow for subscriptions. Depending on the subscription type, depends what Custom Field(s) get displayed

The issue
ACF can assign custom fields to user roles, which is exactly what I need. However, WC Vendors needs the Vendor role and WooCommerce Subscription can apply other roles (usually defaults to Subscriber on active subscription and back to Customer if subscription expires). Therefore, I can’t go this method.

Possible solution
Can I state, I’m by no means a coder!!! So the below may not be acceptable but it seems to work (he says!!).

Ok, so I set up WC Vendors as I need it
I setup WooCommerce as I need it
I then setup WooCommerce Subscriptions but set both the active and inactive role to Vendor
I then setup ACF Fields and assigned them to the role Subscriber (yep, not Vendor otherwise it will always show)
Now, what I’ve done is setup Groups with a capability of basic (or whatever you need it to be) and added this to a group called basic
Created a subscription product which once purchased, adds the user to the user group basic

At the moment, if someone purchases a subscription, nothing will happen. So I’ve then created the following code which I’ve added to my themes function file:

###################################################
# Assign Second Role Depending on Subscription Group
###################################################

#Checking for Capabilities EXCLUDE administrator
if (current_user_can('administrator') || is_admin() ) {

} elseif ( current_user_can( 'basic' )) {	

#if ( current_user_can( 'basic' ) ) {

	#Test whether the current user belongs to a group
	#echo '<h1>The current user has basic capabilities</h1>'; #debug
		
	#global $wpdb;
	#Setup all the required variables
	$user_ID = get_current_user_id();
	$metakey = "capabilities";
	$set_default_role = 'a:1:{s:6:"vendor";b:1;}';
	$add_second_role = 'a:2:{s:6:"vendor";b:1;s:10:"subscriber";b:1;}';
	
	#Create a function to retrieve the umeta ID for the correct meta key/value based on a user ID
	function get_umeta_id_by_key( $user_ID, $meta_key ) {
		global $wpdb;
		$umeta_id = $wpdb->get_var( $wpdb->prepare("SELECT umeta_id FROM $wpdb->usermeta WHERE user_ID = %d AND meta_key = %s", $user_ID, $meta_key) );
		if( $umeta_id != '' )
		return (int) $umeta_id;
	
		return false;
	}
	
	#Assign the result as a variable to pass to our SQL
	$meta_id = get_umeta_id_by_key( $user_ID, $metakey );
	
	#Setup the UPDATE sql statement based on our variables
	$sql = $wpdb->prepare( " UPDATE $wpdb->usermeta SET meta_value = '$add_second_role' WHERE $wpdb->usermeta.umeta_id = %d ", $meta_id);
	
	function add_subscriber_role_queries( $sql ) {
		#Run the query
		global $wpdb;
		$wpdb->query($sql);	
		$wpdb->print_error();
		$wpdb->flush();
		/*
		echo '<code>';
			print_r( $sql ); # <code>print_r</code> the array data inside the 1st argument for testing/debugging
		echo '</code>';
		*/
	}
	#Add_action( $tag, $function_to_add, $priority, $accepted_args );
	add_action( 'add_subscriber_role', 'add_subscriber_role_queries', 10, 2 );
	
	#Use do_action as needs to run without any means of trigger (eg. post saved)
	do_action( 'add_subscriber_role', $sql);
	
} else {
	#Test whether the current user belongs to a group
	#echo '<h1>The current user doesn\'t have basic capabilities</h1>'; #debug
	#global $wpdb;
	#Setup all the required variables
	$user_ID = get_current_user_id();
	$metakey = "capabilities";
	$set_default_role = 'a:1:{s:6:"vendor";b:1;}';
	$add_second_role = 'a:2:{s:6:"vendor";b:1;s:10:"subscriber";b:1;}';
	
	#Create a function to retrieve the umeta ID for the correct meta key/value based on a user ID
	function get_umeta_id_by_key( $user_ID, $meta_key ) {
		global $wpdb;
		$umeta_id = $wpdb->get_var( $wpdb->prepare("SELECT umeta_id FROM $wpdb->usermeta WHERE user_ID = %d AND meta_key = %s", $user_ID, $meta_key) );
		if( $umeta_id != '' )
		return (int) $umeta_id;
	
		return false;
	}
	
	#Assign the result as a variable to pass to our SQL
	$meta_id = get_umeta_id_by_key( $user_ID, $metakey );
	
	#Setup the UPDATE sql statement based on our variables
	$sql = $wpdb->prepare( " UPDATE $wpdb->usermeta SET meta_value = '$set_default_role' WHERE $wpdb->usermeta.umeta_id = %d ", $meta_id);
	
	#Create the function to process the query
	function remove_subscriber_role_queries( $sql ) {
		#Run the query
		global $wpdb;
		$wpdb->query($sql);
		$wpdb->print_error();
		$wpdb->flush();
	}
	#Add_action( $tag, $function_to_add, $priority, $accepted_args );
	add_action( 'remove_subscriber_role', 'remove_subscriber_role_queries', 10, 2 );
	
	#Use do_action as needs to run without any means of trigger (eg. post saved)
	do_action( 'remove_subscriber_role', $sql);	
}

Basically, this is what ‘should’ happen with the code:
1) It checks to see if the user belongs to a specific group (setup via Groups), in this case the ‘basic’ group
2) If the user does, it gets the user meta ID from the current logged in user ID and runs a simple UPDATE SQL statement to alter the users capability meta by adding the subscriber role
3) Once the user has the additional role, the ACF fields then kick in

If the users subscription expires, they’re removed from the group ‘basic’ (default WooCommerce subscription behaviour).
The function in the theme file will always check the user and whether they belong to a group. If they don’t the second SQL statement runs, UPDATING the user again but defaulting back to the vendor role

I hope the code is ok but I’m sure it can be tidied/improved. The URE plugin remains active but I don’t use it apart from being able to easily see on the USERS page (as an admin) whether users have the multiple roles

I’d really appreciate your thoughts on this though

Many thanks