How to Bulk Edit WooCommerce Products in Simple Steps
To bulk edit WooCommerce Products, go to WP All Export › New Export and choose which products and product fields to export. Download the exported products and use a spreadsheet to make the changes in bulk. Once done, go to WP All Export › Manage Exports and upload the edited file using the Import with WP All Import option.
Step 1: Export WooCommerce Products to Bulk Edit
Go to All Export › New Export and select WooCommerce Products.
Here, you can Add Filtering Options to control which products to bulk edit.
In this case, click Customize Export File to continue without adding filters.
Step 2: Choose Which Product Data Fields to Bulk Edit, Then Complete the Export
Next, the Drag & Drop screen appears, which allows you to select the fields to bulk edit. To do so, search the data fields under the Available Data section, then drag and drop the desired fields into the selection area on the left.
Let's say that you need to bulk edit all of your product prices to reduce them by $10 dollars. You would include the Regular Price export field (found under Available Data › Product Data).
Once you have included the desired export fields, click the blue Continue button.
You will now see the Export Settings screen. You can leave these settings with their default selections. If you're not sure what a setting does, review its tooltip.
To complete the export, click on Confirm & Run Export.
Step 3: Modify Data to Bulk Edit WooCommerce Products
Once the export is complete, you will see the Confirm & Run screen. Here, you need to download the exported file and bulk edit it via your preferred spreadsheet software.
To download the file, click the blue CSV button below Click to Download. If you are exporting to XML or Excel, the button label will reflect the correct file format.
Open the export file with spreadsheet software such as Microsoft Excel, Numbers, or Google Sheets to perform the bulk edit.
Spreadsheets allow you to modify the data quickly and in bulk, using search-and-replace or copy-and-paste capabilities.
In this guide, we use Numbers:
Once you've completed your bulk editing, save the exported file using the same file type. Make sure to keep the exact same file structure and format to ensure that the import program can correctly parse the data.
For example, the CSV file should still use commas as the separator and retain the same column headers.
Step 4: Import Modified Spreadsheet to Bulk Edit WooCommerce Products
Back in WP All Export, if you are still in the Confirm & Run screen, select the Export, Edit, Import tab and then use the Import with WP All Import button:
If you're no longer on this screen, navigate instead to All Export › Manage Exports, locate the correct export, and then use the same Import with WP All Import option:
Whichever method you use, you'll be taken to the New Import screen, where you can upload the previously exported file. This import will automatically synchronize with the previously exported products.
Click Continue to Step 2 after uploading the modified export file.
You will now see the Drag & Drop screen with all the import mappings automatically selected for you.
Scroll down to the end of the page and click on Continue to Step 4 (not shown).
The Import Settings screen appears next. Here, you don't need to change anything, so just click Continue at the bottom of the page.
The next screen, Confirm & Run, will include an Import Summary section (not shown). Review everything and then click on the green Confirm & Run Import button to finish the bulk edit process.
Once the import completes, you will see an Import Complete section along with a log of the changes made:
All done! That's how you bulk edit WooCommerce products in simple steps.
Bulk Edit WooCommerce Products Advanced Topics
Learn to Avoid the "There's a problem with your import file" Error
The bulk edit process requires certain columns to be present in your exported file so that it can be re-imported using the import plugin.
If those columns are missing or you changed the file column structure, you will see a message like the following:
To solve this, you should review the file that you're uploading to ensure that all column names and the file structure remain the same as in the exported file (see Step 2 above).
If you're not certain what's wrong, it's best to download a fresh copy of the exported file and perform the bulk edit changes again. You shouldn't delete or change any of the columns when editing the file.
Once you use the correct file, the re-import should work properly.
Use PHP Functions to Bulk Edit WooCommerce Products
The bulk edit process explained above requires that you download the exported file with your WooCommerce products, then perform the changes and re-upload the file to re-import everything.
That said, you may also want to perform the changes directly within the import by using a custom PHP function that modifies the data on-the-fly.
For example, you may want to mark up your prices using the Markup Price with Minimum and Maximum Limits code snippet. You can follow the steps from this guide, but instead of modifying the exported file manually, you just apply that function in the import process.
That way, you can edit the product prices in bulk without having to modify the actual exported file. This same logic can be applied to more complex cases and scenarios.
Frequently Asked Questions
How Do I Bulk Edit a Product Description in WordPress?
Just follow the steps from this guide to generate an export file with all of your WooCommerce products and their descriptions. Then, modify the descriptions using spreadsheet software and re-import everything back using the Import with WP All Import option.
How Do I Bulk Edit Categories in WooCommerce?
Modifying taxonomy data is also a possibility. In order to bulk edit product categories, do the following:
- Create a new export with WooCommerce products and include the categories that will be modified.
- Download the exported products and modify the categories as needed.
- Re-import the WooCommerce products back to apply the category changes.
Review the full guide to see the step-by-step instructions.
Learn how to migrate WooCommerce products from one WordPress site to another.
Export WooCommerce products into a CSV or XML file with WP All Export.
Execute custom code to modify imported WooCommerce product data on the fly.