> For the complete documentation index, see [llms.txt](https://docs.b2bridge.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.b2bridge.io/app-configuration/price-list/how-to-import-prices-via-.csv-file.md).
# How to import prices via .csv file
## Overview
Instead of adding products and prices one by one, you can import a Price List in bulk using a `.csv` or `.xlsx` file. This is the fastest way to set up B2B pricing for a large catalog.
{% hint style="info" %}
Bulk import is available on the **Growth plan** and above. See [Pricing plans](/policies.md) for details.
{% endhint %}
### Step 1. Start importing the file
Go to **Price List**, locate the **Import/Export** button and select **Import price list.**
You’ll see a screen like this:
* **Overwrite rules with matching IDs:** Suitable when you need to bulk update the previous price lists.
* **Replace all existing rules:** Suitable when yo that want an entirely new price list.
### Step 2: Understanding the File Structure
The file contains two sheets:
* `data_entry_guidelines` - Explains what kind of data should be entered in each cell.
* `data_input` - Where you actually input the prices.
Note:
* In `data_input`, we have implemented dropdown options that match the option in the app, so you don’t have to type it down in the file
### Common use cases
For example, there are 2 products with total of 5 SKUs
Let’s walk through some common examples.
#### Specific price for each SKU
For this, focus on two columns: `sku` and `b2b_price`.
Enter the SKU in the `sku` column, and the wholesale price in the `b2b_price` column
For column `volume_discount_apply_to` and `limit_apply_to`, you can set is to `-- None --`
#### Volume prices for each SKU
For this scenario, focus on columns:
* `sku` - the SKU of the **variant** to apply volume prices to
* `volume_discount_apply_to` - in this case, select "Customize for each variant"
* `volume_discount_break_type` - select either "Quantity" or "Amount", depends on what is used to calculate the discount value
* `volume_discount_break_value` - for each range, select a number of a quantity or amount break
* `discount_type` - for each range, select how you'd like to discount, can either be "Decrease a fixed amount", "Apply a new price", or "Percentage discount"
* `value` - select a number that corresponds `discount_type`
Example:\
If buying 10 units of SKU 13a gets you 10% off, and 20 units gets 20% off, input as follows:
{% hint style="info" %}
**Note**: for each row of volume pricing range, you need to enter the same SKU so our system can recognize that the volume pricing belongs to one SKU.
{% endhint %}
#### Volume prices for each product with many variant/SKU
If a product has multiple SKUs but you want volume pricing to apply across all of them:
In this case, choosing either SKU 13a or 14a will trigger volume pricing for both.
* `sku` - the SKU of the **product** to apply volume prices to
* `volume_discount_apply_to` - in this case, select "Each product"
* `volume_discount_break_type` - select either "Quantity" or "Amount", depends on what is used to calculate the discount value
* `volume_discount_break_value` - for each range, select a number of a quantity or amount break
* `discount_type` - for each range, select how you'd like to discount, can either be "Decrease a fixed amount", "Apply a new price", or "Percentage discount"
* `value` - select a number that corresponds `discount_type`
Example:\
If buying 10 units of the product gets you 10% off, and 20 units gets 20% off, input as follows:
#### Volume prices for entire order
This setting applies volume discounts across **all SKUs** listed in the file.
* `sku` - the SKU of the **product** to apply volume prices to
* `volume_discount_apply_to` - in this case, select "Total sum of order"
* `volume_discount_break_type` - select either "Quantity" or "Amount", depends on what is used to calculate the discount value
* `volume_discount_break_value` - for each range, select a number of a quantity or amount break
* `discount_type` - for each range, select how you'd like to discount, can either be "Decrease a fixed amount", "Apply a new price", or "Percentage discount"
* `value` - select a number that corresponds `discount_type`
#### MOQ/MOV for each SKU
You can define rules for each SKU. For example:
* SKU 13a requires a **minimum order of 10**, **maximum of 1000**, and must be ordered in **increments of 10**.
* `sku` - SKU of the **variant** to apply order rule to
* `limit_apply_to` - in this case, select "Customize for each variant"
* `limit_type` - select either "Quantity" or "Amount", depends on what is used to limit ordering
* `min` - mimimum purchasable number
* `max` - mimimum purchasable number
* `increment` - applies only when `limit_type` is "Quantity", select the purchasable increments of one SKU (e.g. qty in 3 6 9 12, etc.)
#### MOQ/MOV for each product with many variant/SKU
Similar to volume pricing for products with multiple SKUs. Use **one representative SKU**.
* `sku` - SKU of the **product** to apply order rule to
* `limit_apply_to` - in this case, select "Each product"
* `limit_type` - select either "Quantity" or "Amount", depends on what is used to limit ordering
* `min` - mimimum purchasable number
* `max` - mimimum purchasable number
#### MOQ/MOV for entire order
This applies the same order rules across all SKUs listed in the file.
* `sku` - SKU of all products to apply order rule to
* `limit_apply_to` - in this case, select "Each product"
* `limit_type` - select either "Quantity" or "Amount", depends on what is used to limit ordering
* `min` - mimimum purchasable number
* `max` - mimimum purchasable number
### Step 3: Upload and validate the file
#### Successful import:
You're all set! You can now use [Customer Group](broken://pages/JoJAwhZgkjvBNA9W9fHr) to assign the imported price list to specific wholesale customer groups.
#### If there are errors
If the file has invalid inputs, errors will be shown on screen.
* Please check the file, fix the issue, and re-upload.
* If the problem persists, contact us at or use the in-app chatbox.
### Export existing price list(s)
To export a price list:
* Select the price list(s) you want.
* Click Export to export the selected price list(s).
***
{% hint style="success" %}
### Need Help?
If you have questions or run into issues while using any feature, we're here to help.
* 💬 **Start a** [**Live Chat** with our support team](https://go.crisp.chat/chat/embed/?website_id=a59f354c-f51f-4f84-ae9a-c0e8dd69d2e5) directly from your B2Bridge dashboard.
* 📧 **Email us at** [**support@b2bridge.io**](mailto:support@b2bridge.io) and we'll get back to you as soon as possible.
{% endhint %}