Hi there,
There is no built-in way to do this. But you might be able to make it happen with Metorik – https://metorik.com/customer-service
Hope this helps!
Thank you for mentioning it @lrehbein! 🙂
@kingpinzs, my app Metorik can definitely help you out here. It has a segmenting system that lets you get data like this:
Any questions please let me know on the site’s live chat.
Cheers!
-
This reply was modified 8 years, 1 month ago by
bryceadams.
We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.
Sorry no it’s not. I was talking more like this.
SELECT
*
FROM
wp_users
RIGHT JOIN
wp_usermeta ON wp_usermeta.user_id = wp_users.ID
RIGHT JOIN
wp_woo_sr_orders ON wp_woo_sr_orders.billing_email = wp_users.user_email COLLATE utf8mb4_unicode_520_ci
RIGHT JOIN
wp_wusp_user_pricing_mapping ON wp_wusp_user_pricing_mapping.user_id = wp_woo_sr_orders.user_id
#GROUP BY wp_users.ID
HAVING COUNT(wp_usermeta.user_id)=0;
which is still not right so I am still going through all the tables
on another note there platform is to expensive so my boss wont pay for it
Plugin Support
Hannah S.L.
(@fernashes)
Automattic Happiness Engineer
This customization is far beyond the level of support we can offer. We’ve recommended a plugin that will help you out as well. I’m going to mark this as resolved to help keep the forums healthy. If you have any further questions, you can start a new thread.
If you’d like to pursue this further, then I highly recommend contacting one of the services on our customizations page: https://woocommerce.com/customizations/
