Bulk Table Editor helps you set up sales and perform bulk updates of products. The editor has a high focus on price, sales, and stock values.
Installation ↑ Back to top
- Download the .zip file from your WooCommerce account.
- Go to: WordPress Admin > Plugins > Add New to upload the file you downloaded with Choose File.
- Activate the extension.
More information at: Installing and Managing Plugins.
Setup and Configuration ↑ Back to top
Settings for Bulk Table Editor
To find the settings, go to: WooCommerce > Settings > Products > Bulk Table Editor.
Available settings for Bulk Table Editor is products per page, default product category, allow infinity sale price, automatic stock management and date picker format for table.
- Products per page: Number of product rows in the table is used in the paging function, default 50 product rows.
- Default product category: Select a category, will show the selected every time you enter plugin page, default is all products.
- Allow infinity sale price: If you want to allow sale on products without start and end date, default this is not allowed and is unchecked.
- Automatic stock management: If you want to turn of stock management i.e you do not use stock for some or all items but still want stock status to be in stock or whatever you have set.
- Table date format: Select the format you want for the date picker in the table. WordPress date format will show before and after saving.
Usage ↑ Back to top
You are now ready to use Bulk Table Editor. To start Bulk Table Editor, in the admin menu find Products > Bulk Table Editor.
Video ↑ Back to top
See the short introduction video to Bulk Table Editor below.
The video shows how to set up a sale using bulk functions and how to work with single values in the table.
Understanding bulk functions ↑ Back to top
The Bulk Editor is optimized to work with stock, prices and sales in your WooCommerce shop. So let us start by looking at the bulk update features.
You will find the bulk functions at the top of the table – the second header. Let us see how this works.
Stock ↑ Back to top
To bulk-update stock, enter an amount in the input field for stock, then find the select option box below.
In the dropdown, select increase or decrease then the amount will be added to all visible products in the table. On the left side in the table you will see that the checkboxes has been checked of, if there is products you do not want to update – just uncheck them.
You can also set a fixed value if you do not want to, set the value and in the dropdown box select set fixed, now all rows has this value. When ready, select the Save all button at the top right of the table.
Automatic stock management is an option set in settings. This can be used if you do want to automatically turn of stock management on items with null values and default set in stock on these products. If you for some reason decide that a product now needs to use stock, just enter the stock value i.e 10 then stock management automatically is turned on again and set the default in stock status.
Price ↑ Back to top
To bulk-update your current prices, enter a value in the input field for price. Then use the select dropdown box below and select one of the options, increase/decrease in percent or increase/decrease fixed amount.
The amount you have will then be calculated and increased/decreased on every row of the table. Then uncheck products you do not want to change and enter the Save all button.
If the prices are not set or you want to overwrite the current price with a fixed price, add your product price and in the dropdown box select set fixed amount. Now the product rows will be set with your price.
Sale price ↑ Back to top
The bulk update function for sale price is the same as for price with the exception that you also have to set a sale start and a sale end date.
If you want infinity sales on your products with no start and end dates you need to go to the settings page for Bulk Table Editor and check the option for this. The sale price will be calculated based on the current price on the product. So if you want a 20% sale on you products it will calculate this based on the current product price.
If the sale prices are not set or you want to overwrite the current sale price with a fixed sales price, add your product sale price and in the dropdown box select set fixed amount. Now the product sales price rows will be set.
Sale start and sale end dates ↑ Back to top
The sale start and sale end date input fields at the top header – right of the table, enter the input field and a dropdown date selector is shown, select the dates of your sale. After selected the dates the table columns will be inserted with the dates you selected. Then just uncheck the ones you do not want to have on your sale and enter the Save all button.
FAQs ↑ Back to top
How do I change product categories and view all my products again? ↑ Back to top
To filter a product category, enter the select a category dropdown box and just select a product category. If you need to go back to all products you can use the default option – Select category – to get back to all your products.
I have a sale but the sale start date is missing, is that normal? ↑ Back to top
Yes, if the sale is ongoing and the sale start date is before today the field for sale start date is empty. As soon as the sale is over the sale end date field will also be empty. Empty sale start and end dates indicate – no current sale on the product.
After I save sales prices the editor shows null values, why? ↑ Back to top
If you save sales prices without any sale start and sale end dates the editor will return null values for sale dates. This is by default not allowed, but if you like to do that and have infinity sales on your products just go to WooCommerce > settings > products > Bulk Table Editor and find and check Allow infinity sale price.
How do I search for products? ↑ Back to top
To search for products just enter a keyword in the search box in the top right on the page and hit enter or click the search icon. If, wherever you are like to go back to all products you can just use an empty search and hit enter in the input field or click the search icon.
I have a lot of products, is there a paging function? ↑ Back to top
Yes, there is a paging function and you find it above the table on the right side. Paging is shown on the page if product count is more than in the settings – products per page – default 50 product rows. Use the next/previous (<< or >>) page buttons as you like. In settings for WooCommerce > products > Bulk Table Editor you will find this settings.
I have created products and variations, can I bulk set their prices? ↑ Back to top
Yes, when you create products or variations the price is not set. In Bulk Table Editor find the product or variable product rows and use the bulk function for price, add i.e 30 and in the dropdown below select set fixed amount. Then save, the products or variations has now a price. See image above sale price.
Can I set the sales prices to a fixed amount? ↑ Back to top
Yes, if you want to set a price or sales price to a fixed one you can do this. In Bulk Table Editor use the bulk function for sale price, add i.e 9.99 and in the dropdown below select set fixed amount. Then save, the products has now a new set sale price. This function overwrites old values when used. See image above sale price.
Can I sort and order the table? ↑ Back to top
Yes, every column that has a up/down arrow is possible to use for sorting. Just click the header link and you will sort the table on that column ascending or descending.
Can I use the table editor to update single products? ↑ Back to top
Using the table to change single values is possible for updating product values. If you have mouse over a field the input is automatically selected. After entering a value and moving to another field, note that the checkbox for that row is checked. When you use the Save all button only rows with checkbox checked is saved. If you change stock or price you will see that the table calculates stock value (right column) and give you a total in the bottom. The totals is based on the products you see in the table.
Example ↑ Back to top
If you sell clothing and want to set up a sale on your category T-Shirts. In Bulk Table Editor this is an easy task. Just select the category i.e T-Shirts and enter a value in the bulk function for sale price i.e 20 and select in the dropdown box – decrease in %. Bulk Table Editor then calculates a 20% sale based on your regular product price and add it to all your products in the category T-Shirts.
After this you just need to set a sale start and a sale end date. This is done by selecting the dates in the bulk functions for start and end date, Bulk Table Editor then fills the rows for you automatically. Just uncheck products you do not want on sale and click the save all button.
Uninstalling ↑ Back to top
In WordPress > plugins find Bulk Table Editor and deactivate and if you want – delete. If deleting the plugin, the plugin files will be removed from your WordPress installation. If the plugin is deactivated or deleted, your product data will not be affected.