This guide shows how to bulk edit wholesale prices in WooCommerce using the WP Sheet Editor plugin. It covers how to update custom B2B pricing fields generated by plugins like WooCommerce Wholesale Prices and WooCommerce Wholesale Pro across simple products and variations. Store owners will learn how to scan custom database metadata, filter products by category or attribute, and apply flat-rate or percentage-based wholesale discounts across thousands of SKUs in a few clicks.
To bulk update B2B pricing in WooCommerce without manually opening individual products, use WP Sheet Editor to manage custom database fields. Here is an overview of the workflow:
- Detect B2B Fields: Use the spreadsheet database scanner to display custom metadata fields like
Wholesale PriceandWholesale Customer Have Wholesale Price. - Filter Catalog: Isolate specific categories, attributes, or keywords using advanced search filters.
- Enable B2B Pricing: Run a bulk edit to set the wholesale toggle status to “Yes” across filtered rows.
- Batch Update Prices: Apply fixed dollar values or percentage reductions to wholesale price fields across parent products or variations.
Managing a B2B store requires adapting pricing structures to meet changing supplier costs and buyer agreements. Updating wholesale prices in WooCommerce using the default product editor requires opening each product or variation individually, which becomes unmanageable as catalog size grows. This guide explains how to use a spreadsheet interface to filter inventory and bulk update wholesale rates across your database.
1. Install the WP Sheet Editor Plugin
The WooCommerce Products Spreadsheet plugin connects directly to your WordPress database. It automatically scans for custom B2B pricing metadata registered by third-party wholesale plugins, allowing you to edit wholesale customer rates alongside standard catalog fields like regular price, SKU, and stock status.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features
2. Open the WooCommerce Products Spreadsheet
Navigate to WP Sheet Editor > Edit Products to launch the spreadsheet interface. Every row represents a product or variation, and every column represents a database field.
Configuration steps for B2B metadata:
- Scan Database Fields: Go to Settings > Scan DB to find fields if your wholesale pricing columns are not visible automatically. The tool indexes all custom metadata keys stored in the
wp_postmetatable. - Organize Columns: Open the Columns Manager on the top toolbar to drag the
Wholesale Pricecolumn next to theRegular Pricecolumn for side-by-side margin comparison.
3. Filter Products by Keyword, Category, or Attribute
Isolate the specific items you want to edit before executing a batch update. For example, you can target a seasonal collection, specific product tag, or brand attribute.
Click Search on the top toolbar to open the search parameters window.
Specify your search parameters:
- Contains keyword: Filters items matching specific text in the product title.
- Product Categories/Attributes: Filters by categories, tags, shipping classes, or custom product attributes.
- Click Run Search to load the matching products into the spreadsheet.
The spreadsheet refreshes to display only the filtered selection.
4. Edit Wholesale Prices Individually in the Spreadsheet
To modify pricing for a small number of SKUs, enter values directly into the spreadsheet cells. Enable the Wholesale Customer Have Wholesale Price checkbox column and type the numerical rate into the Wholesale Customer Wholesale Price column. Click Save on the toolbar to update the database.
5. Bulk Edit Wholesale Prices for All Filtered Products
To update wholesale pricing across all filtered items at once, open the Bulk Edit tool. WooCommerce wholesale plugins require two steps: enabling the wholesale status for the item, then setting the price value.
Step A: Bulk Enable Wholesale Pricing
Set the wholesale activation toggle to “Yes” across all targeted rows:
- 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.
- Apply to: Select Edit only parent products or Edit only variations based on your store setup.
- Click Execute Now.
Step B: Batch Update Wholesale Prices
Apply the numerical wholesale rate or percentage discount to the filtered 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: Select Set value for a flat rate, or Copy regular price and decrease by percentage to calculate a percentage discount off regular retail pricing.
- Replace existing value with this value: Enter the numerical value (for example,
50for a $50 price point or20for a 20% reduction). - Apply to: Select Edit only parent products or Edit only variations.
- Click Execute Now.
The updated wholesale rates will appear in the spreadsheet immediately after execution.
Frequently Asked Questions
Does WP Sheet Editor work with custom wholesale user roles?
Yes. Plugins like WooCommerce Wholesale Prices Premium or WooCommerce Wholesale Pro generate separate database fields for each custom B2B user role (e.g., Wholesale Customer, VIP Tier, Distributor). WP Sheet Editor detects each role’s custom field so you can bulk edit rates independently per role.
Can I bulk update wholesale prices on product variations?
Yes. Set the dropdown in the Bulk Edit tool to Edit only variations. This applies the wholesale pricing changes exclusively to individual variation rows without altering parent product rows.
What should I do if my wholesale price columns do not appear in the spreadsheet?
Navigate to Settings > Scan DB to find fields inside the WP Sheet Editor menu. This prompts the plugin to re-index the database for metadata keys added by your wholesale plugin.
You can download the plugin here:
Download WooCommerce Products Spreadsheet Plugin - or - Check the features