Title: Customer reports based on orders
Last modified: April 13, 2018

---

# Customer reports based on orders

 *  Resolved [kingpinzs](https://wordpress.org/support/users/kingpinzs/)
 * (@kingpinzs)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/)
 * Is there a way to get a report on registered customers that have not places an
   order? the Customer list does not allow for customer export and it does not have
   any filter options so I can say show me all customers with x amount of orders.

Viewing 5 replies - 1 through 5 (of 5 total)

 *  [Laurena Rehbein](https://wordpress.org/support/users/lrehbein/)
 * (@lrehbein)
 * Automattic Happiness Engineer
 * [8 years, 1 month ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/#post-10179642)
 * 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](https://metorik.com/customer-service)
 * Hope this helps!
 *  [bryceadams](https://wordpress.org/support/users/bryceadams/)
 * (@bryceadams)
 * [8 years, 1 month ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/#post-10179992)
 * Thank you for mentioning it [@lrehbein](https://wordpress.org/support/users/lrehbein/)!
   🙂
 * [@kingpinzs](https://wordpress.org/support/users/kingpinzs/), my app [Metorik](https://metorik.com)
   can definitely help you out here. It has a [segmenting system](https://help.metorik.com/article/54-all-about-segmenting)
   that lets you get data like this:
 * ![](https://i0.wp.com/i.imgur.com/fwbhCHA.png?ssl=1)
 * Any questions please let me know on the site’s live chat.
 * Cheers!
    -  This reply was modified 8 years, 1 month ago by [bryceadams](https://wordpress.org/support/users/bryceadams/).
 *  [Laurena Rehbein](https://wordpress.org/support/users/lrehbein/)
 * (@lrehbein)
 * Automattic Happiness Engineer
 * [8 years ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/#post-10196209)
 * 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.
 *  Thread Starter [kingpinzs](https://wordpress.org/support/users/kingpinzs/)
 * (@kingpinzs)
 * [8 years ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/#post-10196522)
 * 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.](https://wordpress.org/support/users/fernashes/)
 * (@fernashes)
 * Automattic Happiness Engineer
 * [8 years ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/#post-10257615)
 * 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/](https://woocommerce.com/customizations/)

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Customer reports based on orders’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [export](https://wordpress.org/support/topic-tag/export/)
 * [reports](https://wordpress.org/support/topic-tag/reports/)

 * 5 replies
 * 4 participants
 * Last reply from: [Hannah S.L.](https://wordpress.org/support/users/fernashes/)
 * Last activity: [8 years ago](https://wordpress.org/support/topic/customer-reports-based-on-orders/#post-10257615)
 * Status: resolved