woocommerce custom query

  • Hi guys!

    I’ve a WordPress website with S2member as membership plugin and Woocommerce.

    I’d like to build a simple custom software where my client can obtain a list of the order of a specific membership groups.

    For example: I’d like to see the order of Free membership. What kind of query I’ve to build?
    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator t-p

    (@t-p)

    I recommend asking at https://www.ads-software.com/support/plugin/woocommerce so the plugin’s developers and support community can help you with this.

    Moderator bcworkz

    (@bcworkz)

    It’s hard to get complete advice when two separate plugins are involved. You may want to break your query in two, one to get the user IDs in a particular group, then use the results to construct an order query in WC by an array of customer numbers. I can tell you orders are stored as “shop-order” post type and the order’s customer/user ID is saved under post meta key “_customer_user”. There’s probably a more convenient WC function to get such orders than a direct SQL query, hence t-p’s suggestion is a good one.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘woocommerce custom query’ is closed to new replies.