WooCommerce Product Table

Filter Product

The most effective option in our plugin is filtering the products that you are going to bulk edit any features of them.

To make it clear, we completely described using Filter Form in “How to filter products on Woocommerce bulk product editing”. 

So, by getting help from that tutorial, we tried to filter products which are not in the Décor and Music category and also they are among variable products.

Choose suitable columns

As we are going to bulk edit attributes and variations, it makes sense to choose those columns to be displayed in the product table.

As we mentioned in “How to manage product columns on Woocommerce bulk product editing”, you can easily select all attributes assigned to the products in the Woocommerce to be shown in the product table as below:

• Open “Column Manager” tab
• Select attributes – Such as Color or Size – from the list
• Add them as your preferred columns
• Save this profile by typing a name such as “Bulk Edit Attributes”

By saving this profile as a preset, you have always access to it by opening the dropdown list in the Column Profile page. After choosing this preset and clicking on “Apply to Table”, you can see the Attribute columns in your product table

How to change multi product variations at the same time? 

To bulk edit attributes in our plugin, a special button called “Variation” in the main page is designed:

By clicking on “Variation” button, a new form will appear on the screen with three different parts including:

• Set Variations
• Delete Variations
• Attach/Change variations

To see the features we provide for you in each tab, follow this complete guide.

Set Variation 

In the “Set Variation” tab, you can choose the variations you want to bulk edit by clicking on the box under “Product Attributes”:

If you have already assigned some attributes to these variations, a new box for each variation will appear which enable you to select the attributes you want to assign to the filtered products.

For example, in this tutorial we chose Color and Size as the Variations then we selected “Gray” and “Red” as the attributes related to the color and “Large” and “Medium” related to the Size.

Note: All variations and attributes that you add to the Woocommerce will be automatically shown in this form and you have full access to all of them to be assigned to your products.

After choosing the right attributes, there are two options that you have to choose one of them as:

• All Combinations
• Individual Combinations

By choosing one of these options in the “Set Variation” tab, the current attributes of products will be totally replaced by the ones you select in this form. So, if you don’t want to remove the current attributes and you need to add some attributes to the previous ones, you have to go to another tab called “Attach/Change Variations” which we will explain later in this tutorial.

To explain these options related to bulk edit attributes clearly, let’s try to bulk edit our filtered products according to them:

All Combination

By choosing “All Combination” and clicking on “Generate”, the plugin will automatically produce all possible combinations regarding the selected attributes.

For example, as we selected “Gray” and ”Red” for Color and “Large” and “Medium” for Size, the combinations are:

• Gray-Large
• Gray-Medium
• Red-Large
• Red-Medium

Which are produced by the plugin as we expected to bulk edit attributes:

In the new list of combinations shown in the right side of the form, you have some extra options including:

• Moving combination: You can drag and drop items to change their orders as shown in the above picture
• Select the default combination: If you click on the circle in front of each combination, it will be assigned as default combination.
• Select preferred combination: By marking the checkbox next to each combination, you can choose which one to be assigned to the filtered products.

For example, among the produced attribute combinations we marked:

• Gray-Large
• Gray-Medium
• Red-Medium

Now by clicking on “Do Bulk Variations”, these selected attributes will be assigned to those products we have already filtered.

Individual Combination

As the name of this option revealed, you can only choose one attribute combination to bulk edit attributes of filtered products.

For example, we selected “Small” related to Size and “Yellow” related to Color.

If you have already chosen more than one attributes related to each variations, a list of attributes will be shown and you are able to select one of them from the list:

Then by clicking on “Add” button, the combination related to these attributes will show to you:

And you are able to set it as default or mark it to add to the product attributes. By clicking on “Do Bulk Variations”, the attribute combination will be added to the filtered products as below: 

Delete Variation

There are two options available in the “Delete Variation” tab to bulk edit attributes as:

• All variations: All current variations assigned to the filtered products will be deleted.
• Single Variation: This option helps you to delete some attributes related to the filtered products. 

To make it clear, consider that we want to remove “Gray” from attributes of selected products.

This is simply possible by selecting the color from the dropdown variation list:

Then choose “Gray” from the related attribute list:

By clicking on “Delete Variation”, the changes are made as we expected in the product table.

Attach/Change Variations

As we mentioned before, if you want to add some attributes to the current ones, “Attach/Change Variations” tab is the right option for you.

In this tab, you can choose the variation such as color or size from the dropdown list under Select Attributes to bulk edit attributes:

Then select the attributes related to that variation from the next dropdown list:

By clicking on the “Attaching” button, this attribute will be added to the previous attributes of the filtered/selected products.

There is also another possibility in the “Attach/Change Variation”. For example, consider that you want to add attributes to one of your products.

In this tab, you can easily enter the ID of the product in the “Variable Product ID” text box to see the attributes assigned to it.

For example, to see the attributes related to the ID Number “30”, we typed “30” in the text box and clicked on “Get Variations”:

As you can see, the list of all attributes assigned to the product with ID Number “30” is displayed and you are easily able to add the attributes of variation you have already selected under “Select Attribute” list to this product:

When you choose the right attributes, you can assign them to the selected product by clicking on “Attaching”.

For example, we choose “Blue” related to “Color” to add to the attributes of product with ID Number “30” which resulted in:

Step 1: Filter your products

To filter the products that their tax status must be edited, you can easily open the “Filter Form” from the main page of the plugin, then filtering products according to their features as we described in “How to filter products on Woocommerce bulk product editing”.

In this tutorial, we want to bulk edit multi product tax settings of “In Stock” products. So, we choose “In Stock” from the dropdown list of “Stock Status” in the “Stock” tab of Filter Form. 

Step 2: Choose the TAX Columns

Choosing Tax columns to be displayed in the product table can help you track the changes you have made in the product tax status. However, this option has no effect on bulk editing or changing multi product tax settings.

So, if you just want to quickly change multi product tax settings without monitoring the changes in this plugin, you can skip this step and go to the next one directly.

As we are going to show you how our plugin can change the Tax status of products, it make sense to select “Tax Status” and “Tax Class” from “Column Profile” popup to be shown for our filtered products in the main page:

If you need any help in selecting suitable columns, please refer to another tutorial “How to save and load column profiles on Woocommerce bulk product editing plugin”

As you can see, “In Stock” products with the Tax Status are displayed in the product table of our plugin:

Now it’s the time to change multi product tax settings in the final step.

Step 3: Change Multi product tax settings

To change multi product tax settings, you have to select desired products and open the “Bulk Edit” Form and click on the “Pricing” tab.

In this tab, two options are designed to help you bulk edit tax settings of filtered products, including:

• Tax Status
• Tax Class

In front of “Tax Status”, a list including all Tax status set in Woocommerce for your products are displayed and you can choose one of them as the Tax Status of your products.

As it is show below, we have three options including:

• Taxable: Tax will be added to the price of product
• Shipping Only: Tax will be only added to the shipping price 
• None: No Tax is included

You can also select the options related to the “Tax Class” from the drop down list in front of this field which are:

• Reduced Size
• Zero Rate

Note: If you set any other Tax Class in the Woocommerce settings, it will be automatically displayed here and you can choose from the list.

Change multi product shipping settings 

To bulk edit shipping settings you have to click on “Bulk Edit” button, and then open the “shipping” tab.

In this tab you have access to the following options:

Shipping class

A combo box is provided for this field including a list of all shipping classes that you have already added to the Woocommerce shipping settings. 

So, you are able to choose from them to be assigned to the products filtered before.

Shipping Dimensions

For shipping dimensions, you can bulk edit the following:

• Width
• Length
• Height
• Weight

By using below conditions:

• Set New: The current data will be replaced by the value you typed in the text box 
• Clear Value: All current values will be removed
• Formula: You can set a new value based on the current value (X) and your preferred formula
• Increase/Decrease by Value: The current value will be increased / decreased by the value you typed in the text box 
• Increase/Decrease by %: The current value will be increased / decreased by the value% you typed in the text box 

Let’s try to see how our previous data will be changed by set the following conditions:

• Width: Set new value to “20”
• Height: Increased the values by “30”
• Length: Decreased the values by 50%
• Weight: Bulk edit according to the formula: (X-100)*20%

By clicking on “Do Bulk Edit”, we expected to see the new values as below:

• Width: All of them changed to “20”
• Height: The current values + 30 = 20 + 30 = 50
• Length: The current value * 50/100 = 50 * ½ = 25
• Weight: (The current value – 100) * 20/100 = (600 – 100) * 2/10 = 800 / 10 = 80

As it is obvious, the plugin calculated all values perfectly

Manage Stock

By clicking on “Bulk Edit” you are able to change multi product stock settings at the same time by opening the “Stock” tab.

In the “Stock” tab you can bulk edit stock settings according to your requirements by making changes in those fields that we have already added to our product table.

As shown below, to bulk edit “Manage Stock” you have to select “Yes” or “No” from the drop down list:

Stock status

In the “Stock Status” field, we provide you three different options in a combo box including:

• In stock
• Out of stock
• On backorder

So, you can choose one of the options that suit your products.

Stock quantity

To specify the stock quantity of your products, you can choose one of the below actions:

• Set New: All current stock quantities will be replaced by the value you enter in the text box.
• Clear Value: All current stock quantities will be removed.
• Formula: All current stock quantities (X) will be changed according to the formula you entered in the textbox.
• Increase / Decrease by value: All current stock quantities will be decreased / increase by the value you enter in the text box.
• Increase / Decrease by %: All current stock quantities will be decreased / increase by the value% you enter in the text box.

Note: We explained completely using all of these options in “How to bulk edit sale price of products in Woocommerce bulk product editing plugin”. So, you can get more help by referring to that tutorial for changing the stock quantity by using these actions.

Allow backorders

You can select one the below options for “Allow backorders” field:

• Do not allow
• Allow, but notify customer
• Allow

Step 1: Filter simple products

To filter simple products, you need to:

• Go to the main page of our plugin from WordPress dashboard > Pro  bulk bundle > Woo product
• Click on “Filter Form“
• Open ”Type“ tab
• Open the combo box in front of “Product Type“
• Select “Simple Product” from the list
• Click on “Get Product” to filter simple products

You can set other filters to choose the right products. If you need more help for filtering the products, we recommend you to check our tutorial about how to filter products in WordPress Bulk product editing plugin.

Step 2: convert multi simple products To external

To convert multi simple products to external you need to click on the “Bulk Edit” button and continue as following:

• Open the “Type” tab in the bulk edit form 
• Open the combo box in front of “Product Type” 
• Choose “External / Affiliate” product from the list
• Click on “Do bulk edit” 

All simple products we had filtered are now converted to external:

Convert multi simple products to external by bind edit

Bind editing is another way to convert multi simple products to external directly from the product table.

To bind edit simple products you need to follow below actions:

• Add “Product Type” column from the “Column Profile” to the product table
• Filter the right products
• Mark “Bind Edit” in the main page toolbar
• Select the products you need to be converted in the table
• Open the combo box of “Product Type” column in front of one the products
• Choose “External / Affiliate Product” from the list
• Press enter button on keyboard