Kowsar Hossain

<p>Have you ever wanted to filter your order page results by a specific product? With this plugin, now you can!</p>
<p>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.</p>
<p>This plugin supports filtering orders by:</p>
<ul>
<li>Product Name</li>
<li>Product Category</li>
</ul>
<p>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.</p>


Filter Orders by Product for WooCommerce

This plugin does exactly what it says it will and works great.  Just what I needed!



Fiter Orders by Product Works Great

Great


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.


Excellent plugin


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 :)


Good improvement

Simplify order management by filtering WooCommerce orders by any specific product or product category using this plugin

quadlayers

<p>Enhance your WooCommerce store’s efficiency with the Autocomplete WooCommerce Orders plugin. Automatically set orders to “Completed” upon payment confirmation, streamlining your sales process and reducing administrative overhead. Ideal for stores handling virtual goods, subscriptions, or any physical products.</p>
<p><a href="https://quadlayers.com/products/woocommerce-autocomplete-orders/" rel="nofollow ugc">Premium</a> | <a href="https://quadlayers.com/documentation/woocommerce-autocomplete-orders/" rel="nofollow ugc">Documentation</a> | <a href="https://www.facebook.com/groups/quadlayers/" rel="nofollow ugc">Community</a></p>
<h3>Presentation</h3>
<p>Install this plugin and automatically complete your WooCommerce orders automatically. This plugin is compatible with WooCommerce 2 and 3+ and works with all major payment providers including PayPal, SagePay and Stripe.</p>
<ul>
<li>Paid orders of virtual products only: orders containing “Virtual” products only will be completed upon successful payment.</li>
<li>All paid orders of any product: orders of any product (even physical) will be turned to “Completed” upon successful payment.</li>
<li>All orders: each and every order will turn to “Completed” irrespective of the payment status.</li>
</ul>
<p>Please note that enabling this plugin against all orders can allow the user to access the product before it has been paid for.</p>
<h3>WooCommerce Autocomplete Orders Premium</h3>
<p>The premium version of WooCommerce Autocomplete Orders plugin offer you a wide range of extra features that allows a full controll of the autocomplete orders process.</p>
<blockquote>
<ul>
<li>Autocomplete orders for Direct bank transfer payment method</li>
<li>Autocomplete orders for Check payments method</li>
<li>Autocomplete orders for Cash on delivery payment method</li>
<li>Autocomplete orders for Cash on delivery orders with downloadable products</li>
</ul>
</blockquote>


Autocomplete WooCommerce Orders


I am doing some custom trickery when an order is received but it is only triggered on order completion.  I wanted the whole thing to be automated and this plugin just works.  Great job devs.


does the job perfectly


Exactly what I needed.  Transitions our virtual subscriptions for LearnDash courses perfectly. 


Excellent

Enhance your WooCommerce store with Autocomplete Orders. Automatically complete orders after payment, perfect for virtual goods and subscriptions.

Filter Orders by Product for WooCommerce vs Autocomplete WooCommerce Orders