Bulk Edit WooCommerce Prices: Complete Guide for B2B (2026)

▶️ Target

In this guide, you’ll learn how to apply custom WooCommerce price lists and bulk pricing for each customer group across your entire product catalog—quickly and in bulk.

Using simple CSV files and WooCommerce import/export tools, you can update hundreds or even thousands of products in just a few clicks. Discover how to streamline your pricing strategy, automate complex rules, and manage group-based pricing with ease—saving time while maximizing efficiency and control to build a successful WooCommerce B2B store.

▶️ Introduction

With DWH B2Bify, you can create fully customized price lists for every product based on specific customer groups—giving you complete control over your B2B pricing strategy.

But when your store includes dozens or even hundreds of products, updating prices manually quickly becomes a time-consuming and error-prone task. Whether you need to adjust prices due to rising supply costs, realign your pricing strategy, or launch seasonal promotions for a specific category, managing everything from the standard WooCommerce product panel is simply not efficient.

That’s where the real power comes in.

WooCommerce’s native import/export tools allow you to handle bulk operations quickly and safely using simple CSV files, fully compatible with tools like Excel or Google Sheets. Combined with DWH B2Bify, this creates a seamless workflow for managing even the most complex pricing structures.

In this guide, you’ll learn how to export your products, automatically update prices, and reimport the modified data—without losing any information and in just a few clicks.

For this example, we’ll focus on updating prices for a customer group called “Partners.”

Keep in mind: for every group you create, DWH B2Bify automatically generates dedicated fields in the import/export system, such as:

• Regular price (GROUP NAME)
• Sale price (GROUP NAME)

These fields are the key to efficiently managing group-specific pricing at scale.

▶️ Step 1: Export Products from WooCommerce

To start managing your price lists in bulk, the first step is to export your existing products into a CSV file.

Go to your WordPress Dashboard in

Products → All Products

then click on the “Export” button at the top of the page.

In the export settings, you can choose to include all product data or select only the fields you actually need. For this specific task, it’s recommended to keep things simple and include only essential columns such as:

• ID
• Name
• Regular price (Partners)
• Sale price (Partners)
• Categories

Once you’re ready, click “Generate CSV” and WooCommerce will automatically download a file containing all the selected product data.

💡 Pro tip
If your goal is only to update prices, exporting just the necessary columns will make your CSV file lighter, easier to edit, and much faster to process—especially when working with large product catalogs.

▶️ Step 2: Edit Prices with Excel or Google Sheets

Once you’ve exported your CSV file, open it using Excel or upload it to Google Sheets. You’ll immediately see a structured table with all your products and their associated data—ready to be edited.

At this point, you can either manually adjust prices in the “Regular price (Partners)” or “Sale price (Partners)” columns, or take things to the next level by using formulas to automate bulk changes.

Example: Apply a 10% Discount to a Specific Category

If your file includes a “Categories” column, you can quickly target specific products. For example, let’s say you want to apply a discount to items in the “Accessories” category:

• Enable filters from the menu (Data → Filter)
• Filter the “Categories” column by “Accessories”
• In the “Regular price (Partners)” column, enter a formula like:
  =A2*0.9 (assuming the original price is in cell A2)
• Drag and copy the formula across all filtered rows to instantly apply the discount

Once your updates are complete, make sure to convert all formulas into static values (copy → paste as values). This step is essential to ensure your CSV file contains only final numbers, avoiding errors during the import process.

With this method, you can transform hours of manual work into a fast, precise, and fully scalable pricing update process.

▶️ Step 3: Reimport Updated Products into WooCommerce

Now it’s time to apply all your changes and update your store in bulk.

Go back to

Products → All Products

and click on “Import.” Upload the CSV file you’ve just edited.

During the import process, pay close attention to the Field Mapping step:

• Ensure the “ID” field is correctly mapped—this is essential for WooCommerce to recognize and update existing products instead of creating duplicates
• Verify that “Regular price (Partners)” and “Sale price (Partners)” are properly linked to their corresponding fields

Before starting the import, don’t forget to enable the “Update Existing Products” option.

Click “Run Import” and let WooCommerce handle the rest.

In just a few moments, all products included in your CSV file will be automatically updated based on their IDs—no manual edits required.

While this example focuses on updating prices for a specific group, the same process can be applied to virtually any field. This means you can fully manage and automate advanced DWH B2Bify features at scale, including:

• Dedicated group pricing
• Price display (show/hide prices) per group
• Bulk prices per group
• Stock display per group
• Minimum and maximum quantities per group
• Multiple quantity per group
• Product visibility

With this approach, you’re not just updating prices—you’re unlocking a powerful, scalable system to manage every aspect of your B2B store efficiently and with total control.

▶️ Step 4: An In-Depth Look at Tier Prices

Tier pricing is a powerful feature that allows you to offer progressive discounts based on purchase quantities—perfect for WooCommerce B2B strategies and bulk sales.

In DWH B2Bify, bulk prices follow a simple but specific format within the CSV file. Each tier is defined by a quantity–price pair, separated by a colon (:) and multiple rules are separated by a pipe (|).

Here’s a practical example:

10:190|20:180

This means:

• Up to 10 units → price is 190
• Up to 20 units → price is 180
• And so on, depending on how many tiers you define

You can add as many tiers as needed, giving you complete flexibility to build advanced pricing structures tailored to your customer groups.

This format makes it easy to manage even complex tiered pricing directly from your CSV file—ideal when working with large product catalogs and multiple pricing strategies.

For a deeper understanding and additional examples, you can also refer to the official WooCommerce documentation, which provides detailed guidance on how to structure and manage product data effectively: