How to Bulk Import / Export Product Prices

Looking for customer-specific prices?
This article covers importing group prices. To set prices for individual customers, use Customer Price Lists.

Choose an Import Method #

B2BKing offers two ways to update product prices in bulk. Both are available under B2BKing → Tools → Import / Export Tool:

• Regular importer: the simplest option for most stores. Download the price list, edit it, and upload it again on the same page.
• Batch importer: use this if the regular import times out or doesn't finish. It processes the file in smaller batches, which makes the import more reliable.

Each method uses its own CSV format, so always download the price list from the method you plan to use.

Regular Importer: Step-by-Step #

Step 1: Go to B2BKing → Tools → Import / Export Tool.

Step 2: Click Download price list. Open the file, update the prices you want to change, and save it as a CSV file. Everything else (product identifiers, column headers, and column order) should stay as it is.

When you open the downloaded file, it will look similar to this:

The first column identifies each product or variation, so you'll usually leave it as it is. The next three columns hold the B2C regular price, sale price, and tiered price. After that, each B2BKing group has its own set of regular price, sale price, and tiered price columns.

Regular and sale prices are plain numbers. Tiered prices use the format quantity:price;quantity:price;.

For example, 10:70;20:60; means the price is 70 per item when buying 10 or more, and 60 per item when buying 20 or more.

Step 3: Go back to the B2BKing Tools page, select your edited CSV file, and click Import prices.

Important: the importer applies every value in the file, including empty price cells. An empty cell clears that price, so leave existing values in place unless you want to remove them.

Batch Importer: Step-by-Step #

If the regular importer times out or doesn't finish, switch to the batch importer on the same B2BKing Tools page.

1. Go to B2BKing → Tools → Import / Export Tool and click Use batch importer.
2. Click Download price list for batch importer. This file is formatted specifically for the batch importer, so don't reuse a file downloaded from the regular importer.
3. Edit the price columns, leaving the ID column unchanged. The Product Reference column is there to help you recognize each product or variation.
4. Go back to the batch importer panel and click Continue to batch importer.
5. Upload your edited CSV file. When you open the batch importer from B2BKing Tools, Update existing products is already selected for you; leave it enabled. Any rows that don't match an existing ID or SKU are skipped.

6. Click Continue. On the column mapping screen, check that the ID, the B2C prices, and each B2B group's regular, sale, and tiered price columns are mapped correctly. Files downloaded from the batch importer are set up to map automatically.
7. Scroll to the bottom of the page, click Run the importer, and wait for the confirmation that the import is complete.

Tips & Troubleshooting #

• The import times out or doesn't finish: use the batch importer described above.
• Your spreadsheet app asks which CSV format to use: if you're saving from Excel or a similar app and see several CSV options, choose CSV (Comma delimited). Avoid semicolon-separated formats, since tiered prices already use semicolons.

Video Demonstration #

The video below walks through the regular download, edit, and upload process. The current interface also includes the batch importer described above.

Importing via Metadata #

B2BKing's built-in tools are designed for straightforward price updates. For more complex import processes, you may prefer a dedicated tool such as WP All Import / Export.

For details on B2BKing's pricing meta keys, see:

• Group pricing: Group Price Lists & Pricing for Each B2B Group
• Tiered pricing: Tiered Pricing & Tiered Pricing Table