How to Bulk Edit WooCommerce Products: 4 Safe Methods (Including AI)

If you sell more than a handful of items, sooner or later you need to bulk edit WooCommerce products: raise prices after a supplier increase, start a store-wide sale, fix stock levels, or move fifty products into a new category. Doing it one product at a time is slow and easy to get wrong. This guide walks through four practical ways to make bulk changes, from the tools built into WooCommerce to managing your catalogue by chatting with an AI assistant, plus a checklist to keep every change safe.

Why bulk edits go wrong (and how to avoid it)

Most bulk-edit mistakes come from the same few causes: editing the wrong set of products, typing a fixed amount when you meant a percentage, forgetting about variable products, or having no way to undo the change. Before you touch anything, decide three things:

• Scope: exactly which products change (a category, a tag, a brand, everything on sale?).
• Rule: what the change is (“increase regular price by 10%”, “set stock to 0”, “add to category Winter”).
• Way back: how you will restore the old values if something looks wrong. A fresh product export or a full site backup is the simplest safety net.

Write these down in one sentence. If you can’t describe the change in one sentence, split it into smaller jobs.

Method 1: Bulk edit WooCommerce products from the product list

WooCommerce has a built-in bulk editor that is fine for simple, one-off changes.

1. Go to Products → All Products.
2. Filter the list first: by category, product type or stock status, or use the search box. Increase “Number of items per page” under Screen Options if you need more rows.
3. Tick the products you want to change (or the top checkbox for all visible rows).
4. Choose Bulk actions → Edit and click Apply.
5. In the bulk edit panel, change only the fields you need. For price you can set a new value or increase/decrease the existing price by a fixed amount or a percentage. You can also change sale price, stock status, stock quantity, categories, tags, shipping class and more.
6. Click Update, then spot-check a few products on the front end.

Good for: quick changes to simple products. Watch out for: variable products. Their prices live on each variation, so you change them inside the product’s Variations tab, where WooCommerce offers its own bulk actions such as setting or increasing regular prices for all variations.

Method 2: Use CSV export and import for large catalogues

For hundreds or thousands of products, a spreadsheet is often faster.

1. Go to Products → Export and export the columns you need (always include ID or SKU).
2. Keep an untouched copy of this file. It is your backup.
3. Open a second copy in a spreadsheet app and edit prices, stock or other fields. Formulas make percentage changes easy, for example a new column that multiplies the old price by 1.1.
4. Delete the columns you did not change, so you don’t overwrite anything by accident.
5. Go to Products → Import, upload the file and tick “Update existing products” so rows match by ID or SKU instead of creating duplicates.
6. Check the column mapping screen carefully, run the import and review the result summary.

Good for: big, repeatable changes and anyone comfortable with spreadsheets. Watch out for: number formats (commas vs dots), empty cells and SKUs that don’t match.

Method 3: Spreadsheet-style bulk editor plugins

Several plugins turn the product list into an editable grid where you can filter, select and change many cells at once. They sit between the built-in editor and CSV files: faster than clicking through products, without leaving WordPress. If you go this way, check that the plugin supports variations, lets you preview or undo changes, and is still actively updated.

Method 4: Bulk edit WooCommerce products by chatting with AI

A newer option is to describe the change in plain language and let an AI assistant do the clicking for you. With Site Commander MCP, a WordPress plugin that connects your site to Claude as a connector, you can type requests like:

• “Increase the price of every product in the Accessories category by 10%.”
• “Set the sale price of all T-shirts to $19.”
• “Add a hoodie in sizes S to XL in black and white, then set the price of every variation to $45.”
• “Show me all products that are low on stock or out of stock.”

Claude then reads your products, makes the changes through the plugin and reports what it did. Because you describe the scope and the rule in one sentence, it naturally follows the “scope, rule, way back” habit from the first section. A good routine is to ask for a list of the matching products first, check it, and only then ask for the change.

Keeping AI-powered bulk edits safe

Giving any tool power over your whole catalogue needs guard rails. Site Commander MCP is built around them:

• Secure connection: you connect with OAuth 2.1 and approve the connection on your own website, so you never give your password to the AI. You can disconnect at any time.
• Same permissions as the approving user: Claude only gets the rights of the WordPress user who approves the connection.
• Read-only mode and per-area switches: start in read-only mode to explore your data, or allow products and orders while blocking plugins and users.
• Activity log: every action is recorded with who did what, when and the result, so you can review a bulk change afterwards.
• Confirmation for sensitive steps: for example, Claude asks you to confirm before issuing refunds.

If you haven’t set it up yet, our guide on how to connect Claude to WordPress safely walks through installation, approval and permissions step by step.

Which bulk edit method should you use?

• A few simple products, one field: the built-in bulk editor.
• Thousands of rows or a supplier price list: CSV export and import.
• Frequent grid-style editing: a spreadsheet editor plugin.
• Mixed jobs across products, variations, stock and categories, described in plain words: an AI connector such as Site Commander MCP ($29, one website licence).

Many stores combine them: CSV for the yearly price list, chat for everyday changes. For other time-savers, see our guide to automating WooCommerce store tasks like orders, stock emails and cart recovery.

Bulk edit checklist

• Write the change in one sentence: scope + rule.
• Take a product export or full backup first.
• Filter and review the list of products that will change.
• Check whether any of them are variable products.
• Test the change on one or two products before running it on all.
• Run the change, then spot-check prices and stock on the live store.
• Clear your page cache so customers see the new values.
• Keep a record (the activity log, import summary or a note) of what changed and why.

Conclusion

You don’t need to edit products one by one. The built-in editor and CSV import cover most jobs, and when you want to describe changes in plain language instead of clicking through screens, Site Commander MCP lets Claude handle bulk product edits with permission controls and a full activity log. Purchases are covered by our refund policy, and if you have questions before you buy, contact us.