WooCommerce

How to bulk edit WooCommerce products and prices

Bulk editing changes many WooCommerce products at once instead of opening each one. It is what you need for a sale, a supplier price rise, a stock reconciliation, or any change that would otherwise mean editing eighty products by hand.

The manual way

How to do it in WordPress

  1. Select the products. Go to Products, filter by category, tag, type or stock status to narrow the list, then tick the checkboxes. Set the per-page count higher first if you need more than the default twenty on screen at once.
  2. Choose Edit from Bulk actions. Pick Edit in the Bulk actions dropdown above the list and click Apply. WooCommerce opens an inline panel showing every selected product and the fields you can change across all of them.
  3. Change price by amount or percentage. The Price field offers more than a flat overwrite. You can increase or decrease the existing price by a fixed amount or by a percentage, which is what you want for a supplier increase or a site-wide sale — it preserves the relative pricing between products instead of flattening them.
    Regular price → Increase existing price by (fixed amount or %) → 8%
    Sale price    → Set to regular price decreased by (%) → 20%
  4. Update stock, shipping and status in the same pass. The same panel handles stock status and quantity, weight and dimensions, shipping class, tax class, visibility and published status. Changing several at once is safer than several separate passes, because there is one moment where products are half-updated rather than four.
  5. Spot-check before and after. Note two or three specific product prices before you apply, then check them afterwards. Percentage changes compound if applied twice, and there is no undo — running the same 10% increase a second time because you were unsure it worked leaves you 21% up.

Worth knowing: Native bulk edit does not reach variations. A variable product's variation prices have to be edited on the product's Variations tab, or through CSV import — which is the usual reason a bulk price change appears to have silently skipped part of the catalogue.

The plugin way

If you do this regularly

For changes native bulk edit cannot express, WooCommerce's built-in CSV importer handles it: export the products, edit the spreadsheet, then re-import matching on ID and choosing to update existing products. This reaches variations and custom fields. Dedicated bulk-edit plugins add spreadsheet-style editing in the admin with filtering and rules.

One caveat: Always export a copy of the CSV before editing it. A re-import that matches on the wrong column can overwrite the catalogue, and there is no built-in way back.

The fast way

Or just say it.

Native bulk edit cannot express a condition. “Everything in this category except items already discounted” is where it stops and a manual pass begins.

You say

Raise the price of every product in the Outerwear category by 8%, but leave anything already on sale alone.

What changed
+ 34 products matched in “Outerwear”
! 6 excluded — sale price currently set
+ 28 products updated: regular price +8%
+ Example: Wool Overcoat £180.00 → £194.40
+ Snapshot taken before applying — reversible in one click

WooCommerce has no undo for bulk edits, so a percentage applied twice normally means restoring a database backup. Here the whole batch reverts in one click. How undo works.

At scale

Doing this across multiple sites

Conditional changes are where native bulk edit runs out. “Everything in this category except items already discounted” is a filter the admin cannot express, so it becomes a manual pass — and on several stores at once, a long one.

Related: WooCommerce AI · Updating store plugins safely

Questions

How to bulk edit WooCommerce products and prices: questions

Can you bulk edit prices in WooCommerce?

Yes. Select the products, choose Edit from Bulk actions, and use the Price field. As well as setting a fixed price you can increase or decrease existing prices by an amount or a percentage, which preserves the relative pricing across a catalogue.

Why did bulk edit not change my variable products?

Native bulk edit does not reach variations. Variable product prices live on each variation, so a bulk price change applies to simple products only. Edit variations on the product's Variations tab, or use the CSV importer, which does include them.

Can I undo a WooCommerce bulk edit?

Not natively — there is no undo for bulk edits, which is why noting a few prices beforehand matters. Recovery otherwise means restoring a database backup, losing anything else that changed since. Applying the same percentage change twice by accident is the most common way this bites.

How do I bulk edit hundreds of products at once?

Use the built-in CSV export and import. Export the products, edit the file in a spreadsheet, then import with the option to update existing products, matched on ID. This handles volumes and fields that the inline bulk editor cannot, including variations and custom fields.

Change 300 prices without a spreadsheet.

Conditional bulk edits across your catalogue, with the whole batch reversible in one click.

Start free