How to Bulk Edit Wholesale Prices in WooCommerce

In this post, we show you how to bulk edit wholesale prices in WooCommerce.

You’ll be able to bulk update wholesale prices for these plugins:

• WooCommerce Wholesale Prices – It helps you add special price to your products for your WooCommerce wholesale customers. Only logged-in wholesale customers will see these wholesale prices.
• WooCommerce Wholesale Pro – This plugin allows you to add wholesale to your public WooCommerce store. It creates a hidden area for your wholesale customers. WooCommerce Wholesale Pro adds wholesale registration, roles, B2B discounts and quick order forms to your WooCommerce store.

 

In this example, we’ll use the WooCommerce Wholesale Prices plugin.

If you want to add wholesale prices to 500 products, you’ll have to spend a lot of time because you will have to open and edit the products individually. That’s why we’ll show you how to bulk update wholesale prices in WooCommerce.

You’ll be able to bulk edit wholesale products using an intuitive spreadsheet inside WordPress. We’re talking about the WooCommerce Products Spreadsheet plugin by WP Sheet Editor.

With this plugin, you’ll be able to:

• Add wholesale price to products containing a specific keyword.
• Set wholesale price to all products within a specific category.
• Add wholesale price to all products containing a specific attribute or tag.

Just follow these simple steps to bulk edit wholesale products:

1- Install the “WP Sheet Editor” plugin

2- Open the WooCommerce products spreadsheet

If you don’t know how to set up the products spreadsheet, follow this quick guide.

Once installed and activated, the plugin will show you all WooCommerce products in a spreadsheet. This is in complete contrast to the normal editor because you can view and edit hundreds of products at once without having to open and edit them one by one.

To open the products spreadsheet, go to WP Sheet Editor > Edit Products.

Once there, you’ll see all your products; every row is a product and every column is a field. You can see the wholesale price fields.

Important

• If the fields added by WooCommerce Wholesale Prices don’t appear in the spreadsheet, hover over Settings and click Scan DB to find fields.
• You can sort the columns as you wish using the Columns Manager that is on the top toolbar. As you see, we’ve sorted the columns so the Regular Price column and the wholesale columns appear together.

3- Filter your WooCommerce products by keyword, category, attribute, or tag

With WP Sheet Editor, you can easily filter your products by keyword, category, attribute, tag, etc. You can also combine these search terms; for example, find all Black Shirts (attribute and keyword in title).

Open the Search tool with one click.

Once you open the Search tool, you’ll see the following search filters:

• Contains keyword – You can enter any keyword and the plugin will filter all products containing it in the title.
• Enter Product type, Product visibility, Product categories, Product tags, Product shipping classes, or Product attributes – This field works with all these filters. You can enter several terms combined.
• Once you enter the search filters you want to use, click Run Search.

In this example, we’ve searched for all products within the Fashion category. You can see they’ve been displayed in the spreadsheet, and the search filters are displayed above the spreadsheet as well.

4- (Optional) Edit the wholesale prices individually in the spreadsheet

Important: You can skip this step.

You can easily edit the wholesale prices individually using the spreadsheet. It’s as simple as editing an Excel document.

1. Enable/disable the Wholesale Customer Have Wholesale Price option
2. Add/remove the wholesale price in the Wholesale Customer Wholesale Price column.
3. Click Save to apply the changes.

5- Bulk edit wholesale prices for all the filtered WooCommerce products

If you want to set the same wholesale price for all the filtered products, you can easily do it.

Just open the Bulk Edit tool with one click. This tool allows you to bulk edit any field of your WooCommerce products, and in this case, it’ll help you bulk edit wholesale prices for all the selected products.

Once you open the Bulk Edit tool, you need to apply two bulk changes because the WooCommerce Wholesale Prices plugin creates the verification checkbox and the price field.

Select these values to enable the Wholesale Customer Have Wholesale Price option.

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Wholesale Customer Have Wholesale Price
• Select type of edit: Set value
• Replace existing value with this value: Yes
• Select Edit only parent products.
• Click Execute Now.

After that, select these values to bulk set wholesale price for all the selected products:

• Select the rows that you want to update: Edit all the rows from my current search
• What field do you want to edit: Wholesale Customer Wholesale Price
• Select type of edit: Set value
• Replace existing value with this value: 50, for example. Enter your own wholesale price.
• Select Edit only parent products.
• Click Execute Now.

As you see, our products have been edited successfully.

A piece of cake!

Bulk enabling and updating wholesale prices is really easy with WP Sheet Editor. You don’t have to open and edit your products one by one.

Instead, you can edit hundreds of products using the spreadsheet, or you can bulk edit wholesale prices for hundreds of filtered products.