Filter Orders by Product for WooCommerce

Hi friend, thanks for your plugin! i tried to integrate search by SKU for woo, but then i found your plugin. I did small improvement to your code, so now we can search products by SKUs also, i would like that you will add it to your code, so we’ll not lose it with next update:)i did change in dropdown_fields() functionand replaced your query: public function dropdown_fields() { global $wpdb; $status = apply_filters( ‘wfobp_product_status’, ‘publish’ ); $sql = “SELECT p.ID AS product_id, p.post_title AS product_title, pm.meta_value AS product_sku FROM $wpdb->posts as p LEFT JOIN $wpdb->postmeta as pm ON pm.post_id = p.ID WHERE p.post_type = ‘product’ AND pm.meta_key = ‘_sku'”; $sql .= ( $status == ‘any’ ) ? ” : ” AND post_status = ‘$status'”; $all_posts = $wpdb->get_results( $sql, ARRAY_A ); $fields = array(); $fields[0] = esc_html__( ‘All Products’, ‘woocommerce-filter-orders-by-product’ ); foreach ( $all_posts as $all_post ) { $fields[ $all_post[’product_id’] ] = $all_post[’product_title’] . ‘(‘ . $all_post[’product_sku’] . ‘)’; } return $fields; } You used select2 search for dropdown, so now we have sku in product name and we easily can search product by typing SKUs in search dropdown 🙂

Artem Yanin

November 16, 2024

|

This plugin does exactly what it says, and good. Very handy and simply a must have. I have made my own (private) plugin depend on this one. Can’t live without it.

Knut Sparhell

May 22, 2024

|

WC’s very own order search already works with product names. This plugin would only make sense if it would add SKU search, but this is not the case.

volkerforster

January 7, 2024

|

1 reply

Hi friend, thanks for your plugin! i tried to integrate search by SKU for woo, but then i found your plugin. I did small improvement to your code, so now we can search products by SKUs also, i would like that you will add it to your code, so we’ll not lose it with next update:)i did change in dropdown_fields() functionand replaced your query: public function dropdown_fields() { global $wpdb; $status = apply_filters( ‘wfobp_product_status’, ‘publish’ ); $sql = “SELECT p.ID AS product_id, p.post_title AS product_title, pm.meta_value AS product_sku FROM $wpdb->posts as p LEFT JOIN $wpdb->postmeta as pm ON pm.post_id = p.ID WHERE p.post_type = ‘product’ AND pm.meta_key = ‘_sku'”; $sql .= ( $status == ‘any’ ) ? ” : ” AND post_status = ‘$status'”; $all_posts = $wpdb->get_results( $sql, ARRAY_A ); $fields = array(); $fields[0] = esc_html__( ‘All Products’, ‘woocommerce-filter-orders-by-product’ ); foreach ( $all_posts as $all_post ) { $fields[ $all_post[’product_id’] ] = $all_post[’product_title’] . ‘(‘ . $all_post[’product_sku’] . ‘)’; } return $fields; } You used select2 search for dropdown, so now we have sku in product name and we easily can search product by typing SKUs in search dropdown 🙂

Artem Yanin

November 16, 2024

|

This plugin does exactly what it says, and good. Very handy and simply a must have. I have made my own (private) plugin depend on this one. Can’t live without it.

Knut Sparhell

May 22, 2024

|

Thank you very much, great and simple plugin!

toni12

April 23, 2023

|

WC’s very own order search already works with product names. This plugin would only make sense if it would add SKU search, but this is not the case.

volkerforster

January 7, 2024

|

1 reply

Four stars for now… add the ability to EXCLUDE one product or category, and it gets a fifth 🙂

4wdabcwebmaster

April 6, 2023

|

1 reply

Hi friend, thanks for your plugin! i tried to integrate search by SKU for woo, but then i found your plugin. I did small improvement to your code, so now we can search products by SKUs also, i would like that you will add it to your code, so we’ll not lose it with next update:)i did change in dropdown_fields() functionand replaced your query: public function dropdown_fields() { global $wpdb; $status = apply_filters( ‘wfobp_product_status’, ‘publish’ ); $sql = “SELECT p.ID AS product_id, p.post_title AS product_title, pm.meta_value AS product_sku FROM $wpdb->posts as p LEFT JOIN $wpdb->postmeta as pm ON pm.post_id = p.ID WHERE p.post_type = ‘product’ AND pm.meta_key = ‘_sku'”; $sql .= ( $status == ‘any’ ) ? ” : ” AND post_status = ‘$status'”; $all_posts = $wpdb->get_results( $sql, ARRAY_A ); $fields = array(); $fields[0] = esc_html__( ‘All Products’, ‘woocommerce-filter-orders-by-product’ ); foreach ( $all_posts as $all_post ) { $fields[ $all_post[’product_id’] ] = $all_post[’product_title’] . ‘(‘ . $all_post[’product_sku’] . ‘)’; } return $fields; } You used select2 search for dropdown, so now we have sku in product name and we easily can search product by typing SKUs in search dropdown 🙂

Artem Yanin

November 16, 2024

|