The fastest way to update prices on WooCommerce variations in bulk is to skip the default admin screen entirely and use a spreadsheet-style bulk editor. Instead of opening each variation row one at a time, you select the product, see every variation listed like a spreadsheet, and change price, sale price, or both across as many rows as you want in one save. For a store with 20, 50, or 200 variations, that is the difference between a five-minute job and an afternoon lost to clicking.
Below is the quick answer for people in a hurry, then the full walkthrough for doing this properly in WooCommerce without paying for a plugin.
The Quick Answer
Native WooCommerce has no built-in bulk price tool for variations beyond a basic percentage increase or decrease that applies to every variation the same way. If you need different prices for different sizes, colors, or bundles, or you want to set exact numbers instead of a flat percentage, you need a bulk editing tool. The free plugin Variation Spreadsheet for WooCommerce adds a spreadsheet grid to every variable product where you can type new prices directly into cells and save them all at once. It is free, it is not limited to a handful of variations, and it does not require learning a CSV format first.
Why the Default Editor Slows You Down
WooCommerce’s built-in variation editor is fine for a product with three or four variations. It stops being fine once you cross into double digits. Each variation lives inside its own collapsed panel. To change a price you click to expand the panel, scroll to the price field, type the new number, then collapse it and move to the next one. Multiply that by 80 or 150 variations and you are looking at real time lost, plus a real chance of missing one or typing a price into the wrong field.
There is a bulk action dropdown above the variations list that lets you set a regular price or increase/decrease prices by a percentage or fixed amount across all variations. That works only when every variation should end up at the same number or move by the same amount. It falls apart the moment your pricing logic depends on size, material, or any variable attribute, which is most stores.
Step-by-Step: Bulk Updating Prices with a Spreadsheet Editor
Here is the process using a free spreadsheet-style tool, which works the same general way regardless of which product you are editing.
- Install the plugin. From your WordPress dashboard go to Plugins, then Add New, search for Variation Spreadsheet for WooCommerce, and install and activate it. No account or license key is needed for the free version.
- Open the variable product. Go to Products, click into the product you want to reprice, and look for the new spreadsheet tab or button added near the Variations tab.
- Review the grid. Every variation appears as a row, with columns for SKU, regular price, sale price, stock, and the attribute values (size, color, etc.) so you can see exactly what you are editing without guessing which panel matched which combination.
- Edit prices directly. Click into any price cell and type the new number. You can move down a column the same way you would in Excel or Google Sheets, updating row after row quickly.
- Use fill-down for repeated values. If a group of variations should share the same new price, set the first one, then copy that value down to the matching rows instead of retyping it each time.
- Save once. When every row looks right, save the grid. All changes apply in a single update instead of one save per variation.
- Spot-check the storefront. Open the product page on the live site and check a few variations to confirm the new prices are showing correctly, especially if you also update sale prices.
Handling Sale Prices Alongside Regular Prices
A common mistake when repricing in bulk is updating the regular price and forgetting the sale price is still tied to the old number, or leaving a sale price active when it should have expired. When you are in the spreadsheet grid, update both columns at the same time for any variation running a promotion. If a variation is not on sale, leave the sale price column blank rather than matching it to the regular price, since WooCommerce treats a sale price equal to the regular price as still technically “on sale” in some themes and can trigger a strikethrough price that confuses shoppers.
Repricing by Attribute Instead of by Product
Sometimes the change you need is not per product but per attribute, for example every variation in Large across your whole catalog needs a two dollar increase because of a packaging cost change. This is where a spreadsheet view earns its keep over the default editor, because you can see the attribute column next to the price column and filter or sort by it visually before typing new numbers. Work through the product one at a time, but because each product’s edit takes seconds instead of minutes, updating fifteen products this way is still a short task rather than a half day of admin work.
What About CSV Import and Export?
WooCommerce also supports importing and exporting products through CSV files, and that method can technically handle price updates too. It works, but it asks more of you. You export the file, open it in a spreadsheet program, find the right columns among dozens of fields most of which you do not need to touch, edit the prices, save the file in the right format, then re-import and watch for mapping errors. That is a reasonable approach if you are comfortable with CSV structure and doing a full product export regularly. For a straightforward price update on an existing product, editing directly in a spreadsheet-style grid inside WordPress is faster because there is no export, no file handling, and no risk of the import mismatching a column and overwriting the wrong field.
Free vs Paid Bulk Editing Plugins
Tools like WP Sheet Editor and Barn2 offer similar spreadsheet-style bulk editing, but both are paid products, often with tiered pricing based on the number of products or added features you need. If your main requirement is straightforward bulk price editing across variations, including stores with well over a hundred variations, a free option covers that same core job without a subscription or license fee. It is worth trying the free route first and only paying if you hit a specific feature gap the free version does not cover.
A Few Practical Tips
- Back up your database, or at least export your current product CSV, before a large repricing pass. It takes two minutes and saves you if something goes wrong.
- Update prices during low-traffic hours if you are repricing a large or popular catalog, since cached pages may briefly show old prices until the cache clears.
- If you use a caching plugin, clear the product page cache after a bulk price update so customers see the new numbers immediately.
- Keep a simple spreadsheet log of old and new prices outside WordPress for big seasonal changes, so you have a record to revert to later without guessing.
Wrapping Up
Bulk price updates do not need to be a manual, row-by-row chore, and they do not require a paid plugin to get a proper spreadsheet workflow. Install a free tool, open the grid, type your new numbers, and save. For most stores that is the entire job, whether you are updating five variations or five hundred.