{"id":963,"date":"2021-05-04T13:28:57","date_gmt":"2021-05-04T13:28:57","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/?p=963"},"modified":"2025-11-06T09:57:41","modified_gmt":"2025-11-06T09:57:41","slug":"filter-order-on-woocommerce-bulk-orders-editing-plugin","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/filter-order-on-woocommerce-bulk-orders-editing-plugin\/","title":{"rendered":"How to filter WooCommerce orders, in OBULKiT \u2013 Bulk Edit WooCommerce Orders Plugin?"},"content":{"rendered":"\n<p>WooCommerce filter orders according to various fields such as \u201corder status\u201d or \u201corder date\u201d or \u201corder price\u201d is simply possible on <a href=\"https:\/\/ithemelandco.com\/plugins\/woocommerce-bulk-orders-editing\/?utm_source=docs&amp;utm_content=filter-orders\" target=\"_blank\" rel=\"noreferrer noopener\">OBULKiT \u2013 Bulk Edit WooCommerce Orders Plugin<\/a> by using the \u201c<strong>Filter Form<\/strong>\u201d.<\/p>\n\n\n\n<p>In this tutorial, we are going to introduce all fields provided in the \u201c<strong>Filter Form<\/strong>\u201d. It  help you filter the custom orders you need to be bulk edited in less than a few minutes.&nbsp;<\/p>\n\n\n\n<p>To open the \u201c<strong>Filter Form<\/strong>\u201d and use its options for filtering custom orders, you need to navigate to the below address after installation of our plugin on your website:<\/p>\n\n\n\n<p><strong>WordPress Dashboard > iThemeland > OBULKiT\u00a0<\/strong><\/p>\n\n\n\n<p>We designed the \u201c<strong>Filter Form<\/strong>\u201d button at the top of the main page of our plugin. So you have easy access to it for starting multi order bulk editing.&nbsp;<\/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\/2021\/05\/bulk-edit.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1401\" height=\"561\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/bulk-edit.jpg\" alt=\"filter form in WooCommerce bulk orders editing plugin\" class=\"wp-image-2325\"\/><\/a><\/figure>\n\n\n\n<p>By clicking on the \u201c<strong>Filter Form<\/strong>\u201d button, this form with all of your required fields for filtering custom orders will be displayed.&nbsp;<\/p>\n\n\n\n<p>As illustrated below, to help you find the preferred fields easier, we divided \u201c<strong>Filter Form<\/strong>\u201d into seven categories including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>General<\/li>\n\n\n\n<li>Billing<\/li>\n\n\n\n<li>Pricing<\/li>\n\n\n\n<li>Items<\/li>\n\n\n\n<li>Other fields&nbsp;<\/li>\n\n\n\n<li>Custom Fields&nbsp;<\/li>\n<\/ul>\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\/Filter-Form-1.jpg\"><img decoding=\"async\" width=\"1186\" height=\"547\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Filter-Form-1.jpg\" alt=\"opening the \u201cFilter Form\u201d button in WooCommerce bulk orders editing plugin\" class=\"wp-image-1860\"\/><\/a><\/figure>\n\n\n\n<p>Now, let\u2019s find out which fields are supported in each category.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>General tab<\/strong><\/h2>\n\n\n\n<p>The most popular fields related to the orders are provided in the \u201c<strong>General tab<\/strong>\u201d. It helps enable you to filter orders accordingly, which are:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Filter orders by ID<\/strong><\/h3>\n\n\n\n<p>To filter orders according to the \u201c<strong>Filter ID<\/strong>\u201d. You just need to type one or more \u201c<strong>ID numbers<\/strong>\u201d like the examples below in the Text box.<\/p>\n\n\n\n<p>If the \u201c<strong>ID numbers<\/strong>\u201d are not in order, you can separate them by \u201c<strong>,<\/strong>\u201d such as 1, 17, 33.<\/p>\n\n\n\n<p>If the \u201c<strong>ID numbers<\/strong>\u201d are in order. For example, when you need all \u201c<strong>ID numbers<\/strong>\u201d between 2 and 5, you can type them as a range by using \u201c<strong>&#8211;<\/strong>\u201cbetween two numbers like \u201c<strong>3-5<\/strong>\u201d.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Filter orders by date \/ modified date \/ paid date<\/strong><\/h3>\n\n\n\n<p>These fields are useful when you need to filter orders according to their \u201c<strong>Ordered date, Modified date or Paid date<\/strong>\u201d. The interesting option that our plugin supports is the possibility of filtering orders in a period of time by using the provided calendar and also the time sheet.<\/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\/2021\/05\/10-Ordered-date.jpg\"><img decoding=\"async\" width=\"1200\" height=\"548\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Ordered-date.jpg\" alt=\"General tab in filter form\" class=\"wp-image-985\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>For example, we tried to filter those orders received from 2021\/01\/13 20.00 to 2021\/01\/24&nbsp; 21.00 by using the \u201c<strong>Calendar<\/strong>\u201d as shown below.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Filter orders by customer IP address&nbsp;<\/strong><\/h3>\n\n\n\n<p>\u201c<strong>Customer IP address<\/strong>\u201d is another field that you can filter orders regarding to it by choosing one of the following conditions:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Like<\/strong>: The value entered in the text box is included in the \u201c<strong>Customer IP Address<\/strong>\u201d&nbsp;<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Exact<\/strong>: The \u201c<strong>Customer IP Address<\/strong>\u201d is exactly the same as the value entered in the textbox\u00a0<\/li>\n\n\n\n<li><strong>Not<\/strong>: The \u201c<strong>Customer IP Address<\/strong>\u201d is not the same as the value entered in the textbox<\/li>\n\n\n\n<li><strong>Begin<\/strong>: The value entered in the text box is at the beginning of the \u201c<strong>Customer IP address<\/strong>\u201d.&nbsp;&nbsp;<\/li>\n\n\n\n<li><strong>End<\/strong>: The value entered in the text box is at the end of the \u201c<strong>Customer IP address<\/strong>\u201d.&nbsp;&nbsp;<\/li>\n<\/ul>\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\/2021\/05\/10-Customer-IP-Address.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"555\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Customer-IP-Address.jpg\" alt=\"filter orders by customer IP address \" class=\"wp-image-987\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Filter orders by status<\/strong><\/h3>\n\n\n\n<p>In the \u201c<strong>Status<\/strong>\u201d field, you can filter custom orders according to one of the conditions listed in the combo box in front of it, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Pending payment<\/li>\n\n\n\n<li>Processing<\/li>\n\n\n\n<li>On hold<\/li>\n\n\n\n<li>Completed<\/li>\n\n\n\n<li>Cancelled<\/li>\n\n\n\n<li>Refunded<\/li>\n<\/ul>\n\n\n\n<p>If you define any other order status in WooCommerce, the condition will be added automatically to this list. Then you can choose it to filter the orders accordingly.\u00a0\u00a0<\/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\/2021\/05\/10-Status.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"554\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Status.jpg\" alt=\"Status\u201d field, you can filter custom orders according to one of the conditions listed\" class=\"wp-image-988\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Billing tab<\/strong><\/h2>\n\n\n\n<p>In the \u201c<strong>Billing<\/strong>\u201d tab, we have listed all fields related to the order billings that you have set before in WooCommerce.<\/p>\n\n\n\n<p>As shown below, the most popular fields in the order billings are provided in this tab, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Billing first name \/ last name<\/li>\n\n\n\n<li>Billing Address 1\/ 2<\/li>\n\n\n\n<li>And Billing City \/ Company \/ Email \/ Phone \/ postcode<\/li>\n<\/ul>\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\/2021\/05\/10-Billing-tab.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"570\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Billing-tab.jpg\" alt=\"Billing tab in woocomerce order bulk edit\" class=\"wp-image-990\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>You can enter a value in the text box in front of each one and choose a condition from the \u201c<strong>Condition box<\/strong>\u201d. This let the plugin filter the orders according to them.<\/p>\n\n\n\n<p>The items provided in the \u201c<strong>Condition box<\/strong>\u201d are the same as the items we described for the \u201c<strong>Condition box<\/strong>\u201d of \u201c<strong>IP<\/strong> <strong>address<\/strong>\u201d in the \u201c<strong>General<\/strong>\u201d tab.<\/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\/2021\/05\/10-Condition-box.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"608\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Condition-box.jpg\" alt=\"Filtering orders by billing name, address, city and etc\" class=\"wp-image-991\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>To make it clear for you, let\u2019s try using some of them for filtering our orders:&nbsp;<\/p>\n\n\n\n<p>For example, if we choose \u201c<strong>Like<\/strong>\u201d from the \u201c<strong>Condition box<\/strong>\u201d of the \u201c<strong>Billing Name<\/strong>\u201d field and type \u201c<strong>Customer<\/strong>\u201d in the text box in front of it, as illustrated 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\/Billing-Name.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1514\" height=\"838\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Billing-Name.png\" alt=\"filter orders by billing name\" class=\"wp-image-1861\"\/><\/a><\/figure>\n\n\n\n<p>All the orders that their \u201c<strong>Billing Name<\/strong>\u201d includes \u201cCustomer\u201d will be filtered after clicking onthe  \u201c<strong>Get Orders<\/strong>\u201d button:<\/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\/Get-Orders.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1702\" height=\"351\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Get-Orders.png\" alt=\"The result of filtered orders by billing name\" class=\"wp-image-1862\" srcset=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Get-Orders.png 1702w, https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Get-Orders-1536x317.png 1536w\" sizes=\"(max-width: 1702px) 100vw, 1702px\" \/><\/a><\/figure>\n\n\n\n<p>We can also filter all orders that are received from \u201c<strong>Smith<\/strong>\u201d by typing \u201c<strong>Smith<\/strong>\u201d in the text box of \u201c<strong>Billing Last Name<\/strong>\u201d and choosing \u201c<strong>Exact<\/strong>\u201d from the Condition box:<\/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\/2021\/05\/10-Billing-Last-Name.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"600\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Billing-Last-Name.jpg\" alt=\"filter orders by billing last name\" class=\"wp-image-999\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>So, the result is exactly according to our expectations after clicking on the \u201c<strong>Get Orders<\/strong>\u201d button:<\/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\/result-3.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1702\" height=\"322\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/result-3.png\" alt=\"The result of filtered orders by billing last name\" class=\"wp-image-1863\" srcset=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/result-3.png 1702w, https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/result-3-1536x291.png 1536w\" sizes=\"(max-width: 1702px) 100vw, 1702px\" \/><\/a><\/figure>\n\n\n\n<p>This is also possible to exclude \u201c<strong>Arizona<\/strong>\u201d from the list of cities that are going to be filtered for us by:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choosing \u201c<strong>Not<\/strong>\u201d from the \u201c<strong>Condition box<\/strong>\u201d of \u201c<strong>Billing City<\/strong>\u201d<\/li>\n\n\n\n<li>Type \u201c<strong>Arizona<\/strong>\u201d in the textbox in front of it<\/li>\n\n\n\n<li>Click on \u201c<strong>Get Orders<\/strong>\u201d&nbsp;<\/li>\n<\/ul>\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\/2021\/05\/10-Billing-City.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"654\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Billing-City.jpg\" alt=\"Choosing \u201cNot\u201d from the \u201cCondition box\u201d of \u201cBilling City\u201d\" class=\"wp-image-1002\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>Which will result in:<\/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\/result-1-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1700\" height=\"439\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/result-1-1.png\" alt=\"The result of filtered orders by billing city\" class=\"wp-image-1864\" srcset=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/result-1-1.png 1700w, https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/result-1-1-1536x397.png 1536w\" sizes=\"(max-width: 1700px) 100vw, 1700px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Filter orders by the billing country and billing state fields<\/strong><\/h3>\n\n\n\n<p>One of the advantages of our plugin is providing a complete database of all countries with their states in the world. This means that if you are developing your business internationally, and your customers are sending their orders from all over the world to your e-commerce website. You can easily and quickly filter their orders according to their countries and even their states.<\/p>\n\n\n\n<p>To show you how this field can filter the orders for a special state in a country, consider you have received some orders from \u201c<strong>New South Wales, Australia<\/strong>\u201d and you need to filter them.<\/p>\n\n\n\n<p>To do this, click on the combo box in front of \u201c<strong>Billing Country<\/strong>\u201d and find \u201c<strong>Australia<\/strong>\u201d.<\/p>\n\n\n\n<p>As soon as you choose \u201cAustralia\u201d, our plugin will automatically make a list of the states of that country in the combo box in front of the \u201c<strong>Billing State<\/strong>\u201d field.\u00a0<\/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\/Billing-Country-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1516\" height=\"837\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Billing-Country-2.png\" alt=\"filtering WooCommerce orders by billing country fields\" class=\"wp-image-1872\"\/><\/a><\/figure>\n\n\n\n<p>Then you can find \u201c<strong>New South Wales<\/strong>\u201d and select it.<\/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\/2021\/05\/10-Billing-state.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"633\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Billing-state.jpg\" alt=\"filtering woocommerce orders by Billing state field\" class=\"wp-image-1008\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>Finally, by clicking on \u201c<strong>Get Orders<\/strong>\u201d, these orders will be filtered as you expected.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Shipping tab<\/strong><\/h2>\n\n\n\n<p>The fields supported in the \u201c<strong>Shipping<\/strong>\u201d tab enable you to filter the orders according to the shipping information, which are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The shipping First Name \/ Last Name<\/li>\n\n\n\n<li>Shipping Address 1 \/ 2<\/li>\n\n\n\n<li>Shipping City \/ Company \/ postcode<\/li>\n\n\n\n<li>And the Shipping Country \/ State<\/li>\n<\/ul>\n\n\n\n<p>You can use \u201c<strong>Condition<\/strong>\u201d boxes, \u201c<strong>text boxes<\/strong>\u201d and \u201c<strong>Combo boxes<\/strong>\u201d in front of each field to filter the orders exactly as we described for the fields provided in the \u201c<strong>Billing<\/strong>\u201d tab.<\/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\/2021\/05\/10-Shipping-tab.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1294\" height=\"642\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Shipping-tab.jpg\" alt=\"Shipping tab in woocommerce bulk orders editing\" class=\"wp-image-1010\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>For example, if you choose \u201c<strong>United State<\/strong>\u201d from the \u201c<strong>Shipping Country<\/strong>\u201d dropdown list:&nbsp;<\/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\/2021\/05\/10-Shipping-Country.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"612\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Shipping-Country.jpg\" alt=\"filtering orders by Shipping Country\" class=\"wp-image-1012\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>A list of \u201c<strong>US states<\/strong>\u201d will be available in the \u201c<strong>Shipping State<\/strong>\u201d and you can choose one of them to filter orders that must be shipped to that state.<\/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\/10-Shipping-State.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Shipping-State.jpg\" alt=\"filtering woocommerce orders by shipping state\" class=\"wp-image-1013\"\/><\/a><figcaption class=\"wp-element-caption\">WooCommerce filter orders by shipping method<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Pricing tab<\/strong><\/h2>\n\n\n\n<p>In the Pricing tab, you have access to the below fields and you can filter orders regarding them:<\/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\/Pricing-tab-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"413\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Pricing-tab-1.jpg\" alt=\"Pricing tab in WooCommerce order bulk edit plugin\" class=\"wp-image-1866\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Filter orders by currency<\/strong><\/h3>\n\n\n\n<p>\u201c<strong>Order currency<\/strong>\u201d is another amazing feature in our plugin which is a complete list of all currencies available all around the world that you may invoice the orders according to them.&nbsp;<\/p>\n\n\n\n<p>All currencies are supported in our plugin and you can choose each one from the combo box in front of \u201c<strong>Order Currency<\/strong>\u201d to filter orders.<\/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\/Order-currency.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1511\" height=\"778\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Order-currency.png\" alt=\"set Order currency for filtering\" class=\"wp-image-1867\"\/><\/a><\/figure>\n\n\n\n<p>There are also other fields in the pricing tab which are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cart discount<\/li>\n\n\n\n<li>Cart discount tax<\/li>\n\n\n\n<li>Order Total<\/li>\n<\/ul>\n\n\n\n<p>As all of these fields are related to a number, we provided two text boxes in front of each one to set minimum and maximum amounts. So, you can easily set a range of numbers to filter the orders that met that criteria.<\/p>\n\n\n\n<p>For example, as you can see we tried to filter those orders with total price from 100 to 2000 US dollars:<\/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\/Order-Total.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1178\" height=\"403\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Order-Total.jpg\" alt=\"\" class=\"wp-image-1868\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Items tab<\/strong><\/h2>\n\n\n\n<p>In the \u201c<strong>items<\/strong>\u201d tab, all products, categories, taxonomies and the related attributes are listed to help you filter the orders with regard to them.<\/p>\n\n\n\n<p>To take the most advantages of these fields, we provide two boxes in front of each field including:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Condition box<\/strong><\/h3>\n\n\n\n<p>In the \u201c<strong>Condition box<\/strong>\u201d you can choose one of the below items:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Or<\/li>\n\n\n\n<li>And<\/li>\n\n\n\n<li>Not In<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Selection box<\/strong><\/h3>\n\n\n\n<p>In the \u201c<strong>Selection Box<\/strong>\u201d, a list of all items related to that field will be displayed and you can choose as many items as you need among them.<\/p>\n\n\n\n<p>Let\u2019s see how these conditions will filter the order in our plugin by some examples:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 1: WooCommerce filter orders by Products<\/strong><\/h4>\n\n\n\n<p>In this example, we are going to filter orders received for \u201c<strong>V-Neck-T-Shirt-Blue<\/strong>\u201d or \u201c<strong>Logo Collection<\/strong>\u201d.<\/p>\n\n\n\n<p>To do this, we simply choose \u201c<strong>OR<\/strong>\u201d from \u201c<strong>Condition box<\/strong>\u201d in front of \u201c<strong>Product<\/strong>\u201d field:<\/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\/2021\/05\/10-Product-field.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"606\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Product-field.jpg\" alt=\"Filter order by Products\" class=\"wp-image-1019\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>Type some part of the \u201c<strong>Product title<\/strong>\u201d in the text box:<\/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\/2021\/05\/10-Product-title.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"606\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Product-title.jpg\" alt=\"filtering orders by product name\" class=\"wp-image-1020\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>To see a list of Products with that letters:<\/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\/2021\/05\/10-Products.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"609\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Products.jpg\" alt=\"show products name\" class=\"wp-image-1022\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>Choose our prefered products from the list:<\/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\/2021\/05\/10-Product-color.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1302\" height=\"664\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Product-color.jpg\" alt=\"Choose prefered products from the list\" class=\"wp-image-1023\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>By clicking on the \u201c<strong>Get Orders<\/strong>\u201d button, the orders received for both products will be filtered and displayed in the order table.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 2: WooCommerce filter orders by product categories<\/strong><\/h4>\n\n\n\n<p>We can do the same for \u201c<strong>Product Categories<\/strong>\u201d for example, to filter order which are not in \u201c<strong>Decor<\/strong>\u201d category:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose \u201c<strong>Not in<\/strong>\u201d from the \u201c<strong>Condition box<\/strong>\u201d in front of \u201c<strong>Product Category<\/strong>\u201d<\/li>\n\n\n\n<li>Select \u201c<strong>D\u00e9cor<\/strong>\u201d from the category list in the \u201c<strong>Selection Box<\/strong>\u201d<\/li>\n<\/ul>\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\/2021\/05\/10-Product-Categories.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"606\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Product-Categories.jpg\" alt=\"Filter orders by Product categories\" class=\"wp-image-1024\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Example 3: WooCommerce Filter orders by product attributes<\/strong><\/h4>\n\n\n\n<p>The good news about our plugin is displaying all \u201c<strong>Attributes<\/strong>\u201d you have already assigned to your products in the \u201c<strong>Filter Form<\/strong>\u201d, automatically. So, you can easily filter those orders received for some special products with different attributes.<\/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\/2021\/05\/10-Product-Attributes.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"613\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Product-Attributes.jpg\" alt=\"Filter orders by Product Attributes\" class=\"wp-image-1025\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>For example, let\u2019s try to add an extra filter for Attributes to those products filtered in the previous example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Choose \u201c<strong>And<\/strong>\u201d for the \u201c<strong>Condition Box<\/strong>\u201d<\/li>\n\n\n\n<li>Select \u201c<strong>Grey<\/strong>\u201d and \u201c<strong>Yellow<\/strong>\u201d from the \u201c<strong>Product Color<\/strong>\u201d field<\/li>\n\n\n\n<li>Select \u201c<strong>Not in<\/strong>\u201d for \u201c<strong>Condition box<\/strong>\u201d of \u201c<strong>Product Size<\/strong>\u201d<\/li>\n\n\n\n<li>Choose \u201c<strong>Large<\/strong>\u201d from the list of \u201c<strong>Selection Box<\/strong>\u201d<\/li>\n<\/ul>\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\/2021\/05\/10-Product-Size.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"606\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Product-Size.jpg\" alt=\"add an extra filter for Attributes to those products filtered in the previous example\" class=\"wp-image-1027\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Filter orders by other fields<\/strong><\/h2>\n\n\n\n<p>The remained items that we haven\u2019t mentioned them in the previous tabs are provided here which are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create Via<\/li>\n<\/ul>\n\n\n\n<p>You can filter the filter created by \u201c<strong>Checkout or Amin<\/strong>\u201d after choosing your prefered option from the combo box.<\/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\/2021\/05\/10-Other-Fields-tab.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"573\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Other-Fields-tab.jpg\" alt=\"filtering orders by create via field\" class=\"wp-image-1028\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>WooCommerce filter orders by payment method<\/li>\n<\/ul>\n\n\n\n<p>Two options are provided in the combo box of this field. So you can filter orders by \u201c<strong>Cash on Delivery<\/strong>\u201d or \u201c<strong>Other<\/strong>\u201d payment methods.<\/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\/2021\/05\/10-Payment-Method.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"582\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Payment-Method.jpg\" alt=\"filtering orders by Payment Method field\" class=\"wp-image-1031\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<p>For the rest of Items provided in the \u201c<strong>Other Items<\/strong>\u201d tab, you can choose \u201c<strong>Yes<\/strong>\u201d or \u201c<strong>No<\/strong>\u201d from the combo box in front of each field to filter your orders. These fields are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Shipping Tax<\/li>\n\n\n\n<li>Order Shipping&nbsp;<\/li>\n\n\n\n<li>Coupon Usage Counts<\/li>\n\n\n\n<li>Order Stock Reduced<\/li>\n\n\n\n<li>Prices Index Tax<\/li>\n\n\n\n<li>Recorded Sales<\/li>\n<\/ul>\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\/2021\/05\/10-Shipping-Tax.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"568\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2021\/05\/10-Shipping-Tax.jpg\" alt=\"filtering by shipping tax\" class=\"wp-image-1034\" style=\"object-fit:cover\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>WooCommerce filter orders by custom fields<\/strong><\/h2>\n\n\n\n<p>The fields of the \u201c<strong>Custom Fields<\/strong>\u201d tab will be displayed to you just after you add some fields from the \u201c<strong>Meta Fields<\/strong>\u201d section to it as we described.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Read More:<\/strong> <a href=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/how-to-add-custom-fields-meta-key-to-woocommerce-bulk-order-editing-plugin\/?utm_source=docs&amp;utm_content=filter-orders\" target=\"_blank\" rel=\"noreferrer noopener\">How to add custom field \/ meta key to WooCommerce bulk edit plugin?<\/a><\/p>\n<\/blockquote>\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\/Shipping-Tax-1.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"274\" src=\"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-content\/uploads\/sites\/7\/2024\/04\/Shipping-Tax-1.jpg\" alt=\"filtering orders by Custom Fields\" class=\"wp-image-1869\"\/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>WooCommerce filter orders according to various fields such as \u201corder status\u201d or \u201corder date\u201d or \u201corder price\u201d is simply possible on OBULKiT \u2013 Bulk Edit WooCommerce Orders Plugin by using the \u201cFilter Form\u201d. In this tutorial, we are going to introduce all fields provided in the \u201cFilter Form\u201d. It help you filter the custom orders [&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-963","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\/963","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=963"}],"version-history":[{"count":7,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/posts\/963\/revisions"}],"predecessor-version":[{"id":2707,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/posts\/963\/revisions\/2707"}],"wp:attachment":[{"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/media?parent=963"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/categories?post=963"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/wp-json\/wp\/v2\/tags?post=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}