Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]

You’ll find details here: https://gist.github.com/lukecav/05afef12feaf980c121da9afb9291ad5 OR Another approach is https://github.com/woocommerce/woocommerce/wiki/wc_get_orders-and-WC_Order_Query . Use if….else and store order data in Arr[product_id] = OrderArr Kindly accept my answer if it is of any help.

Add a class to a menu item depending on a body class

Use the nav_menu_css_class() filter. The following function will add the current-menu-item class to a page identified by it’s slug. You can Update the $cpt_name and $menu_item_id variables to reflect your setup. add_filter( ‘nav_menu_css_class’, ‘nav_parent_class’, 10, 2 ); function nav_parent_class( $classes, $item ) { $cpt_name=”team”; $menu_item_id = 127; // id of menu item to add current-menu-item … Read more

Advise on Custom Taxonomies and Structure

That’s how you resister taxonomy. This will add author as taxonomy <?php /** * @uses Register Book Author Taxonomy * @uses Adds query vars * @author Nirpendra Patel * @return void **/ function reg_tax_author() { $authors = array( ‘name’ => _x( ‘Authors’, ‘Taxonomy plural name’, ‘b_thebookstore’ ), ‘singular_name’ => _x( ‘Author’, ‘Taxonomy singular name’, ‘b_thebookstore’ … Read more

How to get ‘Products’ on home page?

Here’s a product loop I found: <ul class=”products”> <?php $args = array( ‘post_type’ => ‘product’, ‘posts_per_page’ => 12 ); $loop = new WP_Query( $args ); if ( $loop->have_posts() ) { while ( $loop->have_posts() ) : $loop->the_post(); woocommerce_get_template_part( ‘content’, ‘product’ ); endwhile; } else { echo __( ‘No products found’ ); } wp_reset_postdata(); ?> </ul><!–/.products–> Maybe … Read more