> For the complete documentation index, see [llms.txt](https://docs.samita.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.samita.io/samita-wholesale-b2b/wholesale-pricing/import-multiple-products-for-wholesale-pricing-setup.md).

# Import multiple products for Wholesale pricing setup

If you need to set wholesale prices for a large number of products, uploading a file is much faster than setting them up one by one in the app.

## Step 1: Prepare your file

Create a CSV or XLSX file with one row per product, using the columns described below. Every row that shares the same **Id** value belongs to the same wholesale pricing rule — so if you're setting up 5 products under one rule, give all 5 rows the same Id.

<details>

<summary>Full column reference</summary>

| Column | Field                         | Notes                                                                                                                                                                                             |
| ------ | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| A      | Id (Wholesale pricing ID)     | Rows sharing the same Id are grouped into one wholesale pricing rule.                                                                                                                             |
| B      | Name                          | Name of the wholesale pricing rule.                                                                                                                                                               |
| C      | Status                        |                                                                                                                                                                                                   |
| D      | Apply to Customers            | The customer condition type, e.g. `Customer tags`, `Logged in customers`, `Non-logged in customers`, or `All customers`.                                                                          |
| E      | Customer tags                 | e.g. `wholesale`                                                                                                                                                                                  |
| F      | Exclude Customer tags         |                                                                                                                                                                                                   |
| G      | Apply to Products             | The product condition, e.g. `Specific products`.                                                                                                                                                  |
| H      | Apply to Product variants     | Default column — enter `TRUE` to set pricing per variant.                                                                                                                                         |
| I      | Product Collection Ids        | Used when the product condition is "specific collection".                                                                                                                                         |
| J      | Product Ids                   | See below for how to find a product's ID.                                                                                                                                                         |
| K      | Product variant Id            | Enter this if you're setting pricing per variant. See below for how to find it.                                                                                                                   |
| L      | Product tag                   | Used when the product condition is "product tag", e.g. `tagA`.                                                                                                                                    |
| M      | Start date                    | When the wholesale pricing starts working.                                                                                                                                                        |
| N      | End date                      | When the wholesale pricing stops working.                                                                                                                                                         |
| O      | Discount group                | One of `Percent`, `Amount`, or `Fixed`.                                                                                                                                                           |
| P      | All (all customers condition) | Default column.                                                                                                                                                                                   |
| Q      | Customer condition type       | `all` for all customers, `logged` for logged-in customers, `non logged` for non-logged-in customers. For a customer tag condition, use the tag name itself as the column value, e.g. `wholesale`. |

**Finding a product ID:** go to the Products folder in Shopify, open the product, and check the page URL — the product ID is the number at the end of the link.

<figure><img src="/files/oWjConHkR5er2i0u68xL" alt=""><figcaption></figcaption></figure>

**Finding a variant ID:** open the product, go to the variant you need, and click into it. The variant ID is the number at the end of that page's URL.

<figure><img src="/files/TKtefTSx7pT9CLVB49B5" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/vWrxRk4aZFx3OodWBsci" alt=""><figcaption></figcaption></figure>

</details>

Once your file is ready, save it.

## Step 2: Upload the file to the app

{% stepper %}
{% step %}

### Open Wholesale Pricing

From the app **Dashboard**, click **Wholesale Pricing**.
{% endstep %}

{% step %}

### Click Import

<figure><img src="/files/DSS9ei8HvBlLnCISPujF" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Upload your file

You can also download the example file here to see exactly what data each column needs.

<figure><img src="/files/FQjZKVLUFPzIVnxpy7q7" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Preview and confirm

Review the file information, then click **Upload and preview**.

<figure><img src="/files/UhMiHVOfUZsiKggIb3oz" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

{% hint style="info" %}
If you run into any trouble during these steps, contact us any time at **<support@samita.io>**.
{% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.samita.io/samita-wholesale-b2b/wholesale-pricing/import-multiple-products-for-wholesale-pricing-setup.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.