--- title: "Bulk Editing WooCommerce Products with WP All Export and WP All Import" id: "183068" type: "post" slug: "bulk-editing-products-with-wp-all-import" published_at: "2022-05-12T14:42:42+00:00" modified_at: "2026-08-14T11:34:42+00:00" url: "https://fooplugins.com/bulk-editing-products-with-wp-all-import/" markdown_url: "https://fooplugins.com/bulk-editing-products-with-wp-all-import.md" excerpt: "Managing a WooCommerce store can be complicated when you have hundreds or even thousands of products. Imagine that you need to make changes to 300 products in your store. Unfortunately, WooCommerce lacks the necessary tools to bulk edit data in..." taxonomy_category: - "FooPlugins Guide" taxonomy_post_tag: - "import/export" - "woocommerce" --- [FooPlugins Guide](https://fooplugins.com/category/fooplugins-guide/) # Bulk Editing WooCommerce Products with WP All Export and WP All Import Author**[FooPlugins](https://fooplugins.com/author/generic-author/)** Reviewed By**Brad Vincent** Created**May 12, 2022** Last Updated**August 14, 2026** ![Bulk Editing WooCommerce Products with WP All Export and WP All Import](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20964%20480'%3E%3C/svg%3E) Managing a WooCommerce store can be complicated when you have hundreds or even thousands of products. Imagine that you need to make changes to 300 products in your store. Unfortunately, WooCommerce lacks the necessary tools to bulk edit data in simple steps. Out of the box, it forces you to manually change one product at a time. This article presents you with an alternative that makes this process quick and straightforward. Enter WP All Export and WP All Import. WP All Export allows you to export your WooCommerce product data easily, even if some of the data is added by a third-party plugin. You can then modify this data using your favorite spreadsheet, where functions like search-and-replace and copy-and-paste are quick and intuitive. WP All Import lets you import the changed data back into WooCommerce. Because WP All Export and WP All Import are fully integrated, you can perform this update with minimal effort. ## How to Bulk Edit WooCommerce Products Easily Let’s say that you have a [WooCommerce product gallery](/foogallery-wordpress-gallery-plugin/woocommerce-integration/) with around 3,000+ products. Previously, to support a sale, you manually added an “ON SALE – ” prefix to the title of 300 of these products. You also entered a new sale price. These edits took around 20 seconds per product or nearly 2 hours of manual data entry. Now the sale has finished and you need to modify the product data again. You didn’t add an end date to the sale price, so you need to remove that price and leave only the regular price. You also need to edit the 300 products to remove the “ON SALE -” prefix from the product titles. This time, you plan to work smart instead of hard! Make sure to install WP All Export and WP All Import on your site if you haven’t already done so. Then follow the steps below to bulk edit WooCommerce product data. ### Step 1: Export WooCommerce Products and Apply Filters Go to **All Export › New Export** and choose to export **WooCommerce Products** from the dropdown list. WP All Export will display the number of products that will be exported: ![new export in wp all export](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20620'%3E%3C/svg%3E) As you can see, all 3,011 products will be exported by default. However, we only need to export the 300 products that were on sale, so expand the **Add Filtering Options** section. Under **Element**, select **Sale Price**. For **Rule**, choose **is not empty**, then click the **Add Rule** button. ![add rule](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%201200%20646'%3E%3C/svg%3E) We can use different logic to filter the products that were on sale and still get the same results. For example, we can filter by **Title** as the element, choose **contains** as the rule, and input “ON SALE” as the value. ![customize export](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20415'%3E%3C/svg%3E) Either filter will work. In fact, using AND/OR conditions and nested filters (not shown), you can always export exactly the data you want. Once you’ve input your desired filter rules, click on the blue **Customize Export File** button to proceed. ### Step 2: Select the Desired Export Columns Now you’ll see the **Drag & Drop** screen. Here, you can choose the fields that you want to export. The **Title** field is already selected by default, but since we want to bulk edit pricing information, we also need to expand the **Available Data › Product Data** section and drag the **Regular Price** and **Sale Price** fields into our column selection area, too. ![drag n drop](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20569'%3E%3C/svg%3E) To review your export data, click the green **Preview** button. Click **Continue** to move to the next step. ### Step 3: Complete the Export In the **Export Settings** screen, you can define **Scheduling Options** and modify other **Advanced Options**. You can also assign a different **Export Name**. In this case, you won’t need to change these settings, so click **Confirm & Run Export**to proceed. ![run export](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20557'%3E%3C/svg%3E) Once the export completes, download the exported **CSV** file and open it in your favorite spreadsheet software. ### Step 4: Modify the Exported WooCommerce Products To bulk edit WooCommerce products, we’ll be doing some fairly simple modifications. We use LibreOffice in this example guide. To remove the “ON SALE – “ tag from the title, we create a new column and apply the following formula to its first data row: SUBSTITUTE(B2, “ON SALE – “, “”) ![modify products](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20259'%3E%3C/svg%3E) We then paste this formula into all remaining data rows for this new column. Finally, we copy and paste the values from the formula results into the **Title** column, then remove the extra column: ![remove column in wp all export](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20387'%3E%3C/svg%3E) To remove the sale pricing, we simply erase all prices from the **Sale Price** column. ![remove sale price](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20540'%3E%3C/svg%3E) We need to keep the file’s column structure exactly the same as it was created by the export plugin. This ensures that there are no issues when re-importing the data. ### Step 5: Import the Modified Spreadsheet with the Bulk Edit Changes Go to **All Export › Manage Exports** and select the **Import with WP All Import** option. ![import modified spreadsheet with wp all import](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20263'%3E%3C/svg%3E) The **New Import** screen will appear, which allows you to upload a file. Choose your modified export file, then click on **Continue to Step 2**. ![upload file](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20319'%3E%3C/svg%3E) Because you selected the **Import with WP All Import** option associated with your previous export, WP All Import already understands the structure of your import file. As a result, it will automatically set the correct mappings in the **Drag & Drop** screen: ![drag n drop screen](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20494'%3E%3C/svg%3E) Scroll down and click **Continue to Step 4** (not shown). Next up is the **Import Settings** screen (again, not shown). Everything is already mapped, so click **Continue**. This will bring you to the **Confirm & Run** screen. To update the target products, click on **Confirm & Run Import**. ![confirm and run import](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20524'%3E%3C/svg%3E) Finally, you will see the **Import Complete** screen. ![import complete](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20566'%3E%3C/svg%3E) That’s it! If you go to **Products** **› All Products**, you will see that the “ON SALE -” prefix and the sale price have both been removed from the 300 target products. ![products have been modified](data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20750%20179'%3E%3C/svg%3E) ## Wrapping Up The process to bulk edit WooCommerce Products using this export/import plugin is fairly simple and quick! Remember that it took around 2 hours to make these changes manually? Using the method described above, you can reduce that time to less than 10 minutes! To learn more about these processes, see [Export WooCommerce Products](https://www.wpallimport.com/woocommerce-product-export/) and [Import WooCommerce Products](https://www.wpallimport.com/woocommerce-product-import/) . About the Author [https://fooplugins.com/author/generic-author/](https://fooplugins.com/author/generic-author/) [FooPlugins](https://fooplugins.com/author/generic-author/)