Bulk Edit WooCommerce Variations (The Complete Guide)

To bulk edit WooCommerce product variations, you need a way to see every variation across your catalog in one place instead of opening each product individually. WP Sheet Editor does this by loading your parent products and their variations into a spreadsheet grid inside your WordPress admin. From there, you can type changes directly into the cells, filter variations by attribute, category, or stock status, apply a change to hundreds of rows at once with the Bulk Edit tool, or export the data to CSV and re-import it after editing offline.

Below is the complete process for bulk editing WooCommerce variation prices, stock levels, images, and attributes, plus how to export and re-import variation data when you need to work offline.

Task	How to Do It
Bulk edit variation prices	Type directly into the Regular Price and Sale Price columns, or use the Bulk Edit tool to apply a fixed amount or percentage change to a filtered set of variations
Update stock quantities and status	Edit the Stock Quantity and Stock Status columns for each row, or apply a stock change to a batch of selected variations at once
Bulk upload variation images	Paste an image URL into the Image column, either row by row or across every variation that shares an attribute value
Standardize or change attribute values	Edit the attribute columns directly, or use the Bulk Edit tool to replace one attribute value with another across every matching variation
Filter variations by category, attribute, or stock status	Open the Search tool, tick “Search on variations,” and set your filter criteria before running the search
Edit variations outside of WordPress	Export the filtered variations to CSV, edit them in Excel or Google Sheets, then import the file back into WooCommerce

Table of Contents

Why Bulk Editing WooCommerce Variations Natively Is So Slow

WooCommerce stores every variation as its own hidden sub-product tied to a parent variable product. This “parent-child” structure is what lets a single t-shirt listing offer multiple sizes and colors without cluttering your catalog with duplicate products, but it’s also why the default admin interface struggles once your catalog grows past a handful of items.

Consider a single t-shirt design that comes in 5 sizes, 4 colors, and 2 materials. That’s 40 unique variations for one product. If you carry 20 designs built the same way, you’re managing around 800 variations across your store, and that number climbs every time you add a size run or a new color.

If updating one variation by hand takes roughly 20 to 30 seconds, including the clicks to open the product, expand the variation panel, edit the field, and save it, then a single price change across 800 variations adds up to somewhere around six to seven hours of repetitive clicking. Add a seasonal sale, a supplier cost increase, or a post-inventory stock update, and that same block of manual work repeats itself.

If you want to edit pricing, stock, or SKUs for a WooCommerce variable product using the default dashboard, the process looks like this:

Open the parent variable product.
Navigate to the Variations tab.
Expand a single variation dropdown.
Edit the data (price, weight, image, etc.).
Save the individual variation.
Repeat for every other variation on that product.
Update the parent product.
Go back to your products list and repeat the entire process for the next item.

Beyond the time cost, this process has structural limits. There’s no way to see pricing across multiple products at once, so inconsistencies (the same item priced differently in two places) can sit unnoticed for weeks. There’s no way to filter for “every Medium in the Summer collection” or “every variation currently out of stock” across your whole catalog. And the interface can slow down or time out on products with a large number of attribute combinations.

The Best Way to Bulk Edit WooCommerce Product Variations

To manage variable inventory at scale, we use the WP Sheet Editor plugin. It replaces the click-through variation panel with a spreadsheet interface inside your WordPress admin, so you can view and edit parent products and their variations together, in the same spreadsheet, without opening a single product page.

You can download the plugin here:

Download WooCommerce Products Spreadsheet Plugin - or - Check the features

How to Display Variations in the WooCommerce Spreadsheet

To load your variations into the spreadsheet, click the Display variations button on the plugin’s top toolbar. Child variation rows appear directly beneath their parent products, so you can manage parent-level fields and variation-level fields in the same view.

This default view also keeps simple, external, and grouped products visible in the spreadsheet alongside your variable products. If you only want to see variable products and their variations, use the filtering method below.

How to Filter Variable Products and Isolate Variations

To clean up the spreadsheet and show only variable products and their variations, open the Search tool.

Tick the Search on variations checkbox and click Run search.

The spreadsheet reloads showing only variable products, with their variations nested beneath each one.

Editing Variation Data Directly in the Spreadsheet Cells

For quick, targeted changes, you can type directly into the spreadsheet. Fields that only apply to parent products stay locked (read-only) on variation rows, which protects the database structure. You can freely edit these fields across variations:

Regular Price & Sale Price
Sale Start Date & End Date
Manage Stock, Stock Quantity, & Stock Status
Allow Backorders
Variation SKU
Weight, Length, Width, & Height
Downloadable, Download Limit, & Download Expiry
Variation Enabled / Disabled Status
Shipping Class & Tax Class
Variation Description
Custom variation fields added by third-party plugins

Common tasks that work well as direct cell edits:

Typing in new variation pricing for a small set of products.
Pasting a list of variation SKUs from a supplier spreadsheet.
Updating inventory numbers after a manual stock count.
Setting a variation’s featured image by pasting an image URL into the Image column.

In the example above, prices, featured images, and SKU codes were added to variations by typing directly into the cells. Once your edits are in place, click Save on the top toolbar to push the changes to your live store.

How to Bulk Edit WooCommerce Variations with the Bulk Edit Tool

Direct cell editing works for small changes, but it isn’t fast enough for hundreds or thousands of variations, like applying a store-wide 20% discount. For that, use the Bulk Edit tool. It takes two steps: select the variations you want to change, then configure and apply the edit.

Step 1: Select the Variations to Bulk Edit

You have three ways to choose which variations get updated.

Option A: Edit everything. Apply the change to every variation in your store. If this is your case, skip ahead to Step 2.

Option B: Manually select specific rows. Use the checkbox selector on the left side of the spreadsheet to pick exact rows, then open the Bulk Edit tool.

Option C: Use the Search tool to filter dynamically. This is the option to use when you need to:

Bulk edit all variations containing a specific keyword in the title.
Update all variations matching a specific size or color attribute.
Modify all variations within a specific product category.
Disable all variations currently marked “Out of Stock.”

Start by opening the Search tool.

In this example, we’ll search for every variation in the Dresses category. Enter the category name, tick Search on variations, and click Run search.

Ticking Search on variations is required any time you’re filtering variation data, whether by keyword, status, or attribute. Without it, the search only looks at parent products.

Once the search runs, the spreadsheet shows only the matching variations.

Step 2: Apply the Bulk Edit to the Filtered Variations

With your target variations filtered, open the Bulk Edit tool.

In this example, we’ll apply a 5% discount to every variation in the Dresses category by targeting the Sale price field and calculating it from the current regular price.

Select the rows you want to update: choose “Edit all the rows from my current search.”
What field do you want to edit: select “Sale price.”
Select the type of edit: choose “Copy from regular price and decrease by percentage.”
Decrease by percentage: enter “5”.
Important: Select Edit only variations so the parent product rows are skipped.
Click Execute Now.

The same workflow applies to other bulk changes across your catalog:

Running a percentage-based sale across all variations in a category.
Changing stock status (In Stock, Out of Stock, On Backorder) for hundreds of variations at once.
Attaching the same image to every variation that shares a color or pattern attribute.
Moving variations from one parent product to another by changing the parent product ID.
Applying shipping class and dimension updates across variations to fix inaccurate shipping rates.
Standardizing an attribute value, such as changing “PU” to “Vegan Leather” across every matching variation.
Appending promotional text to variation descriptions in bulk.

Exporting WooCommerce Variations to a CSV File

Sometimes you need to send your catalog to a supplier, or you’d rather do heavy data work offline in Excel or Google Sheets. Open the Search tool.

Tick Search on variations and click Run search to load your variations into the spreadsheet.

With your variations displayed, click Export on the top toolbar.

Configure the export:

What columns do you want to export: select specific columns, like SKU, Price, and Stock, or export every active column.
Which rows do you want to export: choose “All the rows from my current search.”
What app will you use to edit this file: select your spreadsheet program (Excel, Google Sheets, etc.) so the file formats correctly.
Click Start new export to download the file.

Open the CSV locally and make changes using standard spreadsheet formulas. Below, the Featured status, Short Description, Variation Description, and Stock Status columns were edited directly in spreadsheet software.

How to Bulk Import Variation Data Back Into WooCommerce

Once your CSV is edited, click the Import tool on the top toolbar.

Under Source, select CSV file from my computer, choose your file, and click Next.

Choose Import all the columns, or select individual columns to import.

Map the ID column in your CSV to the WooCommerce Product ID field so the import updates the correct rows, then click Next.

Review the preview screen to confirm your data looks correct, then click The preview is fine, start import.

The import runs and updates your WooCommerce variations without you having to open a single product page.

Bulk Editing WooCommerce Variations vs Other Methods

Method	Where You Work	Best For	Main Limitation
Native WooCommerce variation editor	Inside each product, one variation at a time	Stores with only a few variable products	No cross-product view, no attribute filtering, one variation at a time
CSV export and import through a separate import/export plugin	Offline, in a spreadsheet program, then re-uploaded as a file	One-off bulk changes or migrating data between stores	No live validation until after the file is imported, and formatting errors can affect the whole file
Direct database edits or custom code	The wp_postmeta table or a custom PHP snippet	Developers comfortable with serialized data structures	Editing the structure incorrectly can corrupt variation data
Spreadsheet-style bulk editor inside WordPress	A spreadsheet in your WordPress admin, connected live to your store	Ongoing variation management at any catalog size	You still need to select or filter the right rows before applying a change

Best Practices for Accurate Bulk Variation Edits

Always tick Search on variations when filtering. Without it, your search only returns parent products, not the variations inside them.
Use Edit only variations in the Bulk Edit tool whenever a change should skip parent-level rows.
Export your current prices and stock levels before a large bulk edit, so you have a reference point if you need to revert anything.
Start with a narrow filter, confirm the results look right in the spreadsheet, then widen your selection if needed.
When importing a CSV, double-check that the ID column is mapped to Product ID so updates land on the correct products.
Check the “Product type” column before editing prices in bulk. Parent products in a variable product don’t carry their own price, the variations do.

Frequently Asked Questions

How do I bulk edit WooCommerce product variations without opening each one individually?

Load your products and variations into the WP Sheet Editor spreadsheet, then either type changes directly into the cells or select a group of variations and apply a change with the Bulk Edit tool. Both methods update your live store without opening individual product pages.

Can I bulk edit variation prices by a percentage or a fixed amount?

Yes. The Bulk Edit tool lets you increase or decrease prices by a fixed amount or a percentage, and you can calculate a sale price directly from the regular price, as shown in the 5% discount example above.

How do I bulk edit stock levels for WooCommerce variations?

Edit the Stock Quantity and Stock Status columns directly for a small number of rows, or filter to the variations you need and apply a stock update to all of them at once with the Bulk Edit tool.

Can I bulk upload images to WooCommerce variations?

Yes. Paste an image URL into the Image column for a variation row, or apply the same image across every variation that shares a specific attribute, such as every “Green” variation across your catalog.

How do I filter for variations with a specific attribute, like size or color?

Open the Search tool, tick “Search on variations,” and set your filter to the attribute value you need. The spreadsheet will reload showing only the matching variations.

What’s the difference between editing a parent product and editing its variations?

A variable product’s parent listing holds shared information like the title and category, while pricing, stock, and SKU live on the individual variations. Fields that only belong to the parent are locked on variation rows, so you can’t accidentally overwrite them.

Do I need to write code or touch the WooCommerce database to bulk edit variations?

No. Everything described here happens through the spreadsheet interface or the CSV export/import flow, without editing the database or writing PHP.

Can I export WooCommerce variations to CSV and edit them offline?

Yes. Filter to the variations you want, use the Export tool to download a CSV, edit it in Excel or Google Sheets, then re-import it using the Import tool, mapping the ID column to Product ID.

Can I filter for variations that are currently out of stock?

Yes. Use the Search tool with “Search on variations” enabled and filter by stock status. You can then bulk disable or update those variations directly from the filtered results.

Start Bulk Editing Your WooCommerce Variations Today

Managing variable products doesn’t have to mean clicking through every size, color, and material combination one at a time. With WP Sheet Editor, you can view your entire catalog of variations in one spreadsheet, edit them directly or in bulk, and move data in and out of WooCommerce with CSV when you need to work offline.