How to Bulk Import / Export Product Prices

Looking for customer-specific prices?
This article covers group pricing imports. For prices assigned to individual customers, use Customer Price Lists.

Step-by-Step Import & Export #

B2BKing has a built-in tool that allows you to configure prices in bulk via CSV upload. Here's how to access and use it.

The first step is to go to B2BKing -> Tools -> Import / Export:

The second step is to click "Download." This will download a CSV list of prices. We recommend modifying the downloaded file directly—change the prices there, save your changes, and then re-upload the same file.

When you open the downloaded CSV file, you should see something like this:

In the first column, you can find the products. You can also enter IDs or SKUs directly. The next three columns contain regular, sale, and tiered pricing (regular values). Then, for each B2BKing group, you can find their pricing in the subsequent columns.

For regular and sale prices, you would enter normal numbers, but for tiered pricing, a special format is used: quantity:price;quantity:price;

For example, 10:70;20:60; means that if the user purchases at least 10 pieces, the price will be 70 per piece, and if the user purchases more than 20 pieces, the price will be 60 per piece.

The third step is to upload the CSV file you modified:

Video Demonstration #

Importing via Metadata #

While we are continuously working to improve the built-in tool, please note that B2BKing is not a dedicated import/export plugin. You may want to use dedicated plugins such as WP All Import / Export, which offer additional features and more powerful options for import processes.

To import with metadata, here are the meta keys that B2BKing uses:

For group pricing: https://b2bkingplugin.com/docs/release-1-8-0-price-lists-csv-import-export-pricing-in-the-product-page/

For tiered pricing: https://b2bkingplugin.com/docs/b2bking-tiered-pricing-setup-auto-generated-tiered-pricing-table/

New: WooCommerce Importer Integration #

B2BKing's price importer may struggle when importing more than 1,000 products, so we have added a new integration with WooCommerce's own import tool, which can handle much larger numbers.

B2BKing now fully integrates with WooCommerce's own import/export solution. To use it, follow these steps:

• Go to the Products page in the backend.
• Click on Import.

• Select a file. If you are setting prices for already existing products (rather than importing new products), you must check the "Update existing products" checkbox. Then click Continue.

• Now you can match each column to B2C price tiers or to a B2B group's regular price, sale price, or price tiers. To import tiered prices, you must use the same format as described earlier in this article.