# 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](/v2.2026/policies.md) for details.
{% endhint %}

## 1. Download the sample file

Before importing, download the sample template to make sure your file is in the correct format.

1. Go to **Price Lists** in the sidebar.
2. Click **Import price list**.
3. In the import modal, click **Download sample XLSX template**.
4. Open the file and review the column structure.

The sample file contains the following key columns:

| Column           | Description                                                       |
| ---------------- | ----------------------------------------------------------------- |
| `sku`            | The product variant SKU (required)                                |
| `b2b_price`      | The fixed B2B price for this variant                              |
| `discount_type`  | `percentage`, `fixed_amount`, or `new_price`                      |
| `discount_value` | The discount value (e.g. `10` for 10%)                            |
| `min_qty`        | Minimum order quantity                                            |
| `max_qty`        | Maximum order quantity                                            |
| `increment`      | Order increment (e.g. `5` means orders must be in multiples of 5) |

## 2. Prepare your import file

Fill in your pricing data in the template. A few important rules:

* Every row must have a valid `sku` that exists in your Shopify store.
* You can mix `b2b_price` and `discount_type`/`discount_value` columns — B2Bridge will use whichever is filled in.
* Leave a column blank to use the Price List's overall settings for that product.

## 3. Choose an import option

In the import modal, select how you want to handle existing pricing data:

* **Add new products only** — import only SKUs that don't already exist in the Price List
* **Update existing products** — update prices for SKUs already in the list, leave new ones untouched
* **Replace all** — overwrite the entire product list with the imported file

## 4. Upload and confirm

1. Click **Choose file** and select your `.csv` or `.xlsx` file (max 10 MB).
2. Select your import option.
3. Click **Save**.

B2Bridge will process the file in the background. A progress banner appears at the top of the Price Lists page while the import is running.

When the import finishes, a success banner confirms how many products were imported. If any rows failed validation, an error summary lists the affected SKUs.

***

{% 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 %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.b2bridge.io/v2.2026/app-configuration/price-list/how-to-import-prices-via-.csv-file.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.