Description
Need to find every WooCommerce order containing a specific SKU or product variation?
WooCommerce lets you search orders by customer and filter by status and date, but it will not tell you which orders contain a particular item. Order Filter by SKU & Variation adds focused product filters directly to the WooCommerce Orders screen.
Search orders by product, by exact variation, by SKU or by product category, and exclude products or categories you do not want to see.
What it does
- Filter by SKU. Type or paste a SKU. A variation SKU finds orders containing that exact variation, not merely the parent product.
- Filter by variation. Choose Hoodie / Blue / XL and see only the orders containing that variation.
- Filter by product. Choose a product and see every order containing it, including all of its variations.
- Filter by product category. Includes child categories.
- Exclude a product. Show the orders that do not contain a given product or variation.
- Exclude a category. Same idea, applied to a whole category.
- Combine one inclusion with one exclusion. For example, orders containing Hoodie XL but not containing Clearance items.
Built to stay out of the way
- Works with High-Performance Order Storage (HPOS) and with the legacy order storage.
- Admin only. Nothing is added to your storefront, your checkout or your emails.
- No external services, no API keys, no accounts, no tracking and no outbound network calls of any kind.
- No settings page. Install it and the filters are on the Orders screen.
- Uses the product search WooCommerce already ships, so it looks and behaves like the rest of your admin.
Support
Free support covers reproducible bugs in the plugin itself. Compatibility troubleshooting with themes, custom code or third-party plugins is not included. Please include your WordPress and WooCommerce versions, whether HPOS is enabled, and the exact steps to reproduce.
Screenshots
Installation
- Install the plugin through Plugins > Add New, or upload the plugin folder to
/wp-content/plugins/. - Activate the plugin through the Plugins menu in WordPress.
- Go to WooCommerce > Orders. The filters appear alongside the existing status and date filters.
- Choose a product, variation, SKU or category, then select Filter.
WooCommerce must be installed and active.
FAQ
-
Does this work with High-Performance Order Storage?
-
Yes. The plugin supports HPOS and the legacy post-based order storage, and declares HPOS compatibility so WooCommerce does not warn about it.
-
What happens if I filter by a parent product that has variations?
-
You get every order containing any variation of that product. To narrow it to one variation, select the variation itself in the product filter, or enter the variation SKU.
-
Can I use the SKU filter with a partial SKU?
-
Not in this version. The SKU filter matches a complete SKU exactly, which is how WooCommerce itself resolves SKUs.
-
Can I combine filters?
-
Yes. Inclusion filters are combined, so an order must satisfy all of them. Exclusion filters remove any order that matches either of them.
-
Does it slow down the Orders screen?
-
The filters run one query against the order item tables to work out which orders match, then narrow the normal orders query. On very large catalogues, category filtering is capped so a single filter cannot generate an unbounded query.
-
Does it send any data anywhere?
-
No. Everything runs on your own site. The plugin makes no external requests.
Reviews
There are no reviews for this plugin.
Contributors & Developers
“Order Filter by SKU & Variation for WooCommerce” is open source software. The following people have contributed to this plugin.
Contributors
Translate “Order Filter by SKU & Variation for WooCommerce” into your language.
Interested in development?
Browse the code, check out the SVN repository, or subscribe to the development log by RSS.
Changelog
1.0.0
- Initial release.
- Filter orders by product, variation, SKU and product category.
- Exclude a product or a product category.
- HPOS and legacy order storage support.