How to Bulk Import / Export Product Prices

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 going to B2BKing -> Tools -> Import / Export:

The second step is to click on "Download". This will download a CSV list of prices. We recommend that you modify the downloaded file directly, change prices there, save changes, and then reupload the same file.

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

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

For regular and sale price you would normal numbers, but for tiered pricing there's a special format that 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 working to make the tool as good as possible, 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 have additional features and more powerful options when it comes to import processes.

To import with metadata, here you can find the meta keys B2BKing uses:

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

For tiered pricing: https://woocommerce-b2b-plugin.com/docs/b2bking-tiered-pricing-setup-auto-generated-tiered-pricing-table/

Powered by BetterDocs