{"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":"2024-04-20T10:49:07","modified_gmt":"2024-04-20T10:49:07","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 WooCommerce bulk orders editing plugin?"},"content":{"rendered":"\n
WooCommerce filter orders according to various fields such as \u201corder status\u201d or \u201corder date\u201d or \u201corder price\u201d is simply possible on WooCommerce bulk orders editing plugin<\/a> by using the \u201cFilter Form<\/strong>\u201d.<\/p>\n\n\n\n In this tutorial, we are going to introduce all fields provided in the \u201cFilter Form<\/strong>\u201d. It help you filter the custom orders you need to be bulk edited in less than a few minutes. <\/p>\n\n\n\n To open the \u201cFilter 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 WordPress Dashboard > Pro bulk bundle > Woo Orders <\/strong><\/p>\n\n\n\n We designed the \u201cFilter 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.\u00a0<\/p>\n\n\n\n By clicking on the \u201cFilter Form<\/strong>\u201d button, this form with all of your required fields for filtering custom orders will be displayed. <\/p>\n\n\n\n As illustrated below, to help you find the preferred fields easier, we divided \u201cFilter Form<\/strong>\u201d into seven categories including:<\/p>\n\n\n\n Now, let\u2019s find out which fields are supported in each category. <\/p>\n\n\n\n The most popular fields related to the orders are provided in the \u201cGeneral tab<\/strong>\u201d. It helps enable you to filter orders accordingly which are:<\/p>\n\n\n\n To filter orders according to the \u201cFilter ID<\/strong>\u201d. You just need to type one or more \u201cID numbers<\/strong>\u201d like the below examples in the Text box.<\/p>\n\n\n\n If the \u201cID numbers<\/strong>\u201d are not in order, you can separate them by \u201c,<\/strong>\u201d such as 1, 17, 33.<\/p>\n\n\n\n If the \u201cID numbers<\/strong>\u201d are in order. For example, when you need all \u201cID numbers<\/strong>\u201d between 2 and 5, you can type them as a range by using \u201c–<\/strong>\u201cbetween two numbers like \u201c3-5<\/strong>\u201d.<\/p>\n\n\n\n These fields are useful when you need to filter orders according to their \u201cOrdered date, Modified date or Paid date<\/strong>\u201d. The interesting option that our plugin supported 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 For example, we tried to filter those orders received from 2021\/01\/13 20.00 to 2021\/01\/24\u00a0 21.00 by using the \u201cCalendar<\/strong>\u201d as shown below.\u00a0<\/p>\n\n\n\n \u201cCustomer IP address<\/strong>\u201d is another field that you can filter orders regarding to it by choosing one of the below conditions:<\/p>\n\n\n\n In the \u201cStatus<\/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 If you define any other order status in the WooCommerce, the condition will be added automatically to this list. Then you can choose it to filter the orders accordingly. <\/p>\n\n\n\n In the \u201cBilling<\/strong>\u201d tab, we have listed all fields related to the order billings that you have set before in the WooCommerce.<\/p>\n\n\n\n As shown below, the most popular fields in the order billings are provided in this tab such as:<\/p>\n\n\n\n You can enter a value in the text box in front of each one and choose a condition from the \u201cCondition box<\/strong>\u201d. This let the plugin filter the orders according to them.<\/p>\n\n\n\n The items provided in the \u201cCondition box<\/strong>\u201d are the same as the items we described for the \u201cCondition box<\/strong>\u201d of \u201cIP<\/strong> address<\/strong>\u201d in the \u201cGeneral<\/strong>\u201d tab.<\/p>\n\n\n\n To make it clear for you, let\u2019s try using some of them for filtering our orders: <\/p>\n\n\n\n For example, if we choose \u201cLike<\/strong>\u201d from the \u201cCondition box<\/strong>\u201d of \u201cBilling Name<\/strong>\u201d field and type \u201cCustomer<\/strong>\u201d in the text box in front of it, as illustrated below:<\/p>\n\n\n\n All the orders that their \u201cBilling Name<\/strong>\u201d include \u201cCustomer<\/strong>\u201d will be filtered after clicking on \u201cGet Orders<\/strong>\u201d button:<\/p>\n\n\n\n We can also filter all orders that are received from \u201cSmith<\/strong>\u201d by typing \u201cSmith<\/strong>\u201d in the text box of \u201cBilling Last Name<\/strong>\u201d and choosing \u201cExact<\/strong>\u201d from the Condition box:<\/p>\n\n\n\n So, the result is exactly according to our expectation after clicking on \u201cGet Orders<\/strong>\u201d button:<\/p>\n\n\n\n This is also possible to exclude \u201cArizona<\/strong>\u201d from the list of cities which are going to be filtered for us by:<\/p>\n\n\n\n Which will result in:<\/p>\n\n\n\n One of the most advantages of our plugin is providing a complete database of all countries with their states in the world. This means if you are developing your business internationally and your customers are sending their orders from all over the world to your ecommerce website. You can easily and quickly filter their orders according to their countries and even their states.<\/p>\n\n\n\n To show you how this field can filter the orders for a special state in a country, consider you have received some orders from \u201cNew South Wales, Australia<\/strong>\u201d and you need to filter them.<\/p>\n\n\n\n To do this, click on the combo box in front of \u201cBilling Country<\/strong>\u201d and find \u201cAustralia<\/strong>\u201d.<\/p>\n\n\n\n As soon as choosing \u201cAustralia<\/strong>\u201d, our plugin will automatically make a list from the states of that country in the combo box in front of \u201cBilling State<\/strong>\u201d field.\u00a0<\/p>\n\n\n\n Then you can find \u201cNew South Wales<\/strong>\u201d and select it.<\/p>\n\n\n\n Finally, by clicking on \u201cGet Orders<\/strong>\u201d, these orders will be filtered as you expected.<\/p>\n\n\n\n The fields supported in the \u201cShipping<\/strong>\u201d tab enable you to filter the orders according to the shipping information which are:<\/p>\n\n\n\n You can use \u201cCondition<\/strong>\u201d boxes, \u201ctext boxes<\/strong>\u201d and \u201cCombo boxes<\/strong>\u201d in front of each field to filter the orders exactly as we described for the fields provided in the \u201cBilling<\/strong>\u201d tab.<\/p>\n\n\n\n For example, if you choose \u201cUnited State<\/strong>\u201d from the \u201cShipping Country<\/strong>\u201d dropdown list: <\/p>\n\n\n\n A list of \u201cUS states<\/strong>\u201d will be available in the \u201cShipping 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 In the Pricing tab, you have access to the below fields and you can filter orders regarding them:<\/p>\n\n\n\n \u201cOrder 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. <\/p>\n\n\n\n All currencies are supported in our plugin and you can choose each one from the combo box in front of \u201cOrder Currency<\/strong>\u201d to filter orders.<\/p>\n\n\n\n There are also other fields in the pricing tab which are:<\/p>\n\n\n\n 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 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 In the \u201citems<\/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 To take the most advantages of these fields, we provide two boxes in front of each field including:<\/p>\n\n\n\n In the \u201cCondition box<\/strong>\u201d you can choose one of the below items:<\/p>\n\n\n\n In the \u201cSelection 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 Let\u2019s see how these conditions will filter the order in our plugin by some examples:<\/p>\n\n\n\n In this example, we are going to filter orders received for \u201cV-Neck-T-Shirt-Blue<\/strong>\u201d or \u201cLogo Collection<\/strong>\u201d.<\/p>\n\n\n\n To do this, we simply choose \u201cOR<\/strong>\u201d from \u201cCondition box<\/strong>\u201d in front of \u201cProduct<\/strong>\u201d field:<\/p>\n\n\n\n Type some part of the \u201cProduct title<\/strong>\u201d in the text box:<\/p>\n\n\n\n To see a list of Products with that letters:<\/p>\n\n\n\n Choose our prefered products from the list:<\/p>\n\n\n\n By clicking on the \u201cGet Orders<\/strong>\u201d button, the orders received for both products will be filtered and displayed in the order table.<\/p>\n\n\n\n We can do the same for \u201cProduct Categories<\/strong>\u201d for example, to filter order which are not in \u201cDecor<\/strong>\u201d category:<\/p>\n\n\n\n The good news about our plugin is displaying all \u201cAttributes<\/strong>\u201d you have already assigned to your products in the \u201cFilter Form<\/strong>\u201d, automatically. So, you can easily filter those orders received for some special products with different attributes.<\/p>\n\n\n\n<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
General tab<\/strong><\/h2>\n\n\n\n
Filter orders by ID<\/strong><\/h3>\n\n\n\n
Filter orders by date \/ modified date \/ paid date<\/strong><\/h3>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Filter orders by customer IP address <\/strong><\/h3>\n\n\n\n
\n
\n
<\/a><\/figure>\n\n\n\n
Filter orders by status<\/strong><\/h3>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
Billing tab<\/strong><\/h2>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Filter orders by billing country and billing state fields<\/strong><\/h3>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Shipping tab<\/strong><\/h2>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a>
Pricing tab<\/strong><\/h2>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Filter orders by currency<\/strong><\/h3>\n\n\n\n
<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
Items tab<\/strong><\/h2>\n\n\n\n
Condition box<\/strong><\/h3>\n\n\n\n
\n
Selection box<\/strong><\/h3>\n\n\n\n
Example 1: WooCommerce filter orders by Products<\/strong><\/h4>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Example 2: WooCommerce filter orders by product categories<\/strong><\/h4>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
Example 3: WooCommerce Filter orders by product attributes<\/strong><\/h4>\n\n\n\n