WooCommerce variable product price field disabled in the bulk editor
The WooCommerce variable product price field is disabled in the bulk editor on purpose: the Regular price and Sale price cells of a variable product show a red no-entry icon, and so do stock, category or short description cells on variation rows. Nothing is broken, and it is not a limit of the free version. The icon marks a field that the product type does not have, so no editor, BEAR or WooCommerce's own, can store a value there. Below is which data lives on the parent and which on the variations, how to change the prices of every variation at once, and why a bulk price change sometimes touches only the variations or only the simple products.
Why a variable product has no price field
A variable product in WooCommerce is two kinds of records. The parent holds what customers see once for the whole product: title, description, short description, images, categories, tags, brands, attributes, upsells. Each variation (Red / XL, Blue / M) is a separate record that holds what can differ between options: regular and sale price, sale dates, SKU, stock, weight and dimensions, shipping class, image, and its own description. See the WooCommerce guide to variable products for how they are set up.
The price range a shop shows for a variable product ($20 – $35) is not stored on the parent. WooCommerce computes it from the variation prices. That is why the price of a product disappears when its type is changed from simple to variable: from that moment the prices belong to the variations, and the parent has nothing to show or edit.
The same logic works the other way. A variation has no categories, tags or brands of its own, no short description, no catalog visibility and no reviews; it takes all of that from its parent. Its title is built from the parent title and its attribute values, which is explained in showing attributes in variation titles.
Which cells show the red no-entry icon
BEAR keeps a list of allowed product types for every column and draws the icon (tooltip Not allowed!) when a row's type is not on it. Clicking such a cell does nothing. The main cases:
| Column | Blocked on | Where to edit it |
|---|---|---|
| Regular price, Sale price, Sale time from, Sale time to | Variable and grouped products | On the variations (a grouped product shows the prices of its child products) |
| Allow backorders, Virtual, Downloadable, Down.Files, Download limit, Download expiry | Variable products | On the variations |
| Categories, tags, brands and other taxonomies | Variations | On the parent |
| Attribute columns | Variations | On the parent; the variation cell shows its own value in brackets, for example [Red] |
| Short Desc., Slug, Type, Catalog Visibility, Featured, Gallery, Upsells, Cross-sells, Purchase note, Tax status, Sold individually, Reviews allowed, Author | Variations | On the parent |
| Product url, Aff.Button text | Everything except external products | Only external/affiliate products have them |
Two columns behave differently on purpose. Stock status can be edited on a variable parent, but WooCommerce recalculates it from the variations every time the parent is saved, unless the parent manages stock itself; the stock manager guide covers stock on variations. The Description cell of a variation row is editable and writes the variation's own description, the text shown when a customer picks that option.
Bulk edit the price of all variations
The variations switch on the tools panel above the table decides whether variations take part. With it off, the table and every bulk operation work on top-level products only. With it on, the variation rows appear under their parents and bulk operations go to the variations.
- In the Filters tab, set Product type to Variable, add a category or other conditions if the change is not for the whole shop, and press Filter. Filters always select parent products; a price condition finds the parents that have a matching variation.
- Turn on the variations switch. The Bulk Edit tab now shows the notice Bulk operations will be applied to the variations of the products, and their parent-products will be ignored!
- Open Bulk Edit, tick regular price (or sale price) and choose the behaviour: set new, increase by value, decrease by value, increase by %, decrease by %. The sale price also has regular price minus % and regular price minus value.
- To change only some options, for example every XL, pick the attributes in select combination of attributes, press Add attributes combination to apply on and choose the terms. Without a combination, all variations of all filtered products are changed.
- Press Do Bulk Edit and wait for the progress bar to finish.
The select all variations button that appears next to the switch ticks the variation rows visible on the current page only. Ticked rows take priority over the filter, so the run then covers just that page. To change every variation of the filtered products, leave the rows unticked. The same steps with a worked example are in bulk editing variations of many products and a different price for each size.
A bulk price change touched only variations, or only simple products
The line at the top of the Bulk Edit tab, Bulk editing will be applied to: all the products on the site, describes the selection: all products, the filtered ones or the ticked ones. It does not mention product types, and the variations switch narrows the run further:
- Switch on: only variations are written. Simple and external products in the same selection are skipped, even though the line says all products.
- Switch off: simple and external products get the new price. Variable parents in the selection get nothing, because they have no price, and their variations are not included. BEAR writes nothing on the parent and History records nothing for it.
So a shop with both kinds of products needs two runs with the same settings: one with the switch off for simple and external products, one with it on for the variations. The order does not matter, and each run appears in History as its own bulk operation that can be reverted. A storewide sale built this way is described step by step in putting all products on sale.
Binded editing follows the same rule: with the switch on it writes only to ticked variations.
Categories and tags are missing in the Bulk Edit tab
While the variations switch is on, the Bulk Edit tab hides the operations that variations cannot take: the taxonomy rows (categories, tags, brands, attributes), title, short description, slug, status, catalog visibility, featured, upsells, cross-sells and a few others. Turn the switch off and they come back. Changing the category of a variable product is a change of the parent, and its variations follow it automatically; the category guide shows the operations.
One price for all variations, or a price that follows the parent
When every option costs the same, there is still no parent price to set. Filter the products, turn the switch on and use set new on regular price: every variation gets the same value, and the shop shows a single price instead of a range.
A rule such as "XXL costs 10% more than the base price" cannot be stored either. WooCommerce has no base price on the parent for a variation to follow, and BEAR runs operations when you start them; it keeps no dependent or automatic prices. Do it as two runs: set new for all variations with the base price, then increase by % with the combination Size: XXL. When the base price changes, repeat both runs. If the percentages produce odd cents, set the price rounding before you start.
Checklist before a price run
- The filter selects the products you mean, and nothing is ticked unless you want only those rows.
- The variations switch is on for variable products and off for simple and external ones.
- A combination of attributes is set only when the change is for some options.
- After the run, open one variable product in WooCommerce and check two variations, then look at the price range on the shop page.
- If a cell still shows the no-entry icon on a product that should have the field, check the Type column: a product imported as variable with a single option is still variable.
Operations that change the variations themselves (create, delete, reorder, swap attribute terms) are in bulk editing variable products and variations. If a field stays blocked where WooCommerce lets you edit it, ask on the BEAR support forum.