Title: Filter Orders by Product for WooCommerce Author: Kowsar Hossain Published: 10 August 2015 Last modified: 23 June 2026 --- Search plugins ![](https://ps.w.org/woocommerce-filter-orders-by-product/assets/banner-772x250. jpg?rev=3365356) ![](https://ps.w.org/woocommerce-filter-orders-by-product/assets/icon-256x256.jpg? rev=2801613) # Filter Orders by Product for WooCommerce De [Kowsar Hossain](https://profiles.wordpress.org/kowsar89/) [Download](https://downloads.wordpress.org/plugin/woocommerce-filter-orders-by-product.4.1.2.zip) * [Details](https://lij.wordpress.org/plugins/woocommerce-filter-orders-by-product/#description) * [Reviews](https://lij.wordpress.org/plugins/woocommerce-filter-orders-by-product/#reviews) * [Installation](https://lij.wordpress.org/plugins/woocommerce-filter-orders-by-product/#installation) * [Development](https://lij.wordpress.org/plugins/woocommerce-filter-orders-by-product/#developers) [Supòrto](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/) ## Description Have you ever wanted to filter your order page results by a specific product? With this plugin, now you can! Once installed, a new filter dropdown will appear on the WooCommerce Orders screen, displaying a list of all products. Simply select a product and click the “Filter” button to view orders containing only that product. This plugin supports filtering orders by: * Product Name * Product Category Note: This plugin is compatible with both WooCommerce’s new HPOS (High-Performance Order Storage) and the legacy WordPress posts storage. Whether you’re using HPOS or the traditional storage method, this plugin will work seamlessly. ## Screenshots [⌊From admin panel, Click on "WooCommerce>Orders" to visit the Orders screen. There you'll see a new dropdown filter.⌉⌊From admin panel, Click on "WooCommerce>Orders" to visit the Orders screen. There you'll see a new dropdown filter.⌉[ From admin panel, Click on “WooCommerce>Orders” to visit the Orders screen. There you’ll see a new dropdown filter. [⌊Click on that dropdown and you'll see a list of all products. Select a product and click on "Filter" button. It'll show up the orders which contains only that specific product.⌉⌊Click on that dropdown and you'll see a list of all products. Select a product and click on "Filter" button. It'll show up the orders which contains only that specific product.⌉[ Click on that dropdown and you’ll see a list of all products. Select a product and click on “Filter” button. It’ll show up the orders which contains only that specific product. ## Installation There are three different ways to install this plugin, as well as any other plugin from the WordPress.org repository. #### Automatic Installation via WordPress Dashboard 1. Log in to your WordPress admin dashboard. 2. Navigate to `Plugins` > `Add New`. 3. Search for “Filter Orders by Product for WooCommerce”. 4. Click `Install Now` next to the plugin. 5. Once installed, click `Activate`. #### Manual Upload through WordPress Dashboard 1. Download the “Filter Orders by Product for WooCommerce” plugin ZIP file. 2. Log in to your WordPress admin dashboard. 3. Navigate to `Plugins` > `Add New`. 4. Click `Upload Plugin`. 5. Click `Choose File`, select the plugin ZIP file you downloaded, and click `Install Now`. 6. Once the installation is complete, click `Activate Plugin`. #### Installation via FTP 1. Download the “Filter Orders by Product for WooCommerce” plugin ZIP file and extract it to your computer. 2. Using an FTP client, connect to your web server. 3. Navigate to `/wp-content/plugins/`. 4. Upload the extracted plugin folder to the `/wp-content/plugins/` directory on your server. 5. Log in to your WordPress admin dashboard. 6. Navigate to `Plugins`. 7. Locate “Filter Orders by Product for WooCommerce” in the list and click `Activate`. After the installation is complete, a new filter will appear on the WooCommerce Orders page. ## FAQ-e ### Does this plugin work for all product statuses (public, draft, etc.)? Currently, this plugin only works for published products. To make it work for all product statuses (e.g., draft, private), add the following code to your theme’s ` functions.php` file: ``` add_action( 'wfobp_product_status', 'filter_order_by_product_status' ); function filter_order_by_product_status(){ return 'any'; } ``` ## Reviews ![](https://secure.gravatar.com/avatar/1e4dcdcab2d360056e5c9161e0b2628d71915798ee3ff1d3912c2c9bbbf6bd60? s=60&d=retro&r=g) ### 󠀁[Good improvement](https://wordpress.org/support/topic/good-improvement/)󠁿 [Artem Yanin](https://profiles.wordpress.org/brainiacx/) 16 November 2024 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 🙂 ![](https://secure.gravatar.com/avatar/cd257f389c91f137dab25f343b527123e887135b01921ebb6206e40cfa2eb636? s=60&d=retro&r=g) ### 󠀁[Excellent plugin](https://wordpress.org/support/topic/excellent-plugin-9159/)󠁿 [Knut Sparhell](https://profiles.wordpress.org/knutsp/) 22 May 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. ![](https://secure.gravatar.com/avatar/b1e4abc7b69392cd2a36addb6ff40dfbc270ae8d841ed5dc118ef0a922801038? s=60&d=retro&r=g) ### 󠀁[filter by product – completely useless](https://wordpress.org/support/topic/filter-by-product-completely-useless/)󠁿 [Volker Forster](https://profiles.wordpress.org/volkerforster/) 07 January 2024 1 reply 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. ![](https://secure.gravatar.com/avatar/d54af5018ece330a0a0b56a56f27e4a25f69720afc3cbfd9a8ac2232b26e1e3c? s=60&d=retro&r=g) ### 󠀁[Great and simple!](https://wordpress.org/support/topic/great-and-simple-176/)󠁿 [toni12](https://profiles.wordpress.org/toni12/) 23 April 2023 Thank you very much, great and simple plugin! ![](https://secure.gravatar.com/avatar/80827df68e1599f75eb58f70ff432ecd26aeed4f0e64b1b791951b3ebf49f210? s=60&d=retro&r=g) ### 󠀁[Handy, but needs one more thing…](https://wordpress.org/support/topic/handy-but-needs-one-more-thing/)󠁿 [4wdabcwebmaster](https://profiles.wordpress.org/4wdabcwebmaster/) 06 April 2023 1 reply Four stars for now… add the ability to EXCLUDE one product or category, and it gets a fifth 🙂 ![](https://secure.gravatar.com/avatar/caca1f1a00bf5ef207ec0f2c1eb63728b5b7eeaba303a1a71873f8bc44c4c240? s=60&d=retro&r=g) ### 󠀁[Very nice plugin](https://wordpress.org/support/topic/very-nice-plugin-861/)󠁿 [renisauria](https://profiles.wordpress.org/renisauria/) 02 April 2021 This plugin is super helpful. I wanted to add a link on a custom admin page to orders for a specific product, and I just had to copy the URL string and add it to a link. Many thanks to the author! [ Read all 15 reviews ](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/) ## Contributors & Developers “Filter Orders by Product for WooCommerce” is open source software. The following people have contributed to this plugin. Contributors * [ Kowsar Hossain ](https://profiles.wordpress.org/kowsar89/) “Filter Orders by Product for WooCommerce” has been translated into 11 locales. Thank you to [the translators](https://translate.wordpress.org/projects/wp-plugins/woocommerce-filter-orders-by-product/contributors) for their contributions. [Translate “Filter Orders by Product for WooCommerce” into your language.](https://translate.wordpress.org/projects/wp-plugins/woocommerce-filter-orders-by-product) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/woocommerce-filter-orders-by-product/), check out the [SVN repository](https://plugins.svn.wordpress.org/woocommerce-filter-orders-by-product/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/woocommerce-filter-orders-by-product/) by [RSS](https://plugins.trac.wordpress.org/log/woocommerce-filter-orders-by-product/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 4.1.2 – Sep 21, 2025 * Tweak: Plugin name updated #### 4.1 – May 20, 2024 * Tweak: Readme updated #### 4.0 – Dec 31, 2023 * Tweak: Added WooCommerce HPOS support #### 3.3 – Aug 20, 2023 * Fix: Resolved PHP notice caused by incorrect use of the `is_search()` function #### 3.1 * Readme updated #### 3.0 * New: Now it’s possible to filter by Product Category * Code refactored #### 2.0.7 * Fix: Products with same name only appeared once before #### 2.0.6 * Added hook for changing product status #### 2.0.5 * Fixed SQL injection bug #### 2.0.4 * Improved code #### 2.0.3 * Fix: Language #### 2.0.2 * Fixed translation bug (Thanks to Kasperta) #### 2.0.1 * Fixed a minor bug #### 2.0.0 * New: search dropdown * Fixed a major bug #### 1.0.0 * Initial release ## Mêta * Version **4.1.2** * Last updated **4 months ago** * Active installations **4.000+** * WordPress version ** 3.0.1 or higher ** * Tested up to **7.0.7** * PHP version ** 5.6 or higher ** * Languages * [Catalan](https://ca.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [Chinese (China)](https://cn.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [English (UK)](https://en-gb.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [English (US)](https://wordpress.org/plugins/woocommerce-filter-orders-by-product/), [French (Belgium)](https://fr-be.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [French (France)](https://fr.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [German](https://de.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [Italian](https://it.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [Japanese](https://ja.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [Norwegian (Bokmål)](https://nb.wordpress.org/plugins/woocommerce-filter-orders-by-product/), [Spanish (Chile)](https://cl.wordpress.org/plugins/woocommerce-filter-orders-by-product/), e [Swedish](https://sv.wordpress.org/plugins/woocommerce-filter-orders-by-product/). * [Translate into your language](https://translate.wordpress.org/projects/wp-plugins/woocommerce-filter-orders-by-product) * Tags * [admin](https://lij.wordpress.org/plugins/tags/admin/)[filter](https://lij.wordpress.org/plugins/tags/filter/) [order](https://lij.wordpress.org/plugins/tags/order/)[product](https://lij.wordpress.org/plugins/tags/product/) [woocommerce](https://lij.wordpress.org/plugins/tags/woocommerce/) * [Advanced View](https://lij.wordpress.org/plugins/woocommerce-filter-orders-by-product/advanced/) ## Ratings 4.7 out of 5 stars. * [ 13 5-star reviews ](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/?filter=5) * [ 1 4-star review ](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/?filter=2) * [ 1 1-star review ](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/reviews/) ## Contributors * [ Kowsar Hossain ](https://profiles.wordpress.org/kowsar89/) ## Supòrto Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/woocommerce-filter-orders-by-product/)