How to bulk edit products in WooCommerce

Use the product-list editor when you are changing a small group of products and the same field needs the same value. Use CSV when you need to change many rows, work from a spreadsheet, or update products by SKU or product ID.

For variable products, check whether you need to edit the parent products, the individual variations, or both. Treat a price or stock change to variations as a separate job from changing the parent product.

Create a backup before a large price, stock, category, or visibility update. Exporting a CSV gives you a useful copy of product data, but it is not a complete site backup and may not include every extension's settings.

On a live shop, avoid making a large import while orders are being processed if the changes affect prices or stock. A mistaken import can overwrite correct values across the whole catalogue.

Go to Products > All Products. Filter the list by category, product type, or stock status, select at least two products, choose Edit from the Bulk Actions menu, and select Apply. WooCommerce then shows the fields that can be changed for all selected products.

Change only the fields you intend to change. Leave other fields at No change, then select Update. This route is fine for straightforward edits such as status, catalogue visibility, stock status, categories, and simple price changes, but it does not provide a spreadsheet view or every product field.

Go to Products > All Products > Export and export the products you need, preferably including all columns. Open the file in a spreadsheet editor, change only the required values, and save it as a UTF-8 CSV.

Return to Products > All Products, select Import, upload the file, and choose Update existing products. WooCommerce matches rows using the product ID or SKU. Review the column mapping carefully, choose Do not import for columns you have not intended to change, then run the importer and wait for it to finish without refreshing or leaving the page.

Open several products after the update and check the front end, the edit screen, prices, stock, categories, images, and sale dates. For variable products, confirm that each variation has the correct SKU, attributes, price, and stock data.

Common failures include editing a parent row when the value belongs to variations, losing leading zeroes in SKUs, changing CSV column names, saving with the wrong character encoding, and importing blank cells that overwrite existing data. Test a few rows first, especially when the file came from a supplier or another system.

If you regularly update large catalogues, need more detailed filters, or want to combine product edits with CSV import and export, a dedicated tool is quicker than repeating the built-in workflow. Bulky is a suitable option for bulk editing products, orders, and coupons, with filtering, CSV handling, and scheduled changes.

Install it from the WordPress dashboard, activate it, filter the products you want to change, review the matching rows, and apply the edit. Still make a backup and test a small selection first: a faster editor can also apply a wrong value to more products in one operation.