Customer Price Lists: Managing Customer-Specific Prices

B2BKing customer price lists let you create negotiated prices for individual customers, without creating a separate customer group or dynamic rule for every product.

This feature is ideal for B2B stores where each customer has their own contract prices across many or all products. For example, you may have 200 customers, each with a different agreed price for the same catalog. Instead of managing hundreds of groups or thousands of fixed-price rules, you can manage each customer’s prices in one dedicated price list.

It is also flexible enough for smaller exceptions. A customer can use their regular group prices for most products, while individual customer prices are used only where that customer has a unique agreement.

With customer price lists, you can manage negotiated prices directly from the product page, from the customer profile, or in bulk with CSV import/export.

Where To Manage Customer Prices #

You can manage customer-specific prices from three places.

(1) Product Edit Page

When editing a product, go to the B2BKing pricing area and find Individual prices. Click Manage to add or edit prices for individual customers on that product.

This is useful when you are working product-by-product and want to quickly check which customers have special prices for a specific item.

(2) B2BKing Customers Page

Go to B2BKing → Customers, open a customer, and click the Pricing tab.

This view is focused on one customer. You can search products, add prices, edit prices, remove prices, save changes, and manage quantity tiers. This is the best place to manage a customer’s negotiated price list manually.

(3) Individual User Page

The same Pricing panel is also available on the customer’s WordPress user profile. This is useful if you are already editing the user account and want to quickly review or update their negotiated prices.

Regular Price, Sale Price, And Quantity Tiers #

For each customer and product, you can set:

• Regular price
• Sale price
• Quantity price tiers

The regular and sale prices work like WooCommerce product prices, but only for that customer.

Price tiers allow you to set quantity-based prices for that customer. For example:

Minimum quantity	Price
10	45
25	42
100	39

If you use B2BKing’s Enter % Instead of Prices setting for tiered pricing, the tiers field will use percentage discounts instead of direct prices.

Import And Export #

Customer Price Lists can be edited in bulk with CSV files through the standard WooCommerce product importer.

Go to a customer’s Pricing tab, either from B2BKing → Customers or from the individual user page. Click Import & Export.

You will see two options:

• Download CSV price list

Downloads a WooCommerce-compatible CSV for this customer.

The file includes all products and variations. If the customer already has negotiated prices or quantity tiers for a product, those values are already filled in. Products without negotiated prices are included with empty customer price fields, so you can add prices directly in the spreadsheet.

• Open Woo importer

Opens the WooCommerce product importer in a new tab.

After editing the CSV price list, upload it here. The file downloaded from B2BKing is already prepared for the WooCommerce importer: the columns are already named correctly, the customer price fields are already mapped, and Update existing products is enabled automatically.

In most cases, you only need to upload the CSV and continue through the WooCommerce import steps.

Recommended Import Workflow #

For most stores, this is the easiest way to create or update a customer price list:

1. Open the customer’s Pricing tab from B2BKing → Customers or the user profile.
2. Click Import & Export, then Download CSV price list.
3. Open the CSV in a spreadsheet editor and fill in or update the customer prices.
4. Save the file as CSV.
5. Click Open Woo importer, upload the edited file, and continue through the WooCommerce import steps.

After the import is complete, the customer’s negotiated prices will be available in B2BKing.

Advanced: CSV Metadata Structure #

The CSV downloaded by B2BKing already includes the correct columns for the selected customer. Most users do not need to create these columns manually.

For advanced imports, integrations, or custom CSV generation, customer prices are stored as product meta fields.

For user ID 123, the keys are:

• b2bking_regular_price_user_123

• b2bking_sale_price_user_123

• b2bking_product_pricetiers_user_123

In a WooCommerce CSV file, these should be imported as meta columns. The column headers can be:

• Meta: b2bking_regular_price_user_123

• Meta: b2bking_sale_price_user_123

• Meta: b2bking_product_pricetiers_user_123

Price Tiers Format

Customer-specific price tiers use this format:

quantity:price;quantity:price;

Example:

10:44;25:42;100:39;

This means:

Minimum quantity	Customer price
10	44
25	42
100	39

If your store uses percentage tiered pricing, the second value is treated as the percentage discount.

Example:

10:5;25:10;

This means:

Minimum quantity	Discount
10	5%
25	10%

User ID And Username Keys #

We recommend using user ID keys, because user IDs are stable and avoid issues if usernames change.

Recommended:

• b2bking_regular_price_user_123
• b2bking_sale_price_user_123

However, username-based keys are also supported:

• b2bking_regular_price_user_john
• b2bking_sale_price_user_john

Advanced: Importing Multiple Customer Price Lists #

You can import prices for multiple customers in the same WooCommerce CSV file.

To do this, add separate customer price columns for each user.

ID,SKU,Name,Meta: b2bking_regular_price_user_123,Meta: b2bking_sale_price_user_123,Meta: b2bking_regular_price_user_456,Meta: b2bking_sale_price_user_456
45,product-sku-1,Example Product,50,45,48,44
46,product-sku-2,Second Product,90,,85,80

In this example:

• User ID 123 gets prices from the user_123 columns.
• User ID 456 gets prices from the user_456 columns.