I am using Woocommerce Subscriptions and I want to generate a table that shows all active subscribers with their correlated user information. The following code is just pulling up all users... Any ideas on how to do this correctly? Thanks! :)
<table style="border-collapse: collapse;" border="0" width="450" cellspacing="0" cellpadding="0"><colgroup> <col span="5" width="75" /> </colgroup>
<tbody>
<tr>
<td width="75"><strong>Last Name</strong></td>
<td width="75" height="13"><strong>First Name</strong></td>
<td width="75"><strong>Company</strong></td>
<td width="95"><strong>Phone</strong></td>
<td width="75"><strong>Email</strong></td>
</tr>
<?php
$args = array(
'post_type' => 'shop_subscription', // Subscription post type
'post_status' => 'wc-active', // Active subscription
'order' => 'ASC',
'meta_key' => 'last_name',
'orderby' => 'meta_value',
'numberposts' => -1,
);
// The Query
$user_query = new WP_User_Query( $args );
// User Loop
if ( ! empty( $user_query->results ) ) {
foreach ( $user_query->results as $user ) {
echo '
<tr>
<td height="13">' . $user->last_name . '</td> <td>' . $user->first_name . '</td> <td>' . $user->billing_company . '</td><td>' . $user->billing_phone . '</td> <td>' . $user->user_email . '</td></tr>' ;
}
} else {
echo 'No users found.';
}
?>
</tbody>
</table>
You can do it with a custom SQL query this way (updated):
Code goes in function.php file of your active child theme (or theme) or also in any plugin file.
tested and works. You will get something like this: