WC Vendors Activate All Vendors

/** Activates all Vendor Stores **/

function wcv_activate_all_vendors() {

	global $wpdb;

	$users = get_users( array( 'fields' => array( 'ID' ), 'role' => 'Vendor' ) );

	$meta_key = '_wcv_vendor_status';

	foreach($users as $user){

		$wpdb->query($wpdb->prepare("UPDATE wp_usermeta SET meta_value='active' WHERE user_id=$user->ID AND meta_key='$meta_key'"));

	}

}

/** Activate all Vendor Stores after WordPress has finished loading [but before any headers are sent] **/

add_action('init', 'wcv_activate_all_vendors');