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

brightvesseldev

Niloy

Kleinmann

<p><strong>Order Status Control for WooCommerce</strong> plugin helps shop admins complete orders automatically. By default, WooCommerce auto-complete “downloadable” products but not “Virtual” products. This plugin auto-completes virtual products as well. It also comes with two additional cases.</p>
<h4>Plugin Features:</h4>
<ul>
<li><strong>Default:</strong> Default WooCommerce Order method.</li>
<li><strong>All orders containing only Virtual Products:</strong> Orders that don’t have any other physical products and only have Virtual products will be marked as completed.</li>
<li><strong>All Orders that have Paid Successfully:</strong> All orders (along with physical products) that successfully paid will be marked as complete.</li>
<li><strong>All Orders:</strong> No matter what the order contains or has (payment complete, virtual, physical, offline payments, etc.), as soon as a customer land on the thank you page, the order status will be changed to complete.</li>
</ul>
<h4>Setting Location:</h4>
<p>Order Status Control option will be found under WooCommerce > Settings > General Tab</p>
<h3>🔥 ALL ACCESS MEMBERSHIP 🔥</h3>
<p>Unlock all 19 premium WooCommerce plugins with one club membership. <a href="https://brightplugins.com/product/club-membership/?utm_source=wp_org&utm_medium=order-status-control&utm_campaign=upgrade_club_membership&utm_content=plugin-description" rel="nofollow ugc"><strong>Join the Club »</strong></a></p>
<h3>WHAT’S NEXT</h3>
<p><strong>If you like this order status control plugin, then consider checking out our other free plugins:</strong></p>
<p><a href="https://wordpress.org/plugins/pre-orders-for-woocommerce/" rel="ugc">Preorder for WooCommerce</a> – Ultimate Preorders Plugin for WooCommerce.<br />
<a href="https://wordpress.org/plugins/woo-show-stock/" rel="ugc">Show Stock for WooCommerce</a><br />
<a href="https://wordpress.org/plugins/woo-disable-email-notifications/" rel="ugc">Disable Email Notifications for WooCommerce</a><br />
<a href="https://wordpress.org/plugins/bp-custom-order-status-for-woocommerce/" rel="ugc">Custom Order Status</a> Allows creating custom order status for WooCommerce</p>


Order Status Control for WooCommerce

Auto Complete orders for virtual-downloadable products after a successful payment or predefine status.

Filter Orders by Product for WooCommerce vs Order Status Control for WooCommerce