> 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/volume-pricing/import-multiple-products-for-volume-pricing-setup.md).
# Import multiple products for Volume pricing setup
If you need to set volume 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 volume pricing rule — so if you're setting up 10 products under one rule, give all 10 rows the same Id.
Full column reference
| Column | Field | Notes |
| ------ | ----------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| A | Id (Volume pricing ID) | Rows sharing the same Id are grouped into one volume pricing rule. |
| B | Name | Name of the volume pricing rule. |
| C | Type | Volume pricing type: `quantity` or `amount`. |
| D | Status | |
| E | Apply to Customers | The customer condition type, e.g. `Customer tags`, `Logged in customers`, `Non-logged in customers`, or `All customers`. |
| F | Customer tags | Name of the customer tag. |
| G | Exclude Customer tags | |
| H | Apply to Products | The product condition, e.g. `All products`. |
| I | Apply to Product variants | Enter `TRUE`. |
| J | Product Collection Ids | Used when the product condition is "specific collection". |
| K | Product Ids | See below for how to find a product's ID. |
| L | Product variant Id | Enter this if you're setting pricing per variant. See below for how to find it. |
| M | Product tag | Used when the product condition is "product tag". |
| N | Start date | When the volume pricing starts working. |
| O | End date | When the volume pricing stops working. |
| P | Discount type | `variant` (Same Variant), `accross_group` (Mix Variants), or `within_each_group` (Mix Products). See [Discount Methods for Volume Pricing](/samita-wholesale-b2b/volume-pricing/discount-methods-for-volume-pricing.md). |
| Q | Discount group | One of `Percent`, `Amount`, or `Fixed`. |
| R | From Qty/Amount | The lower threshold of the price break, e.g. `10` for "buy 10 to 20 units, get 10% off". |
| S | To Qty/Amount | The upper threshold of the price break, e.g. `20` for the same example. |
| T | All (all customers condition) | Default column. |
| U | 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.
**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.
**Discount type reference:**
Once your file is ready, save it.
## Step 2: Upload the file to the app
{% stepper %}
{% step %}
### Open Volume Pricing
From the app **Dashboard**, click **Volume Pricing**.
{% endstep %}
{% step %}
### Click Import
{% endstep %}
{% step %}
### Upload your file
You can also download the example file here to see exactly what data each column needs.
{% endstep %}
{% step %}
### Preview and confirm
Review the file information, then click **Upload and preview**.
{% endstep %}
{% endstepper %}
> ### **Need support?**
>
> If you do encounter any difficulty while proceeding these steps, don’t show any hesitation to contact us promptly via the email address [support@samita.io](https://help.samita.io/support@samita.io)
---
# 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/volume-pricing/import-multiple-products-for-volume-pricing-setup.md?ask=&goal=
```
`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.