WooCommerce Price Lists by Group: Complete Guide (2026)

▶️ Target

In this guide, you’ll learn step by step how to set up dedicated product pricing for specific customer groups—quickly and effortlessly. This is a very must have features for a successful WooCommerce B2B store. Discover how to create irresistible special offers tailored to your audience and manage pricing strategies with precision.

Whether you’re handling a small shop or a large catalog with hundreds or thousands of products, this powerful plugin lets you update everything in just a few clicks—saving you time, reducing manual work, and boosting your efficiency.

▶️ Introduction

One of the most powerful and highly appreciated features of DWH B2Bify is the ability to offer dynamic pricing based on customer groups. By leveraging advanced group management, you can easily segment your customers and create tailored pricing strategies that match your business goals.

Assign exclusive prices to each group, personalize offers, and maximize conversions by delivering exactly what your customers expect. Every product in your store can have multiple price variations—one for each group—giving you full control over your pricing structure.

But how can you efficiently manage such a flexible and scalable WooCommerce B2B system without wasting time?

▶️ Step 1: A Practical Example

Let’s look at a real-world scenario to clearly understand how group-specific pricing can transform your store.

Imagine you have a customer group called “Premium partners” and a product named “Hat” with a standard price of $50. Now, you want to reward your premium partners with an exclusive discounted price of $40—without affecting what other customers see.

With group-based pricing, this process is incredibly simple and fully automated.

Regular visitors to your store will continue to see the “Hat” priced at $50. However, as soon as a logged-in customer from the “Premium partners” group accesses the product page, the price is instantly updated to $40—no extra steps required.

This seamless experience not only enhances customer satisfaction but also allows you to implement targeted pricing strategies effortlessly, increasing conversions and loyalty at the same time.

▶️ Step 2: Enable Group Pricing

Now that you’ve created your “Premium partners” group, it’s time to unlock the full potential of group-specific pricing.

To assign custom prices for products like your “Hat”, you simply need to go in the product edit page

Products → All Products → Edit (select the product you want to configure)

Scroll down to the “Product data” section and locate the “Group Premium partners settings” panel provided by DWH B2Bify.

This is where the real magic happens.

From here, you can assign a dedicated regular price for the “Premium partners” group—$40 in our example—and even set a specific sale price if needed. In just a few clicks, you’ve created a fully customized pricing rule for a specific customer segment.

Managing product price lists by group in WooCommerce has never been this simple, flexible, and efficient.

Easy, right?

You might be wondering: what happens to all the other products where you haven’t set a dedicated price for the “Resellers” group?

No worries—everything is handled automatically.

DWH B2Bify intelligently detects when a group-specific price is not defined and seamlessly falls back to the default WooCommerce price. In our example, that means the product will simply display the standard $50 price.

This smart fallback system ensures your catalog always remains consistent and complete, without requiring you to manually configure every single product—saving you time while keeping your pricing strategy flexible and scalable.

▶️ Step 3: Bulk Update Made Easy

Sounds powerful, right? With group-based pricing, you can fine-tune your offers, deliver personalized experiences, and boost both customer loyalty and revenue.

But here’s the real question: what if your store has hundreds—or even thousands—of products? Do you really have to update each one manually when prices change or when you create a new customer group?

Absolutely not.

DWH B2Bify seamlessly integrates with WooCommerce’s built-in import/export tools, giving you a fast and efficient way to manage your entire catalog in bulk. Using simple CSV files, you can update thousands of products, assign group-specific prices, or create new pricing rules in just a few clicks.

To access this feature, go to:

Products → All Products

You’ll find the import/export options conveniently located next to the “Add New” product button.

This means less manual work, fewer errors, and a scalable solution designed to grow with your business.

Create Your CSV File

To efficiently update existing products—or add new ones—you’ll need to work with a CSV file containing your product data.

Start by exporting your current catalog. Simply go to:

Products → All Products → Export

Follow the export wizard and select only the fields you actually need. One essential field you must include is the “ID”, as it acts as a unique identifier that allows WooCommerce to correctly match each product during the update process.

Since the goal of this guide is to manage group-specific pricing, make sure to include the pricing fields related to your target group—in this case, “Premium partners.” These fields will appear as:

• Regular price (Premium partners)
• Sale price (Premium partners)

💡 Pro tip
Use the search bar in the “Which columns should be exported?” section and type your group name (e.g., “Premium partners”). This will instantly display all the relevant fields, saving you time and avoiding mistakes.

Once your CSV file is downloaded, open it using your preferred spreadsheet editor, such as Excel, Google Sheets, or LibreOffice. Here, you can easily filter products, apply calculations, and most importantly, update your group-specific prices in bulk.

When you’re done editing, save the file carefully, ensuring it’s encoded in UTF-8 format to prevent any import issues.

With this method, managing complex pricing rules becomes fast, accurate, and incredibly scalable.

Import Your CSV and Update Everything in One Click

Now it’s time to apply your changes.

Go to:

Products → All Products → Import

Click on “Choose file” and upload the CSV file you’ve just edited.

⚠️ Important:
Before proceeding, make sure to enable the “Update existing products” option—this step is crucial to ensure WooCommerce updates your current products instead of creating duplicates.

Continue through the import wizard, confirm your settings, and start the process. In just a few moments, WooCommerce will automatically process your file and apply all the updates.

That’s it—done.

Every product included in your CSV file will be updated simultaneously, including all group-specific prices. No manual edits, no wasted time—just a fast, reliable way to manage your entire catalog at scale.

Bonus: Apply Percentage Discounts by Category

While DWH B2Bify doesn’t natively allow applying group-specific prices or discounts by category—mainly to avoid conflicts when products belong to multiple categories—there’s an easy workaround.

Using WooCommerce’s import/export tools, you can export all products and filter them by category. Then, in your spreadsheet editor, create a simple formula to calculate the final price: start from the default price and apply your desired percentage discount for the group.

This method lets you generate accurate group-specific prices for entire categories without any risk of conflicting rules, giving you full control over your promotions and making bulk updates fast and reliable.

It’s a smart way to combine flexibility, efficiency, and precision—perfect for scaling your pricing strategy across your entire store.

▶️ Further Information

To get more familiar with WooCommerce’s import/export tools and make the most of bulk product updates, check out the official documentation—it’s packed with detailed instructions and helpful examples:

If you want to dive deeper into working with formulas, calculations, or percentage-based pricing in spreadsheets like Excel, Google Sheets, or LibreOffice, this guide is a great resource:

With these tools, you can master both bulk product management and precise price adjustments—empowering you to implement group-specific pricing strategies efficiently and accurately.