Setup and Configuration

Settings for Bulk Table Editor

To find the settings, go to: WooCommerce > Settings > Bulk Table Editor

Bulk Table Editor has two sections, the first section is for general settings and the other is for setting up integrations with an other plugins. A custom price field is for example a wholesaler price, MSRP or cost of goods.

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.
Query products by statuses: Default all statuses will be shown in the extension, if you need to filter out some, select the ones you want to see and save.
Automatic stock management: If you want to turn off 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.
Disable autofocus: Select this option if you do not want autofocus when the mouse is over an input field i.e search.
Date selector format: Select the format you want for the date picker in the table. Your WordPress settings for date format will show before and after saving.
Autofocus on date selectors: If checked you the date selector will appear and the date input field will have focus.
SKU generator length: Default the SKU generator use 3 chars like this (product variation): Shirt, blue, large becomes: shi-blu-lar. Use this number option if you want i.e a SKU generated by something else i.e 5 chars(letters) or what you need for your SKUs.
SKU delimiter: Default SKU is created using – and creates SKUs like this: SHI-BLU-LAR, you can change – to . to make SKUs like this: SHI.BLU.LAR

Custom price (slug): Use the price slug for i.e Cost of goods, Wholesaler, Name your price, MSRP or purchaser price. We recommend that this is a price field when it is treated like a number in the table. See the FAQ section on how to find this slug or use the Integrations (get slug) dropdown box for some know slugs.
Custom price name: The custom column name in the table, recommended to keep it short as the table has limited size.
Integrations (get slug): Use this select box to set the slug for Cost of goods (Cost & Reports for WooCommerce), Cost of goods (Cost of goods for WooCommerce) Name your price or other approved integrations. Remember to set a custom name after using this dropdown select box i.e Cost of goods.
Custom price – calculate like sales price: If checked it calculates using normal price like this example: normal price – 20% = custom price. Default (not checked) it calculates like this example: custom price – 20% = new custom price.
Show extra column: Check this to see your custom price or SKU in Editor home.
Show SKU in main page: This option shows SKU with the bulk functions in Editor home and replaces a custom price. Remember to check the option Show extra column if you use this option.
Enable Vendors: This option can be used if you have Product Vendors by WooCommerce. It adds an extra column in Bulk Table Editor where you can bulk set Vendors per products and variations.

Usage

You are now ready to use Bulk Table Editor. To start Bulk Table Editor, in the admin menu find Products > Bulk Table Editor.

Understanding bulk functions

The Bulk Editor is optimised to work with stock, prices and sales in your WooCommerce shop. There is also an Other value table that can bulk update SKU, tags, backorders and measures. You will find a couple of bulk functions to the right of select categories and the rest at the top of the table.

Important: Using bulk functions will mark (check) the rows, if you then save the changes will be updated. You can also check the rows (products / variations) you want to update first – then use the bulk functions (and save) if you like to. And if you regret your actions (before you have saved) – just use the Undo changes button to reset back.

Product filters

There are several ways to filter products in Bulk Table Editor. The three drop-down menus Select Category, Filter Sales and Filter Tags make it easy to find your products. In addition, you can search for products or filter in the table’s contents (rows). Select Category makes queries to the product database on your selected category, then you can set filters such as on sale or on product tags.

Editor home

The default table is the editor home, the grey button shows this. This table have a special focus on prices and setting up sales.

Search

Default you search in rows. The row search includes the first three columns in the table including description and SKU (from vs 2.2.7). When searching in rows, while you type the table starts filtering. If you select text or SKU in the radio buttons below the search field you will do a regular database search (all your products). To reset – just click the search button again.

Stock

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, 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 off the table.

NOTE: From vs 2.2.5 you can select (check) rows / products first then do bulk updates on the selected items.

Automatic stock management is an option set in settings. This can be used if you do want to automatically turn off 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

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. (Remember that you can check items first if you just want to bulk update a few)

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.

Round upwards function will set the price up from i.e 19.51 to 20.00 and if round downwards from 19.30 to 19.00. Round two decimals does this type of rounding: 19.63 becomes 19.60, it uses the logical round up or down based on the decimals.

Get previous price: every time you save the product price (is was) gets saved. This mainly built so you can clear prices on product variations, they will be hidden with no price. When you need the product variations visible again – just use this function and get the price on the products. (read the hide variations below for how to do this)

Sale price

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.

NOTE: If you want infinity sales on your products with no start and end dates just set the sales price and save.

There is four option to increase and decrease sale prices:

Increase
1. Increase by % (from Price)
  1. Uses the current price and calculates i.e 20% and uses this as sale price
2. Increase Saleprice by %
  1. Uses the current sale price and calculates an increase i.e 3% to the existing sale price
3. Increase by fixed amount (from Price) – use the current price and adds a fixed amount to this
4. Increase Saleprice by fixed amount – uses the current sales price and adds your amount
Decrease
1. Decrease by % (from Price)
  1. Uses the current price and calculates i.e minus 20% and uses this as sale price
2. Decrease Saleprice by %
  1. Uses the current sale price and calculates an decrease i.e minus 3% to the existing sale price
3. Decrease by fixed amount (from Price) – use the current price and removes the fixed amount to this
4. Decrease Saleprice by fixed amount – uses the current sales price and removes the amount entered

Set fixed amount: Sets the amount you entered on every row

Get previous sale prices: gets the prices from last sale.

Sale start and sale end dates

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. Remember you can use i.e only start date, only end date, both or none as long as you have sale price on your product. You can also have a sale just for today – just set todays date in start and end date. A sale end time is at: 23:59:59. From vs 2.1.27 you can also enter sale time start and end, just use the time selectors to set this. When using start / end time be sure to check your WP settings > General for time and timezone. Bulk Table Editor uses 24 hour time (so have this in mind if you use AM/PM)

Sale %

Sale in percent does not have any bulk functions, but will be updated if you change your sales value. The value is rounded to be a whole number and is to get a overview over your current sales in percent. The column can be sorted using the heading.

Custom price

The custom price is an option if you have i.e a wholesaler price that you want to calculate and bulk update in Bulk Table Editor. To use a custom price you have to set it up in settings. See FAQ how to set up custom price. Custom price have the option to use the same calculation as sales price or use its own value for calculation. It has also the same bulk functions as price and sales price.

Delete rows

To delete products, check products using the left checkbox on every product row. To check all use the checkbox in the table header. Uncheck products you do not want to delete then click the Delete rows link and in the dialog select OK. PS! products will be moved to trash and will be found there if you deleted some products by mistake.

Clear sales

To clear an existing sale just click the link Clear sales. Then click the save all button and the sale is removed. You can change your mind and click the Clear sales again and your old values appear, this can only be done before you click the save all button. If you do not want to clear sales on all products just uncheck the checkbox on the products you want to keep before you save.

Other values

This table enables bulk updates of many of the other values on a product. Some values have rules that will prevent them to be set or other rules that tells what the value is, i.e Backorder and Stock status. All values can be updated in the table or using bulk functions (except Name). When a value has been changed and you leave i.e an input box the checkbox on the left of the row is checked. This indicates that the row will be saved when hitting the Save all button. Easy uncheck rows you do not want to save. If filtering rows, only visible checked rows will be saved.

Name

Can be updated on single products, variables has a button to enter the parent product.

Featured

Select box with options: Yes | No. Example: select yes and all shown rows featured checkbox will be checked, then use save all button to apply this for the products.

SKU

SKU has many options, you can add or generate SKUs based on your preferences. Remember that SKU must be unique or else it will not be saved. To make SKU, Bulk Table Editor has several options like set product ID first or after a name, generate SKU is another option that generate SKU like this: Shirt with logo = shi-wit-log. If you have done this, you can add i.e product ID and vendor before: 112-levis and get: 112-levis-shi-wit-log and you have a unique SKU.

Backorder

Select box with options to tell if one can purchase products if products is not in stock.

Stock status (in stock?)

This select box is more a status for your products, you can use the options but it can change automatically if backorder is set and I.e you’re out of stock.

Measures and product image

Weight: Set the weight

Length: Bulk set length

Width: Bulk set width

Height: Bulk set height

Product image: shows current product image

Bulk Table Editor