{"id":730,"date":"2021-05-04T13:28:57","date_gmt":"2021-05-04T13:28:57","guid":{"rendered":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/?p=730"},"modified":"2024-04-23T06:13:35","modified_gmt":"2024-04-23T06:13:35","slug":"change-multi-order-billing-fields","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/docs\/woocommerce-bulk-orders-editing\/change-multi-order-billing-fields\/","title":{"rendered":"How to change multi order billing fields at the same time?"},"content":{"rendered":"\n
Change multi order billing fields at the same time is simply possible via \u201cBulk Edit Form<\/strong>\u201d in WooCommerce bulk order editing plugin. <\/p>\n\n\n\n We categorized all fields related to the order billing such as first and last name of customers, their address or Email in a specific tab of \u201cBulk Edit Form<\/strong>\u201d. It allow you to bulk edit their values by setting the proper condition or choosing your preferred data in a few seconds.<\/p>\n\n\n\n Follow us to investigate more about bulk editing order billing fields in our plugin.<\/p>\n\n\n\n To change multi order billing fields, at first you need to install WooCommerce bulk orders editing plugin<\/a>. Then you have access to the main page by navigating to the below address:<\/p>\n\n\n\n WordPress Dashboard > Pro bulk bundle > WOO orders<\/em><\/strong><\/p>\n\n\n\n As shown below, we provided a lot of options at the main page with a lot of amazing features that are described in other tutorials.<\/p>\n\n\n\n You have access to \u201cBulk Edit Form<\/strong>\u201d from the main page by clicking on the \u201cBulk Edit<\/strong>\u201d button.<\/p>\n\n\n\n To change multi order billing fields, you can simply go to the \u201cBilling\u201d<\/strong> tab in this form. In this tab you can see the related fields categorized including: <\/p>\n\n\n\n These fields are exactly the same as what you have set in the \u201cWooCommerce Order Billing section<\/strong>\u201d. You are able to bulk edit them according to your requirements by using the flexible methods designed in the \u201cBulk Edit Form<\/strong>\u201d of our plugin which are:<\/p>\n\n\n\n Let\u2019s take a look at the options available in the \u201cBilling<\/strong>\u201d tab to completely understand how these methods can help you to change multi order billing fields at the same time.<\/p>\n\n\n\n As you can see in the \u201cBilling<\/strong>\u201d tab, there are two boxes in front of some items such as \u201cBilling First Name\u201c<\/strong>or \u201cBilling City<\/strong>\u201d:<\/p>\n\n\n\n These boxes are designed to enable you to easily change the data related to the multi order billing fields. <\/p>\n\n\n\n \u201cCondition box\u201d<\/strong> is designed as a combo box with a list of options that you can choose to be applied to the value you type in the \u201cText box\u201d<\/strong>. These options include:<\/p>\n\n\n\n In the \u201cText box\u201d<\/strong>, you can type any value including text, symbols or numbers to instruct our plugin to change the current value of the relevant field according to this data and the condition selected in the \u201cCondition box\u201d<\/strong>. <\/p>\n\n\n\n Choosing items from a combo box is useful when there are some default items that you need to choose one of them to be assigned to a special field. <\/p>\n\n\n\n We have provided a complete database including all countries with their states and listed them in a combo box to help you change these fields for multi order billing quickly.<\/p>\n\n\n\n According to below image, by clicking on the combo box in front of \u201cBilling Country<\/strong>\u201d field, an alphabetical orders list of all countries in the world will appear and you can choose one of them to be assigned to the orders.<\/p>\n\n\n\n As soon as choosing one country, its related states will be added to the combo box of \u201cBilling State<\/strong>\u201d field. So, you can easily find your preferred state from the list and choose it to change state of multi order at the same time.<\/p>\n\n\n\n To better understand the functionality of the above-mentioned options, we are going to make some examples of using them to change the values of multi order billing fields.<\/p>\n\n\n\n However before going further, it sounds great if we take a look at the initial values of each field to better observe how our changes work in the following examples.<\/p>\n\n\n\n As we described in \u201cHow to manage order columns on WooCommerce bulk orders editing?<\/a>\u201d tutorial, to see the current value of each field, you can easily add its column to the order table from the \u201cColumn Profile<\/strong>\u201d form <\/p>\n\n\n\n So, let\u2019s just do the same and add all \u201cBilling<\/strong>\u201d fields to the order table:<\/p>\n\n\n\n Now, you can see all values assigned to each \u201cBilling<\/strong>\u201d field directly in the table and compare them with the values after making changes in our examples.<\/p>\n\n\n\n To limit the changes to some specific orders with ID No.483, 485, 487 we filtered them by using \u201cQuick Search<\/strong>\u201d as shown below:<\/p>\n\n\n\n Now, it\u2019s time to change some billing fields of those filtered orders by setting the conditions in the \u201cBulk Edit Form<\/strong>\u201d.<\/p>\n\n\n\n To add \u201c-New order”<\/strong> to the end of \u201cBilling First Name\u201c<\/strong>:<\/p>\n\n\n\n As we expected \u201c-New order”<\/strong> was append to the first name of those filtered orders:<\/p>\n\n\n\n Now let\u2019s try adding \u201cNew<\/strong>” to the beginning of \u201cBilling Last Name<\/strong>\u201d by:<\/p>\n\n\n\n It is not surprising that \u201cNew<\/strong>” was added to the beginning of last names:<\/p>\n\n\n\n If you choose \u201cNew<\/strong>” from the condition box of \u201cBilling Address 1\u201d<\/strong> and type \u201cFirst Street<\/strong>” in the opposite \u201cText box\u201d<\/strong>, as we did below:<\/p>\n\n\n\n All current values of \u201cBilling Address 1<\/strong>\u201d field will be removed and then replaced by \u201cFirst street<\/strong>” after pressing the \u201cDo Bulk Edit<\/strong>\u201d button.<\/p>\n\n\n\n To see the result of this change, you need to click on the \u201cShow Address<\/strong>” button in the order table under \u201cBilling Address 1<\/strong>\u201d column:<\/p>\n\n\n\n Before opening the \u201cBulk Edit<\/strong>\u201d form and delete the values of \u201cBilling Address 2<\/strong>\u201d, let\u2019s see the current value of the first order by clicking on the \u201cShow Address<\/strong>\u201d button of this column:<\/p>\n\n\n\n Now, consider that we want to delete this value. To do this, we need to:<\/p>\n\n\n\n As you can see in the below picture, the value was removed:<\/p>\n\n\n\n In this example, we want to replace \u201cBilling City<\/strong>\u201d of those filtered orders which is \u201cNew York<\/strong>\u201d by \u201cWashington<\/strong>\u201d. so, we have to:<\/p>\n\n\n\n As you can see there is another box next to this part which contains a list of some default items to help you add them to that field if you need.<\/p>\n\n\n\n For example, let\u2019s type \u201c,<\/strong>\u201d as a separator then choose \u201cSale Price<\/strong>\u201d from this \u201cVariable box\u201d<\/strong><\/p>\n\n\n\n Now, press the \u201cDo Bulk Edit<\/strong>\u201d button to see what will happen.<\/p>\n\n\n\n As shown below, \u201cNew York<\/strong>\u201d was replaced by \u201cWashington, 200<\/strong>\u201d:<\/p>\n\n\n\n Inline Edit and Bind Edit are two useful options provided by our plugin to enable you edit the orders directly from the order table.<\/p>\n\n\n\n To use both methods, you need to add the proper columns to the order table then by following the below guide you can easily change any data in the table.<\/p>\n\n\n\n \u201cInline edit<\/strong>\u201d enables you to change the data of one column related to the one order from the table.<\/p>\n\n\n\n For example, let\u2019s try to change the data of the \u201cAll BILLING<\/strong>\u201d column of the first order.<\/p>\n\n\n\n To do this, you need to:<\/p>\n\n\n\n As shown below, a new form will appear as a pop-up and you are able to change any data in this form. <\/p>\n\n\n\n \u201cAll BILLING<\/strong>\u201d is a special and effective form displaying all fields related to an order to you that you have just access to edit it from the order table by inline edit. <\/p>\n\n\n\n In this form, you can easily change any data such as:<\/p>\n\n\n\n For example, you can:<\/p>\n\n\n\n \u201cBind Edit<\/strong>\u201d is an option that enables you to change multi order data at the same time from the order table. All steps for changing data in the order table are the same as \u201cInline Edit<\/strong>\u201d, except you need to mark \u201cBind Edit<\/strong>\u201d at the top of the main page and also mark those orders you need to be bulk edited.<\/p>\n\n\n\n For example, let\u2019s try to change the \u201cBilling Company<\/strong>\u201d data of some orders to \u201cIThemelandco<\/strong>.\u201d<\/p>\n\n\n\nChange multi order billing fields at the same time<\/strong><\/h2>\n\n\n\n
<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
\n
Set a condition to apply to a value <\/strong><\/h2>\n\n\n\n
\n
Condition box<\/strong><\/h3>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
Text box<\/strong><\/h3>\n\n\n\n
Selecting a value from a Combo box<\/strong><\/h2>\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
Use \u201cAppend\u201d condition to change multi order billing fields <\/strong><\/h2>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Use \u201cPrepend\u201d condition to change multi order billing fields<\/strong><\/h2>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Use “New” condition to change multi order billing fields<\/strong><\/h2>\n\n\n\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Use “Delete” condition to change multi order billing fields<\/strong><\/h2>\n\n\n\n
<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Use \u201cReplace\u201d condition to change multi order billing fields<\/strong><\/h2>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
<\/a><\/figure>\n\n\n\n
Change multi order billing fields by \u201cBind Edit\u201d<\/strong><\/h2>\n\n\n\n
Inline edit<\/strong><\/h3>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
\n
<\/a><\/figure>\n\n\n\n
\n
Bind Edit<\/strong><\/h3>\n\n\n\n
\n