{"id":26331,"date":"2024-01-01T18:07:41","date_gmt":"2024-01-01T18:07:41","guid":{"rendered":"https:\/\/ithemelandco.com\/?p=26331"},"modified":"2026-03-11T11:01:39","modified_gmt":"2026-03-11T11:01:39","slug":"woocommerce-bulk-edit-product-sale-price","status":"publish","type":"post","link":"https:\/\/ithemelandco.com\/blog\/woocommerce-bulk-edit-product-sale-price\/","title":{"rendered":"How to Bulk Edit Price and Sale Price in WooCommerce for Simple and Variable Products"},"content":{"rendered":"\n

Managing product prices in a WooCommerce store can become challenging when you have a large catalog. Store managers often need to update product sale prices during seasonal campaigns, discounts, or promotional events. Editing each product individually is not only slow but also increases the chance of mistakes.<\/p>\n\n\n\n

This is where bulk editing product prices in WooCommerce<\/strong> becomes extremely useful. Instead of opening each product page separately, you can select multiple products and update their sale prices simultaneously.<\/p>\n\n\n\n

For example, imagine you want to apply a 20% discount to all products in a category during a seasonal sale. Manually editing dozens or hundreds of products would take a long time. By using WooCommerce bulk price editing tools, you can apply the change to all selected products in just a few steps.In this guide, we will explain three practical methods to bulk edit product sale prices in WooCommerce<\/strong>. First, we will review how to do it using WooCommerce\u2019s default bulk editor. Then we will show a more advanced solution using PBULKiT as a bulk editing plugin. Finally, we will explain how to update prices using the import and export CSV method.<\/p>\n\n\n\n

What is the WooCommerce bulk edit sale price?<\/h2>\n\n\n\n

Bulk edit product sale price in WooCommerce is a quick and easy way to change the price of multiple products simultaneously. By using this method, store managers can increase and decrease the sale price of multiple products at once. <\/p>\n\n\n\n

As a result, they do not need to visit the page of each product separately and edit the sale price. Rather, they can choose all the products they want and change their sale prices simultaneously. <\/p>\n\n\n\n

WooCommerce bulk edit sale price helps store managers to make changes in product prices with fewer mistakes and lets them do their tasks faster and easier.<\/p>\n\n\n\n

1. Bulk edit sale price in WooCommerce without a plugin<\/h2>\n\n\n\n

The default editor of WooCommerce has some limited options for filtering and bulk editing product sale prices. To have access to this editor, open the Products<\/strong> menu and press the All Products<\/strong> submenu: <\/p>\n\n\n\n

\"select<\/a>
Open WooCommerce products<\/figcaption><\/figure>\n\n\n\n

In the WooCommerce product list page, follow the below steps to change WooCommerce sale price in bulk:<\/p>\n\n\n\n

Step #1: Filter desired products<\/h3>\n\n\n\n

The first step for bulk editing product sale prices, is to filter them by Category<\/strong>, Types,<\/strong> or Stock Status<\/strong>. To filter products, simply open the combo box of each field and choose your desired option from the list. Then press the Filter<\/strong> button.<\/p>\n\n\n\n

\"filter<\/a>
WooCommerce products default toolbar<\/figcaption><\/figure>\n\n\n\n

Step #2: Select some products<\/h3>\n\n\n\n

When WooCommerce displays the filtered products in the table, you need to mark some of them to use the editor.<\/p>\n\n\n\n

Step #3: Bulk edit product sale price in WooCommerce<\/h3>\n\n\n\n

After selecting some products, open the combo box of Bulk Actions,<\/strong> then choose Edit<\/strong> from the list and press the Apply<\/strong> button.<\/p>\n\n\n\n

\"Bulk<\/a>
Bulk edit products<\/figcaption><\/figure>\n\n\n\n

By doing this, you will see the bulk edit form of WooCommerce. In this form, locate the Sale field<\/strong> and open the combo box before it.<\/p>\n\n\n\n

As illustrated below, there are three options you can choose to bulk edit sale price WooCommerce, including:<\/p>\n\n\n\n

    \n
  1. Increase existing sale price by (fixed amount or %):<\/strong> This is useful when you already set sales prices for your products and you need to increase them by a fixed amount or percentage.<\/li>\n\n\n\n
  2. Decrease existing sale price by (fixed amount or %):<\/strong> This is useful when you already set sales prices for your products, and you need to increase them by a fixed amount or percentage.<\/li>\n\n\n\n
  3. Set to regular price decreased by (fixed amount or %):<\/strong> This is a good option for changing the sale price based on regular price.<\/li>\n<\/ol>\n\n\n\n
    \"select<\/a>
    Change Sale price in bulk<\/figcaption><\/figure>\n\n\n\n

    For example, if you want to add $20 to the existing sale price, choose Increase by fixed<\/strong> amount<\/strong>, then type 20 in the textbox and press the Update <\/strong>button.<\/p>\n\n\n\n

    \"select<\/a>
    Update the sale price<\/figcaption><\/figure>\n\n\n\n

    As you can see the changes are applied to the sales prices as we expected:<\/p>\n\n\n\n

    \"result<\/a>
    Result of bulk edit price<\/figcaption><\/figure>\n\n\n\n

    Although bulk editing with the WooCommerce default editor is quick and easy, you don\u2019t have flexibility in filtering products. In addition, some store managers complain that the interface of the WooCommerce editor is not as user-friendly as they need.<\/p>\n\n\n\n

    The good news is that you can solve all of these problems by using the WooCommerce products bulk editing plugin. <\/p>\n\n\n\n

    Let\u2019s see how.<\/p>\n\n\n\n

    2. Change product sale prices by the WooCommerce products bulk edit plugin<\/h2>\n\n\n\n

    WooCommerce products bulk edit plugin<\/a><\/span> is a powerful tool that helps you easily manage your products and edit all product features in bulk. By using this plugin, you can even add new products in bulk to your site and export data as CSV files.<\/p>\n\n\n\n

    This plugin has a great advanced filter form that supports all WooCommerce fields and meta fields, in addition, it has a very simple user interface designed to make bulk edit of products absolutely simple without needing any coding knowledge. <\/p>\n\n\n\n

    In this guide, we will show you how to use the WooCommerce products bulk editing plugin to change the sale price of simple and variable products.<\/p>\n\n\n\n

    Step #1: Install WooCommerce bulk editing products plugin <\/h3>\n\n\n\n

    In order to be able to use the features of the WooCommerce products bulk edit plugin, you must first download and <\/strong>install it<\/a><\/span> on your WordPress site.<\/p>\n\n\n\n

    \n
    \n
    \n

    PBULKiT – Bulk Edit WooCommerce Products<\/p>\n\n\n\n

    The easy The easy way to bulk edit product sale price in WooCommerceto update seasonal products in bulk<\/p>\n\n\n\n

    \n
    Buy Plugin<\/a><\/div>\n\n\n\n
    Free Version<\/a><\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n
    \n
    \"PBULKiT<\/figure>\n<\/div>\n<\/div>\n\n\n\n

    After activating the plugin, go to WordPress Dashboard > IT Bulk Editing > Woo Products<\/strong> to see the main page of the plugin.<\/p>\n\n\n\n

    \"select<\/a>
    Open PBULKiT plugin by iThemeland<\/figcaption><\/figure>\n\n\n\n

    All the products are displayed on this page in a table, and the tools needed for filtering and bulk editing are also designed in a toolbar above the table, which is very easy to access.<\/p>\n\n\n\n

    \"list<\/a>
    List of products in PBULKiT table<\/figcaption><\/figure>\n\n\n\n

    Let\u2019s review how these tools can help you to bulk edit product sale prices of WooCommerce seamlessly.<\/p>\n\n\n\n

    Step #2: Filter desired WooCommerce products <\/h3>\n\n\n\n

    The first tool that is really helpful in the process of bulk editing product sale prices in WooCommerce is Filter Form<\/strong>. By clicking on the Filter<\/strong> icon of the toolbar, the Filter Form<\/strong> is opened. As illustrated below, all WooCommerce fields and meta fields are divided into 8 categories in this form to help you find the product features more easily.<\/p>\n\n\n\n

    You can simply open one of the tabs in the form and set your desired filter, then press the Get Products<\/strong> button to filter the products in the table.<\/p>\n\n\n\n

    \"select<\/a>
    PBULKiT filter form<\/figcaption><\/figure>\n\n\n\n

    For example, if you want to change the sale price of simple products in bulk, try to:<\/p>\n\n\n\n