If your WooCommerce products have sizes, colours, or bundles, you already know the problem: the variations panel was built for a handful of options, not fifty. Once a product passes 30 or 40 variations, expanding each row to change a price or a stock number becomes a genuine time sink.
This guide covers three ways to bulk edit WooCommerce variations — from the built-in tools to a free spreadsheet-style editor — so you can update prices, stock and SKUs in minutes instead of an afternoon.
Why the default variations screen slows down
Each variation in WooCommerce is stored as its own hidden product. The edit screen loads them as accordion rows and saves over AJAX, so the more variations a product has, the heavier the screen gets. On a product with 60+ variations it is common to see the panel lag, collapse rows unexpectedly, or time out mid-save.
WooCommerce does include a couple of shortcuts, so start there before reaching for anything else.
Option 1: The built-in “set” actions
Open a variable product, go to the Variations tab, and use the Add variation dropdown. Actions like Set regular prices or Set stock quantity apply one value to every variation at once. Handy for a blanket change (“make every price 19.99”), but it cannot set different values per row, and there is no percentage option.
Option 2: CSV export and import
WooCommerce ships with a product CSV importer under Products → Export / Import. Export your products, edit the variation rows in Excel or Google Sheets, and re-import with “Update existing products” ticked. This scales to large catalogues, but it is fiddly: you have to match the right columns, one misplaced value can overwrite the wrong field, and you cannot see the result until after the import runs.
Option 3: A spreadsheet editor inside wp-admin
The fastest option is to edit every variation in one grid, right inside WordPress. Our free Variation Spreadsheet for WooCommerce plugin loads all of a product’s variations into an editable table, where you can:
- Change regular price, sale price, stock, SKU and status inline
- Bulk-apply a value, or raise and lower prices by a fixed amount or a percentage
- Generate every missing variation combination in one click
- Import and export CSV, with changes highlighted before you save
Because it writes through WooCommerce’s own data layer, price ranges and stock stay in sync, so nothing breaks on the front end.
Step by step
- Install and activate the plugin.
- Go to Products → Bulk Variations and search for your product.
- Edit any cell directly, or select rows and use Bulk apply.
- Click Save — only the rows you changed are written.
Which method should you use?
For a one-off blanket change, the built-in “set” action is enough. For a full catalogue migration, CSV still has its place. But for everyday work — a price rise here, a stock correction there — editing your WooCommerce variations in a spreadsheet grid is by far the quickest, and it avoids the risk of a bad CSV overwrite.