How to Bulk Edit WooCommerce Products in WordPress

Editing single WooCommerce products individually take a considerable amount of time. It is especially tedious if the same criteria are being changed or updated for each product. Anyone who has managed a large WooCommerce catalog knows that editing single products one at a time can take forever.

You could use the “Quick Edit” button which is found on the Products page when hovering over a product. However, this is not the fastest way to update or make changes to a group of products. You’d want to use this feature primarily when editing on the fly.

This tutorial will show you how to bulk edit WooCommerce products in WordPress without using a separate third-party plugin.

What Product Information Is Allowed to Be Bulk Edited in WooCommerce?

WooCommerce comes with its own built-in bulk editor. The following field options are available:

• Product categories and sub-categories
• Comments (Allow or Do not allow)
• Status (Published, Private, Pending Review, or Draft)
• Product tags
• Product Data (Price, Sale Price, Weight, L/W/H, Shipping class, Visibility, Featured, Stock status, and Sold individually)

You may notice additional options available depending on which theme and plugins are active.

What Are the Common Reasons to Bulk Edit WooCommerce Products?

Here are the most common reasons to bulk edit products:

• Changing product categories
• Price increases and decreases
• Featured product status
• Adding / Removing Tags
• Shipping Classes
• Product Visibility

Whatever your reasons are for changing any of the above information on a selected list of products, the bulk edit method is the fastest way to go.

The following is a step-by-step process to bulk edit WooCommerce products.

How to Bulk Edit WooCommerce Products in WordPress

The following is a step-by-step process to bulk edit WooCommerce products.

Step 1

Go to the WooCommerce products page in the WordPress admin:

Click the “Filter by category” field at the top of the page. Then select the desired category to narrow down the list of products to be edited. Finally, click the “Filter” button to refresh the page. Only the products of the selected category will be shown.

TIP: The “Screen Options” button at the top right of the page will allow you to change how many products you can bulk edit at a time. Changing the number of products per page will make the bulk editing process go faster. In addition, you can also choose what information is displayed on the page.

Step 2

Now click the checkbox next to each product that will be bulk edited.

Step 3

Choose “Edit” in the drop-down box and click “Apply”.

Step 4

Make the changes to the selected products. Click the blue “Update” button when done.

NOTE: Don’t forget to use the percent sign if the price is being adjusted up or down by a percentage.

Final Thoughts

The built-in bulk editor that comes with WooCommerce is very basic and requires you to select the products manually to be bulk edited. As a result, this may be difficult and time-consuming in a large catalog of thousands of products.

Some premium plugins, such as the WooCommerce Advanced Bulk Edit plugin, include an advanced search to find and select the products before bulk editing. This is a very handy feature to help narrow down products based on specific search criteria.

WooCommerce Advanced Bulk Edit offers an online demo to test the plugin’s features before purchasing.

Need help? Our WooCommerce Development Service is a complete solution for new or existing WooCommerce websites. Call us at 602-633-4758 for a free consultation.