How to Bulk Edit Wholesale Prices in WooCommerce

Managing a successful B2B operation requires the ability to quickly adapt your pricing strategy to meet market demands. However, if you are handling a large catalog, trying to bulk edit wholesale prices in WooCommerce using the default product editor is an incredibly slow and manual process. Whether you need to update wholesale rates for a seasonal promotion or adjust your B2B pricing tiers due to rising costs, you need a way to perform bulk updates on wholesale customer prices without opening every product individually. In this guide, we will show you how to use a spreadsheet interface to filter your inventory and modify wholesale prices in bulk in just a few clicks, ensuring your professional buyers always see the most accurate and competitive rates.

How to Bulk Update Wholesale Pricing

For store owners using popular plugins like WooCommerce Wholesale Prices or WooCommerce Wholesale Pro, managing tiered B2B pricing across hundreds of SKUs is often a major bottleneck. These plugins add specific custom metadata fields to your products, but they don’t provide a native tool for inventory-wide pricing audits or batch modifications. This makes it difficult to execute bulk pricing changes across specific categories or attributes efficiently.

To streamline this workflow, we use WP Sheet Editor. This tool allows you to view your entire wholesale product catalog in a searchable spreadsheet, making it easy to batch update B2B discounts with the speed of an Excel file. You can target specific segments of your inventory and apply your new wholesale pricing strategy to your entire database quickly.

This method works perfectly for bulk updating prices for:

• WooCommerce Wholesale Prices: Add special rates for logged-in wholesale customers.
• WooCommerce Wholesale Pro: Manage wholesale areas, B2B roles, and registration discounts.

1. Install the WP Sheet Editor Plugin

The WooCommerce Products Spreadsheet plugin is the ultimate companion for wholesale inventory management. It automatically detects B2B price fields added by third-party plugins, allowing you to manage all wholesale customer rates directly from a central grid without the constant page reloading of the standard WordPress dashboard.

2. Open the WooCommerce Products Spreadsheet

After installation, navigate to WP Sheet Editor > Edit Products. You will see your entire product catalog displayed in an organized spreadsheet where every row is a product (or variation) and every column is a data field (like SKU, Regular Price, or Wholesale Price).

Crucial Tips for B2B Pricing Audits:

• Scan for Fields: If your wholesale columns aren’t visible, go to Settings > Scan DB to find fields. This ensures the plugin pulls all wholesale pricing metadata.
• Manage Columns: Use the Columns Manager on the toolbar to place your “Wholesale Price” column next to the “Regular Price” column for easier margin analysis.

3. Filter Products by Keyword, Category, or Attribute

Before applying bulk price modifications, you must isolate the items you want to update. You might want to apply a bulk wholesale discount only to a specific “Season” or items with a certain “Brand” attribute.

Open the Search tool with one click on the toolbar.

In the search tool, you can define your target product segment:

• Contains keyword: Search by product title.
• Product Categories/Attributes: Find products by specific category, tag, or variation.
• Click Run Search to see your filtered results.

In the example below, we filtered for the “Fashion” category. The spreadsheet now shows only the relevant products ready for bulk B2B rate changes.

4. (Optional) Edit Wholesale Prices Individually in the Grid

If you only need to adjust a few specific items, you can do so directly in the cells. It is as easy as editing an Excel file. You can enable the “Wholesale Customer Have Wholesale Price” checkbox and manually enter the new rate in the price column. Click Save on the toolbar once you are finished to push all updates to your live WooCommerce store.

5. Bulk Edit Wholesale Prices for All Filtered Products

To perform a bulk update of wholesale rates for every product found in your search, use the Bulk Edit tool. Since wholesale plugins typically require both enabling the feature and setting the value, we will perform a quick two-step process.

Step A: Bulk Enable Wholesale Pricing

First, we must activate the wholesale pricing option for all filtered results.

• Select the rows 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.

Step B: Batch Update Wholesale Prices

Now, apply the actual bulk discount or new price to the selected items.

• Select the rows 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 (or use “Decrease by percentage”).
• Replace existing value with this value: Enter your wholesale rate (e.g., 50).
• Select Edit only parent products.
• Click Execute Now.

Your products have now been successfully updated with the new B2B pricing structure. You can verify the changes in the spreadsheet grid.

WooCommerce B2B Inventory Management Made Easy

By using WP Sheet Editor, you’ve turned a time-consuming manual chore into an efficient 5-minute task. You can now bulk edit wholesale prices in WooCommerce with total precision, whether you are managing a few dozen items or a massive B2B inventory. This spreadsheet-based catalog management strategy helps you maintain accurate pricing, reduce human error, and gives you the agility to run your wholesale store more effectively.