Lifetime licenses are only available for a short time!

Now is your last chance to buy a lifetime license before we switch to annual pricing. Existing lifetime licenses will be unaffected so get in while you can!
  • 90-Day Money-Back Guarantee
  • Fast World Class Support
  • Unlimited Sites
  • Free Lifetime Updates
  • Easy to Use
  • Developer Friendly
Risk free! Cancel at any time with our 90-day guarantee
Get a lifetime license now for only 
$99
"All Import/Export is an awesome suite of tools. It gets me out of some tough challenges."
Eric Karkovack, Freelance Writer
"WP All Import - Versatile, and I have saved so much time with it over the years."
Matt Andrews, Full Stack Web Developer
"@WPAllImport just let me import 3000 products from some arbitrary Excel to WooCommerce w/ a few clicks, including images and categories."
Joris Witteman, Developer / Designer

Wait, Don’t Miss Your Chance for a Lifetime License!

@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.

World Class Support

Over 9 years experience with WordPress imports and exports.

Your Last Chance for a Lifetime License!

We are soon moving to yearly licenses only. Once lifetime licenses are gone, they're gone forever.
@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.

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 Products

To bulk edit WooCommerce Products, go to 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 All Export › Manage Exports and upload the edited file using the Import with WP All Import option.

This documentation covers how to bulk edit WooCommerce products using WP All Import and WP All Export. For a broader look at bulk editing WooCommerce products, check out:

Step 1: Create WooCommerce Product Export

Go to All Export › New Export and select WooCommerce Products.

Here, you can Add Filtering Options to control which products to you intend to bulk edit.

Bulk Edit WooCommerce Products New Export

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 that you would like to 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.

Bulk Edit WooCommerce Products Define Export Columns

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.

Bulk Edit WooCommerce Products Export Settings

Step 3: Bulk Edit the WooCommerce Product Data

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.

Bulk Edit WooCommerce Products Confirm and Run Export

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:

Bulk Edit WooCommerce Products Numbers Example

Once you've completed your 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 the Modified Spreadsheet to Apply the Product Bulk Edits

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:

Bulk Edit WooCommerce Products Export Edit Import

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:

Bulk Edit WooCommerce Products Import with WP All Import

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.

Bulk Edit WooCommerce Products New Import

You will now see the Drag & Drop screen with all the import mappings automatically selected for you.

Bulk Edit WooCommerce Products Import Mappings

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.

Bulk Edit WooCommerce Products Import Settings

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:

Product Import Complete

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:

Bulk Edit WooCommerce Products Wrong Import File

To solve this, you should review the file that you're importing 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 Apply Product Bulk Edits

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.

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.

Bulk Edit WooCommerce Products — Frequently Asked Questions

How Do I Bulk Edit a Product Description?

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. Product descriptions are easy because there are no dependencies on them.

How Do I Bulk Edit Product Categories in WooCommerce?

  1. Create a new export of WooCommerce products and include the categories that will be modified.
  2. Download the exported products and edit the categories as needed.
  3. Re-import the WooCommerce products back to apply the category changes.
  4. Make sure to verify your changes after completing the import.

How Do I Bulk Edit Variations?

To bulk edit WooCommerce product variations, use our drag & drop tool to export your custom CSV file. Open this file in Excel, bulk edit your product variations, then re-import the file back into WordPress. Don't forget to check everything after the re-import.

How Do I Bulk Edit Product Attributes?

Bulk editing product attributes is no different than bulk editing anything else in WordPress or WooCommerce. WP All Export will help you get the data in a spreadsheet. Once you're finished editing the data, the Import with WP All Import option makes it easy to apply the changes.

What is the Best Way to Bulk Edit Thousands of WooCommerce Products?

If you have thousands of products to bulk edit, this plugin is by far your best option. Thanks to its ability to process imports and exports in batches, you can bulk edit an unlimited number of products without having to worry about overloading your system.

How to Export WooCommerce Products?

  1. Go to All Export â€º New Export.
  2. Select WooCommerce Products as your export post type.
  3. Use our Drag & Drop interface to select your export columns.
  4. Run the export.
  5. Download your product file.

For a full list of import features, see Export WooCommerce Products.

How Do I Import Bulk Products into WooCommerce?

  1. Go to All Import â€º New Import.
  2. Choose your method to load data (i.e., upload a file, download a file from a URL, etc.).
  3. Choose your import file and select your import target (i.e., WooCommmerce Products).
  4. Use our Drag & Drop interface to map incoming data elements to their target product fields.
  5. Run the import.

For a full list of import features, see Import WooCommerce Products.

How to Migrate WooCommerce Products to a Different Website?

  1. Export a set of WooCommerce products but download the Bundle option instead of just the data file. The Bundle option includes instructions on how to import the exported data.
  2. Import the bundle file on the import site. WP All Import will automatically configure its import settings based on the instructions in the bundle file.
  3. Complete the import.
  4. Review your imported products.

For additional information, see Migrate WooCommerce Products.

Bulk editing variable products? This is how you handle the export portion of it.

Learn how to import variable products to complete the bulk editing process.

Execute custom code to modify imported WooCommerce product data on the fly.

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