Bulk Edit WooCommerce Products (Advanced Search, Export, Import)

Editing products one by one in WooCommerce works fine, until your store grows. When you’re managing 200, 500, or even 5,000+ products, manual editing becomes slow, repetitive, and risky. Updating prices after a supplier change, scheduling a seasonal sale, fixing stock issues, or cleaning up product data can take hours… sometimes days.

WooCommerce’s default bulk editor simply isn’t built for scale. It offers limited filtering, struggles with variations, and doesn’t handle custom fields or complex updates efficiently. As your catalog grows, these limitations turn into serious bottlenecks.

The scalable solution is spreadsheet-based bulk editing with WP Sheet Editor.

Instead of opening products one at a time, you manage everything inside a spreadsheet-style interface, similar to Excel or Google Sheets. You can filter products by category, attribute, stock status, custom field, price range, or any combination — then update thousands of rows in seconds.

This plugin is designed for:

• WooCommerce stores with 100–50,000 products
• Agencies managing multiple client stores
• Wholesale and B2B stores with complex pricing
• Store owners handling migrations or supplier updates
• Teams that need speed, control, and accuracy

If you’re ready to manage your WooCommerce store like a structured database instead of a collection of manual forms, you’re in the right place.

What is bulk editing in WooCommerce?

Bulk editing in WooCommerce means updating multiple products at the same time instead of editing them one by one. If you’ve ever needed to increase prices across an entire category, update stock for hundreds of SKUs, change sale dates, fix product descriptions, or modify variations, you already understand the pain point. Opening each product individually is slow, repetitive, and highly inefficient.

Bulk editing solves that problem by allowing you to apply changes to many products simultaneously — safely and with precision.

What WooCommerce allows by default

WooCommerce includes a basic bulk edit feature inside the Products list table. You can select multiple products and apply limited changes, such as:

• Changing product status (published, draft)
• Updating categories or tags
• Adjusting simple price fields
• Modifying stock status

While useful for small stores, this native feature has serious limitations:

• No advanced filtering (e.g., price range + category + attribute combinations)
• No full spreadsheet view of products
• Very limited support for variations
• No editing of most custom fields or third-party plugin data
• No easy percentage-based or formula-driven updates

As your catalog expands, these restrictions become operational bottlenecks — especially when managing large inventories, complex pricing models, or variable products.

Why spreadsheet-based bulk editing is different

Spreadsheet-based bulk editing with WP Sheet Editor transforms your WooCommerce product data into a structured grid of rows and columns — just like Excel or Google Sheets — but directly inside your WordPress dashboard.

Each product becomes a row. Each field — price, stock, SKU, attributes, custom fields, SEO data, and more — becomes a column.

From there, you can:

• Edit hundreds or thousands of products from a single screen
• Use advanced filters to precisely target which products to modify
• Apply percentage increases or formula-based updates
• Edit product variations inline next to their parent products
• Modify custom fields and third-party plugin data
• Perform search-and-replace operations across your entire catalog

Instead of thinking in terms of “editing products,” you begin thinking in terms of “editing structured data.” That shift dramatically increases speed, control, and accuracy when managing large WooCommerce stores.

In short, bulk editing in WooCommerce with WP Sheet Editor is not just about speed — it’s about control, scalability, and managing your store as structured data instead of individual product pages.

Getting started → Install and activate WP Sheet Editor

Now that you understand why spreadsheet-based bulk editing is fundamentally different from WooCommerce’s native tools, the next step is installing and activating WP Sheet Editor.

If you want to get WP Sheet Editor, you need to purchase it using the button below:

After completing the payment process, you will receive a ZIP file that must be installed as a plugin on your website.

1. Go to Plugins > Add New Plugin
2. Click on Upload plugin.
3. Click on Choose file.
4. Locate the file on your computer.
5. Click on Install now.
6. Click on Activate plugin.
7. Enter your license and click on Activate License.

Quick editing products in the spreadsheet

WP Sheet Editor allows you to bulk edit WooCommerce products using a spreadsheet. This is a great way of quick editing products and saving a lot of time.

The spreadsheet displays all product fields as columns, and each field is displayed in cells according to the field type.

Let’s see how different fields are displayed on the spreadsheet.

a) Number fields (regular price, sale price, stock, etc.)

All number fields such as regular price, sale price, stock, and others accept numbers.

b) Dropdown fields (status, stock status, etc.)

All fields showing selectable options are displayed as drop-down fields.

c) Upload file fields (featured image, product gallery, etc.)

The file fields allow you to upload images, videos, documents, etc. You can upload files from your computer, select them from the media library, or paste the URLs of the files by double-clicking them.

If you click on the Upload button, will be able to upload files or select them from the media library.

d) Text editor fields (description)

Text editor fields such as TinyMCE editor will allow you to add plain text by double-clicking, or add formatted text using the editor that will open in the popup when you click edit.

This is the text editor popup that allows you to add formatted text.

e) Date fields (date created, date modified)

Date fields will display a calendar and time selector.

f) Checkbox fields (sold individually, virtual, etc.)

Checkbox fields will display the checkbox for you to select any value (Yes/No).

g) Taxonomy fields (category, tag, attributes like size, color, brand, etc.)

Taxonomy plugins such as categories, tags, attributes (color, size, brand, etc.), or custom taxonomies added with third-party plugins, allow you to easily select terms. Just start typing, and the term suggestions will be displayed. You can select taxonomies with one click as well.

Advanced products search

WP Sheet Editor – Products Spreadsheet contains an advanced search tool that’s been designed to simplify the process of managing your WooCommerce products. Whether dealing with extensive product catalogs or detailed attribute configurations, the advanced search feature ensures you can quickly access the information you need.

The advanced search tool allows you to filter products using a wide range of criteria, including:

• Keyword in title or description: You can search for products that contain a specific keyword in the title or description.
• Categories: You can filter products based on their assigned categories to manage specific groups of products.
• Tags: You can search for products containing any specific tag.
• Attributes: You can find products containing specific attributes (size, color, material). This is useful to manage products with particular characteristics.
• Product type: You can search for simple, variable, grouped or external products.
• Shipping class: Use shipping classes as search criteria to find bulky products, frees shipping products, etc.
• Search on variations: You can filter product variations, not only parent products.
• SKU: You can use the product SKUs to find products, which is especially useful for inventory management and tracking.
• Price: You can filter products based on their price (regular price, sale price) or price range, which is useful for managing pricing strategies.
• Stock status: You can locate products based on their stock status (in stock, out of stock, on backorder) to manage inventory levels effectively.
• Date created/modified: You can search for your products based on their creation or modification dates, which is useful for recent updates or historical analysis.
• Custom Fields: If you’ve added custom fields using any plugin, you can use custom fields to target products with specific properties or additional metadata.
• And a lot more!

To filter your products with the advanced search tool, click on Search.

Once you’re in the search tool, select the search terms. In this example, we will run a combined search with these values:

• Keyword = t-shirt
• Category = Clothing
• Stock status = In stock
• Regular price >= 30

Once we’ve selected the search terms, let’s click on Run search

Once you filter your products, they will be displayed on the spreadsheet. You’ll see all the active filters above the products’ data, and you can remove any filter by clicking on it.

Bulk edit WooCommerce of products – thousands at once

With WP Sheet Editor, you can update thousands of products in bulk with a few clicks. You can edit all products, all products from a specific search, or all products you manually select in the spreadsheet.

These are some of the things you can do with the Bulk Edit tool:

• Bulk delete products
• Edit product prices in bulk (add new prices, decrease or decrease prices by percentage/amount)
• Update product status in bulk
• Bulk upload product images or galleries
• Move products from one category to another in bulk
• Assign products from one author to another
• Copy values between related fields (copy product variation to short variation and vice versa, copy regular price to sale price and decrease by percentage or amount, append category to product title, and a lot more.)
• Bulk edit product categories, tags, attributes (color, size, etc.)
• In short, you can edit any field in thousands of products!

In this example, we are going to edit all products from a specific search, and we will bulk update product prices.

You need to start by opening the Bulk Edit tool.

Once you’re in the Bulk Edit tool, you need to select these values (using the bulk edit is easy because it works the same for all fields):

• Select the rows that you want to update: In this case, we’ll edit all the rows from the last search
• What field do you want to edit: You can bulk update any field, but in this example, we will select the “Regular price” field.
• Select type of edit: The types of edit available will depend on the field you’ve selected. In this case, we will Increase by percentage.
• Increase the existing value by a percentage: Add the percentage here.
• You can Edit only parent products or Edit only variations.
• Finally, click on Execute Now.

As you can see below, we have bulk updated the product prices:

To read more tutorials on how to bulk edit WooCommerce products, you can read our blog.

View and manage product variations

If you want to manage WooCommerce variations, you would normally have to open a product, go to variations, and make changes to each variation. This is too complicated a process.

Fortunately, in WP Sheet Editor you can bulk manage product variations using the spreadsheet.

You just have to click on Display variations and the variations will be displayed on the spreadsheet next to their parent product.

WooCommerce bulk variations manager

If you want to create variations or copy variations between products, you can do it easily with our WooCommerce Variations Manager.

To open the Variations Manager, click on Create variations.

You’ll have two options:

1) Create variations

If you want to Create variations:

• The variations are for these products:
  • Individual products
  • All the products from a specific search
  • All the variable products
• Select how many variations you want to create:
  • A specific number of variations
  • Create variations for every combination of attributes

2) Copy variations

If you want to Copy variations:

• Copy variations and attribute from this product: Here you can select any variable product containing variations, from which you’ll copy the variations and the attributes.
• I don’t want to copy all the variations: If you tick this checkbox, you can select specific variations to copy.
• The variaitons are for these products: You can select any of these options:
  • Select individual products
  • All products from a search
  • All variable products
• Show advanced options:
  • Use prices from simple product (parent) on the variations
  • Only copy new variations
  • Do not copy the variation images

Bulk edit WooCommerce products offline (Export to CSV)

WP Sheet Editor allows you to export your WooCommerce products data to a CSV file.

If you want to export all your WooCommerce products to bulk edit product data offline, you need to follow these steps:

First, open the Export tool.

Once you’re in the Export tool, you need to select these values:

• What columns do you want to export: You can export specific columns, all the active columns (columns that are visible in the spreadsheet, depending on your column configuration), or all the columns (both active or inactive columns). 
• Which rows do you want to export: You can export all the products, all the products from a specific search, or all the products you’ve manually selected in the spreadsheet.
• What app will you use to edit this file: You can select any of these options:
  • Microsoft Excel (Office 365)
  • Older versions of Microsoft Excel
  • Google Sheets
  • Other
• Name of this export: You can add a name for this export in this field. Then, when you hover over the Export tool, you’ll be able to reuse this export.
• Click on Start new export.

Once the export process is complete, you’ll be able to bulk update your WooCommerce products using Excel, Google Sheets, or any other CSV editor.

Import WooCommerce products from CSV

After bulk editing your WooCommerce products in a CSV, you can import the products’ data back into your WordPress site.

To do this, you need to start by opening the Import tool.

Then you need to select the CSV file you’ll import by selecting these values:

• Source:
  • CSV file from my computer (we’ll select this option)
  • CSV file from URL
  • Copy and paste from another spreadsheet or table
  • CSV file in the server
• Click on Choose File and select the file from your computer.
• Click on Next.

You can Import all the columns or Select individual columns to import.

You need to select how you want to import the data:

• Do you want to update or create items:
  • Create new items and update existing items
  • Import all rows as new
  • Only create new items, ignore existing items
  • Only update existing items, ignore new items
• If you select any option to update existing items, you will have to match the rows using any field. We recommend the ID field.
• Click on Next.

Finally, you’ll see a preview.

If everything is OK, you need to click on The preview is fine, start import.

Important Questions

Let’s consider some important questions about the WP Sheet Editor plugin.

Is WP Sheet Editor compatible with custom fields?

Yes. WP Sheet Editor is compatible with custom fields, so you’ll be able to edit fields added by plugins like Advanced Custom Fields and any other plugin that adds custom fields to your WooCommerce products.

Here are some plugins that allow you to add custom fields to your WooCommerce products, which you can edit with WP Sheet Editor in the spreadsheet:

• Advanced Custom Fields (ACF)
• Product Addons for WooCommerce
• Extra Product Options for WooCommerce
• Flexible Product Fields for WooCommerce

Is WP Sheet Editor compatible with multilingual / translation plugins?

Yes. WP Sheet Editor is compatible with popular multilingual plugins such as WPML, Polylang, and others.

Here are some related tutorials:

• Bulk translate products with WPML and WP Sheet Editor
• Export and import product translations made with Polylang

Best bulk editor for WooCommerce products

Running a WooCommerce store is great, but managing a lot of product data can be overwhelming sometimes. Imagine having to update prices, adjust stock levels, or tweak product descriptions for hundreds of items. That takes a lot of time. But what if there was a better way to do it?

Well, WP Sheet Editor is your best option. This powerful plugin brings the simplicity and efficiency of a spreadsheet directly to your WooCommerce store. You can bulk edit your products with a few simple clicks, reducing the hours you spend on product management.

Need to update the prices for a seasonal sale? Adjust stock levels after a big shipment? No problem. With WP Sheet Editor, you can bulk edit your WooCommerce products in minutes, not hours.