Wait!

Lifetime licenses are only available for a short time, don't miss out!

Any File Type

No need to reorganize your data, just upload your file to WP All Import and it'll sort it out.

Complete Customization

Granular control over every single piece of data. Think your import is too complicated? Think again.

Import Huge Datasets

It doesn't matter how big your site is or how much data you need to import, WP All Import can handle it. 

Multilingual Imports

Importing data to multilingual sites has never been easier, with support from the WPML team.

Scheduled Imports

Run imports automatically on a schedule. Subscribe to our point and click scheduling service, or set up cron jobs.

Developer Friendly

Write and test PHP right inside WP All Import when setting up your import, with tons of snippets to get you started.
@glitzformals
"This plugin is a game changer for my situation. I’m stunned at how fast and effortless the import process is."
@adatfalo
"I have never experienced such a quick and helpful support experience with any plugin, and by the way, the knowledge of the support colleagues is professional!"
@jessedw44
"Even if you just use this plugin once, it will save you time. If you work on several sites its invaluable. Constantly developed, and continuously supported. Great job."
90-Day Guarantee
Not 100% happy? Let us know and we’ll promptly send you a refund.
Free Updates For Life
Pay once for unlimited installs, even client sites. No renewal fees.
Fast, World Class Support
Over 9 years experience with WordPress imports and exports.
Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing licenses will be unaffected.
Read More

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.

This documentation covers how to bulk edit WordPress data using WP All Import and WP All Export. For a broader look at bulk editing WordPress data, check out: Bulk Edit WordPress Data

 

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:

Bulk Edit WordPress Data 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.

Bulk Edit WordPress Data Drag and Drop

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.

Bulk Edit WordPress Data Confirm and Run

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.

Bulk Edit WordPress Data Download CSV

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.

Bulk Edit WordPress Data Modify CSV File

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.

Bulk Edit WordPress Data Import with WP All Import

If you already closed that screen, you can find the same option in All Export › Manage Exports:

Bulk Edit WordPress Data 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.

Bulk Edit WordPress Data Upload Edited File

Your file will be uploaded, and you'll be taken directly to Step 3 of the new import process.

Bulk Edit WordPress Data Mapped Fields

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.

Bulk Edit WordPress Data Import Settings

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.

Bulk Edit WordPress Data Import Complete

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.

Bulk Edit WordPress Data Add Filtering Options

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:

Bulk Edit WordPress Data Error with Import File

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?

  1. Go to All Export › New Export and select Pages as your export type.
  2. Download the exported file and bulk edit your pages in any spreadsheet software.
  3. Apply the bulk edit changes using the Import with WP All Import option.
  4. Verify that the changes were properly applied.

How Do I Migrate WordPress or WooCommerce Data?

  1. 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.
  2. On the destination site, upload the bundle file. The bundle file contains all the instructions that WP All Import needs to configure the import.
  3. Run the import.
  4. Verify that the data has been migrated as expected.

Related Docs

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.

Lifetime support. Lifetime updates. Pay once.

Packages
Standalone
Import
Pro Package
$249
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Pro Package
$299
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
WooCommerce Import Package
$149
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Import + Export Standalone
$169
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
Export Standalone
$99
one-time
  • Import Pro
Import Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
  • Types
  • Export Pro
Export Add-Ons
  • WooCo
  • ACF
  • Gravity Forms
  • Users
Add to Cart
90 Day Money Back Guarantee
cross