How to Bulk Edit WooCommerce and WordPress Data
You can quickly bulk edit WooCommerce and WordPress data using WP All Import and WP All Export. First, export data using WP All Export. Make changes to this data using your favorite spreadsheet program (Excel, Numbers, etc.). Then apply those changes using WP All Import.
Here's a video that shows how the bulk edit process works:
Continue reading below for text instructions.
Step 1: Select What You Want to Export
You must first decide which post type or taxonomy you want to edit. You'll see all the available options in the dropdown at the start of a new export via All Export › New Export:
You can also add data filters in this step.
Once done, click Customize Export File to continue (not shown).
Step 2: Decide Which Data to Bulk Edit
Next up is the Drag & Drop screen. All of the fields available for data export are shown in the Available Data section on the right. To include a field in the export, drag it from that section to the column selection area.
If you intend to bulk edit this data, you must include key identifying fields so that WP All Import can correctly apply your changes when you import them. Depending on the post type being exported, you'll see a message if you're missing any of these key fields.
Once you've added the fields that you want to bulk edit, click the Continue button (not shown).
Step 3: Confirm & Run the Export
You'll now see the Export Settings screen. These settings can usually be left alone.
Click Confirm & Run Export to run the export.
Step 4: Download Export File and Update the Exported Data
Once the export completes, download the generated CSV file.
Using the program of your choice (i.e., Excel, Numbers, etc.), open the export file and make the necessary edits. Don't remove any columns or there may be missing data after the import runs.
Save the edited file using the same file type.
Step 5: Generate a New Import to Apply Bulk Edit Changes
If you click the Export, Edit, Import tab in WP All Export's Confirm & Run screen, you will see an Import with WP All Import option near the bottom of the screen.
If you already closed that screen, you can find the same option in All Export › Manage Exports:
To import your modified data, click this option. It will automatically configure the import settings based on the fields you set in your export.
After selecting this option, you'll be asked to provide the import file. Choose Upload a file and select the CSV file that you just modified.
Your file will be uploaded, and you'll be taken directly to Step 3 of the new import process.
The data to be updated is already mapped to the appropriate import fields. You can examine what was mapped or just continue to the next step.
Step 6: Confirm & Run Import, then Verify Edited Data
Next, you'll see the Import Settings screen. Here you can modify what data to update during the import, though there is seldom a need to change this. Click Continue at the bottom.
Finally, you'll arrive at the Confirm & Run screen (not shown), where you can review an Import Summary section. Check the import data and click on Confirm & Run Import button to run the import and finish the bulk edit process.
Once the import is complete, you can check the edited records to confirm that the bulk changes were applied as expected.
Bulk Edit WordPress Data – Advanced Topics
Filter Data to Selectively Bulk Edit
If you don't need to bulk edit all the records from your selected post type, you can use export filters to select which records to edit.
To do so, use Add Filtering Options when creating the new export and input your desired filter.
If your export already exists, you can add filters via All Export › Manage Exports › Settings before running it again.
Learn more about adding filters in: Filter Exported WordPress Data.
Bulk Edit Data via PHP Code
The bulk edit process described in this document requires that you export the data, modify it externally, and then re-import it back into your site.
As an alternative, you can use custom PHP code to perform the changes directly within an import and modify the data on-the-fly.
For example, if you need to add or append extra content to the existing content, you can create a function to do so. You can call this function in Step 5 (from the guide above) when setting up the import template in WP All Import.
For examples of this, see Calling PHP Functions in Your Import Configuration.
Solve the "There's a problem with your import file" Error
In some cases, you may see the following message:
This message means that the structure of the import file (i.e., the columns) has changed in some way.
To solve this error, review your import file and make sure that all column names and the file structure itself remain the same as in the exported file (see Step 4 in the guide above).
If you're not entirely sure what's wrong, you can download a fresh copy of the export, repeat the bulk edits, then re-import everything again.
Frequently Asked Questions
Can I Bulk Edit WooCommerce Products?
Absolutely. Bulk editing WooCommerce products is no different than bulk editing any other type of WordPress or WooCommerce data. All you have to do is choose WooCommerce Products at the start of the process described in this guide. Otherwise, the process is the same.
How Do I Bulk Edit WordPress or WooCommerce Categories?
There are two methods of doing this. To bulk edit categories on their own, you can follow a process similar to the one described in this guide. Just select the appropriate category at the start of the export process.
Alternatively, you can include category information when exporting another post type (such as WordPress posts or WooCommerce products). If you modify this category information, you can tell WP All Import how to apply those changes during the import process.
How Do I Bulk Edit All Pages in WordPress?
- Go to All Export › New Export and select Pages as your export type.
- Download the exported file and bulk edit your pages in any spreadsheet software.
- Apply the bulk edit changes using the Import with WP All Import option.
- Verify that the changes were properly applied.
How Do I Migrate WordPress or WooCommerce Data?
- On the source site, use WP All Export to export the data in question, but download a bundle file instead of just the data file.
- On the destination site, upload the bundle file. The bundle file contains all the instructions that WP All Import needs to configure the import.
- Run the import.
- Verify that the data has been migrated as expected.
Learn how to bulk edit WooCommerce products from your site.
Learn to export your WordPress data to a CSV, Excel, or XML file with WP All Export.
Learn how to import any CSV or XML file to WordPress using WP All Import.