{"id":932,"date":"2021-05-04T13:28:57","date_gmt":"2021-05-04T13:28:57","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/?p=932"},"modified":"2025-11-06T10:00:32","modified_gmt":"2025-11-06T10:00:32","slug":"filter-orders-based-on-order-items-on-woocommerce-bulk-orders-editing","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/filter-orders-based-on-order-items-on-woocommerce-bulk-orders-editing\/","title":{"rendered":"How to filter orders based on order items on OBULKiT \u2013 Bulk Edit WooCommerce Orders Plugin?"},"content":{"rendered":"\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to filter orders based on order items on WooCommerce bulk orders editing?\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/jxjU8uZBPuM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Filter orders based on order items is one of the popular tasks that store managers need to do frequently. That\u2019s why we designed a specific tab in the \u201c<strong>Filter Form<\/strong>\u201d called <strong>Items <\/strong>in <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-orders-editing\/?utm_source=docs&amp;utm_content=filter-order-items\" target=\"_blank\" rel=\"noreferrer noopener\">OBULKiT \u2013 Bulk Edit WooCommerce Orders Plugin<\/a>. Our plugin allow you filter your preferred orders according to the products, their attributes, or taxonomies.<\/p>\n\n\n\n<p>To have access to these items in the \u201c<strong>Filter Form<\/strong>, you need to navigate to the address below after installing our plugin:<\/p>\n\n\n\n<p><strong>WordPress Dashboard > iThemeland > OBULKiT<\/strong><\/p>\n\n\n\n<p>The \u201c<strong>Filter Form<\/strong>\u201d button is easily observable on the main page of our plugin.&nbsp;<\/p>\n\n\n\n<p>By pressing the \u201c<strong>Filter Form<\/strong>\u201d button, a new form will be displayed with 7 different tabs. To filter orders based on order items, you just need to navigate to the <strong>Items<\/strong> tab in this form.<\/p>\n\n\n\n<p>As shown below, the order items are divided into three categories:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Products<\/li>\n\n\n\n<li>Taxonomy<\/li>\n\n\n\n<li>Attributes<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Items-tab.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1200\" height=\"638\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Items-tab.jpg\" alt=\"choose items tab in WooCommerce Bulk Orders Editing Plugin\" class=\"wp-image-934\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>To help you filter orders based on order items very fast and easy, two boxes have been designed in front of each filed, including:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Condition box<\/strong><\/h2>\n\n\n\n<p>\u201c<strong>Condition box<\/strong>\u201d includes three default options with different functionality:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>OR<\/strong>: this function can filter those orders that belong to one of the products \/ Taxonomies \/ Attributes, you have selected in the <strong>\u201cSelection Box\u201d<\/strong><\/li>\n\n\n\n<li><strong>And<\/strong>: this function can filter those orders that belong to all of the products \/ Taxonomies \/ Attributes, you have selected in the <strong>\u201cSelection Box\u201d<\/strong><\/li>\n\n\n\n<li><strong>Not in<\/strong>: this function can filter those orders that don\u2019t belong to all of the products \/ Taxonomies \/ Attributes, you have selected in the <strong>\u201cSelection Box\u201d<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Condition-box.jpg\"><img decoding=\"async\" width=\"1200\" height=\"637\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Condition-box.jpg\" alt=\"Condition box in WooCommerce Bulk Orders Editing Plugin\" class=\"wp-image-935\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Selection box&nbsp;<\/strong><\/h2>\n\n\n\n<p>In the <strong>\u201cSelection Box\u201d<\/strong>, all products \/ Taxonomies \/ Attributes you have already entered to WooCommerce are listed alphabetically. However, to see the list, you need to type a letter in the <strong>\u201cSelection Box\u201d<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Selection-box.jpg\"><img decoding=\"async\" width=\"1200\" height=\"622\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Selection-box.jpg\" alt=\"Selection box to select product \/ taxonomies \/ attributes and etc.\" class=\"wp-image-937\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>As soon as typing a letter in the <strong>\u201cSelection Box\u201d<\/strong>, a list of all products \/ Taxonomies \/ Attributes is displayed. Its letters will show to you, and you can choose as many items as you need to apply the selected condition to them.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-selected-condition.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"636\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-selected-condition.jpg\" alt=\"select products list to filter orders by product item\" class=\"wp-image-938\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>To make it clear for you, let\u2019s filter orders based on order items in the example below.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Filter orders based on order items: Products<\/strong><\/h2>\n\n\n\n<p>For example, consider that we choose <strong>OR<\/strong> from the \u201c<strong>Condition box<\/strong>\u201d list of Products. Then type \u201c<strong>c<\/strong>&#8221; in the selection box to see the list of products:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Filter-orders.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"640\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Filter-orders.jpg\" alt=\"Filter orders based on order products\" class=\"wp-image-941\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>If we choose \u201c<strong>WordPress Pennant<\/strong>&#8220;, \u201c<strong>Logo Collection<\/strong>\u201d and \u201c<strong>Acf product<\/strong>&#8221; from the list, we expect that the plugin filters those orders made for each one of them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Filter orders based on order items: Taxonomies<\/strong><\/h2>\n\n\n\n<p>In the taxonomies section, you can filter orders based on <strong>Categories<\/strong> and <strong>Tags<\/strong>. If you add any other taxonomy such as brands, manufacturers, etc, they will be automatically displayed in this part and you have access to them to filter orders based on them.<\/p>\n\n\n\n<p>In this example, we want to filter those orders that are in the Hoodie and T-shirt categories. So, we have to follow the instructions below:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Go to the <strong>Items<\/strong> tab in the \u201c<strong>Filter Form<\/strong>\u201d<\/li>\n\n\n\n<li>Choose \u201c<strong>And<\/strong>\u201d from the \u201c<strong>Condition box<\/strong>\u201d list in front of <strong>Product<\/strong> <strong>categories<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Product-categories.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"634\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Product-categories.jpg\" alt=\"Filter orders based on order taxonomies\" class=\"wp-image-944\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose <strong>Hoodie<\/strong>, then <strong>T-shirts<\/strong> from the list of <strong>\u201cSelection Box\u201d<\/strong><\/li>\n\n\n\n<li>Click on \u201c<strong>Get Orders\u201d<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Choose-items.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"642\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Choose-items.jpg\" alt=\"filter those orders which are in specific category\" class=\"wp-image-947\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>As we expected, all orders belonging to both Hoodie and T-shirts will be filtered.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Filter orders based on order items: Attributes<\/strong><\/h2>\n\n\n\n<p>Just like taxonomies, all attributes you have assigned to your products in WooCommerce are listed here automatically. You can filter orders based on them quickly.<\/p>\n\n\n\n<p>In this example, we have added <strong>Color<\/strong> and <strong>Size<\/strong> to our products. So they are displayed under the <strong>Attributes<\/strong> sections in the \u201c<strong>Filter Form<\/strong>\u201d.<\/p>\n\n\n\n<p>To filter those orders belonging to the products whose colors are not <strong>Green<\/strong> and <strong>Yellow<\/strong>, we need to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose \u201c<strong>Not in<\/strong>\u201d from the combo box of \u201c<strong>Condition box<\/strong>\u201d in front of <strong>Product color<\/strong><\/li>\n\n\n\n<li>Click on the <strong>\u201cSelection Box\u201d <\/strong>and choose <strong>Green<\/strong>, then <strong>Yellow<\/strong> from the list<\/li>\n\n\n\n<li>Click on \u201c<strong>Get Orders<\/strong>\u201d<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Product-color.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"632\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-Product-color.jpg\" alt=\"filter orders based on product attributes\" class=\"wp-image-949\" style=\"width:1200px\"\/><\/a><\/figure>\n\n\n\n<p>To see if the plugin filter orders according to our expectation, we need to add \u201c<strong>Order items<\/strong>\u201d from the \u201c<strong>Column Profile<\/strong>\u201d form to the order table as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/select-Order-items.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1494\" height=\"836\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/select-Order-items.png\" alt=\"add \u201cOrder items\u201d from the \u201cColumn Profile\u201d\" class=\"wp-image-1876\"\/><\/a><\/figure>\n\n\n\n<p>By adding this column, we are able to see all order items by clicking on the \u201c<strong>Order Items<\/strong>\u201d button provided in front of each order in the table.<\/p>\n\n\n\n<p>In the new pop-up appeared, you can see a list of all products involved in that order.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-products-involved.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"620\" height=\"300\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/09-products-involved.jpg\" alt=\"list of all products involved in that order\" class=\"wp-image-956\" style=\"width:620px\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Filter orders based on order items is one of the popular tasks that store managers need to do frequently. That\u2019s why we designed a specific tab in the \u201cFilter Form\u201d called Items in OBULKiT \u2013 Bulk Edit WooCommerce Orders Plugin. Our plugin allow you filter your preferred orders according to the products, their attributes, or [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-932","post","type-post","status-publish","format-standard","hentry","category-plugin-usage"],"_links":{"self":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/posts\/932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/comments?post=932"}],"version-history":[{"count":3,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/posts\/932\/revisions"}],"predecessor-version":[{"id":2710,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/posts\/932\/revisions\/2710"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/media?parent=932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/categories?post=932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/tags?post=932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}