Bulk Table Editor for WooCommerce

Bulk Table Editor, a WooCommerce extension for setting up sales and perform bulk updates of products, variations and subscriptions.

Installation

1. Download the .zip file from your WooCommerce account.
2. Go to: WordPress Admin > Plugins > Add New to upload the file you downloaded with Choose File.
3. Activate the extension.

More information at: Installing and Managing Plugins.

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.
• 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.

• Custom price (slug): Use the price slug for i.e 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 on how to find this slug or use the Integrations (get slug) dropdown box.
• 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, 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.

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.

Category and sales filter

The two dropdown select boxes above the table is handy to filter out products. Select category shows you all your current categories and by selecting one you get all the products and variations. If you use the filter ( on sales ) select box you can filter out products and variations on sale, this filter will be set until you select all products again or use the search in text or SKU. The rows filter can be used when you have sales filter on.

Download (.csv file)

In the header section after other values button you find the button with a cloud icon. This button let you download all your products and variations.

How to use the download button?

The download fetches all the products in current category. If you currently look at all products and click the download button all your products will be downloaded as a .csv file. If you have i.e 10.000 of products this can be a large file that can be hard to handle for you. We recommend to be aware of this and use with this in mind.

The file you get can be opened in i.e MS Excel and Apple Numbers.

Bulk Table Editor – home

The default table is the editor home, the grey button shows this. This table focus on prices and setting up sales, let us have a look on how this table and some of the general functions works.

Search

The search function has radio buttons below. If you use the default option Text you search in product name and description, if you select SKU your search is only finding items that matches your input. I.e woo- finds all items that contains woo-, example woo-cap. If you select Rows you will only search/filter in current product rows, this can be handy if you have a lot of variations and want to filter out some of them. After a search you can just click the search icon again to view all your products. In Editor home you can search/filter rows by name + price, and in other values name + SKU.

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

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.

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.

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.

If you want infinity sales on your products with no start and end dates just set the sales price and save. 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.

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.

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

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.

Bulk Table Editor – 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 SKU 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 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 ID and vendor before: 112-levis and get: 112-levis-shi-wit-log and you have a unique SKU.

/wbte-create-sku.png”>

Tags

Think of tags as attributes you can assign to multiple SKUs, this again makes it more easy for customers to find products they look for. The tags has functions like add before and after, or just set a list of tags. If you set a list of tags and add it make sure to use comma to separate your tags.

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

FAQs

How do I change product categories and view all my products again?

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.

Do I need to use tags on my products?

Tags makes it more easy for customers to find your products. A article written by WooCommerce let you know more why it is important to give it attention. Read this: https://woocommerce.com/posts/woocommerce-product-tags-seo/

What is SKU and do I need to use it?

SKU is short for: Stock-keeping unit and is a string representing the Product unique identifier in your WooCommerce shop. We recommend to use SKU and Bulk Table Editor has a SKU generator that makes it easy to set unique SKUs on your products and variations.

How do I search for products?

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. This applies for regular text and SKU search selected by radio buttons below the search field. If you want to search in rows, click the radio button Rows. When this is selected the search button is disabled because you are just filtering in your current rows. To filter products just start to write a product name or a variation you want to filter by, then only rows containing your input will be shown.

I have a lot of products, is there a paging function?

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?

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. Tip: use search in rows to filter your variations if many.

I want to use the round functions, how does it work?

The round functions is found in the dropdown select box for price, sale price and custom 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. Just use the functions on your prices or i.e after you have bulk created new sales prices. Remember to save when done.

How do I set up a custom price?

In Bulk Table Editor settings find the Custom price (slug) and enter i.e _wholesaler_price or other. The short movie here will show you how to find it (using Chrome browser).

After you have found the custom price and copy / paste it to settings you need to set a custom name for the field and this will be the column name in the table editor. Then check the custom price – calculate like sales price. If you check this it will use normal price as your base for the bulk calculations. If not you will use the custom price as a standalone price, same as the regular price does. If for example this custom price is a wholesaler price and you want all wholesaler prices to be 50% of the regular price then you should check this option on. Finally to show the custom field in Bulk Table Editor click the: Show custom price checkbox and you are done, now you can go to Bulk Table Editor and update your custom prices!

Can I bulk update Name your price for WooCommerce prices?

Yes, you can update minimum price and suggested price. Minimum price will show up as price in Bulk Table Editor, suggested price needs to be set in settings > custom price. Use slug: _suggested_price. After saved as below, open Bulk Table Editor and you have a new column for Name your price (suggested price).

/wbte-nyp-settings.png”>

Can I set the sales prices to a fixed amount?

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?

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?

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.

Can I use the editor on an iPad?

Yes, but you have to enable JavaScript in settings for your iPad browser. Follow this guide: https://www.whatismybrowser.com/guides/how-to-enable-javascript/safari-iphone

Example

/wbte-2.1.9-main.png”>

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 can set a sale start or 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.

Sales dates

Sales dates is optional. This means that you can i.e use start dates and no end dates. This gives you a sale that starts on a date and runs until you stop it by clearing the sale price (function for this). The same goes for using only the sale end date, means that the sale starts now and ends on the date you selected. If you create a sale with no dates the sale starts now and runs until you remove the sale price.

Sale with no dates (in versions before 2.1.5)

If you just want a sale that goes on until you remove the sale price, then you need to enter Bulk Table Editor’s settings and find a option called: Allow infinity sales price and check this (on) and now you will not need to set dates for you sales.

Compatibility

The extension is compatible with:

• WooCommerce Products and variations
• WooCommerce Subscriptions and variations

Languages:

• Default English
• Translation for Spanish
• Translation for Norwegian
• Translation for French
• Includes POT file for translation to other languages

Uninstalling

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.