Customer reports based on orders

  • Resolved kingpinzs

    (@kingpinzs)


    6 years, 11 months ago

    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

    (@lrehbein)

    Automattic Happiness Engineer

    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 6 years, 11 months ago by bryceadams.
    Laurena Rehbein

    (@lrehbein)

    Automattic Happiness Engineer

    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

    (@kingpinzs)

    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/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Customer reports based on orders’ is closed to new replies.