Editing single WooCommerce products individually take a considerable amount of time and can become tedious, especially if the same criteria are being changed or updated on each product. Anyone who has managed a large WooCommerce catalog knows that editing single products one at a time can take forever.
There is, of course, the “Quick Edit” button (when hovering over a product) which is primarily used for editing on the fly, but still is not the fastest way to update or make changes to a group of products.
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 when editing products in bulk:
- Product categories and sub-categories
- Sidebar and Footer options (Sidebar layout, Show Footer, Choose sidebar, Choose footer)
- 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)
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.
In the WordPress admin go to the WooCommerce products page:
Products > All Products
To narrow down the list of products to be edited, click the “Filter by category” field at the top of the page and select the desired category. Then click the “Filter” button to refresh the page. Only the products of the selected category will be shown.
TIP: You may need to adjust what product information is displayed on the page, as well as how many products are shown per page. This can be done by clicking the “Screen Options” button at the top right of the page.
Now click the checkbox next to each product that will be bulk edited.
Choose “Edit” in the drop-down box and click “Apply”.
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.
The built-in bulk editor that comes with WooCommerce is very basic and requires you to select the products manually to be bulk edited. 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.