> For the complete documentation index, see [llms.txt](https://docs.yaycommerce.com/yaypricing/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.yaycommerce.com/yaypricing/features/export-import-bulk-tiered-pricing-range-data.md).

# Export/Import Bulk/Tiered Pricing Range Data

### Step 1: Prepare Your Bulk Pricing Range Data in CSV File Format

Before importing, you need to have your pricing data organized in a CSV (Comma-Separated Values) file. The CSV file should include the following columns:

* **Min** **quantity**: the minimum number of units a customer must purchase to qualify for a particular pricing tier. This is the starting point of a quantity range.
* **Max** **quantity**: indicates the maximum number of units that fall within a specific pricing tier. This is the endpoint of a quantity range.
* **Discount** **type**: YayPricing supports **Fixed Discount**, **Percentage** **Discount** and **Flat** **Price.**
* **Discount** **value**: is the numerical value associated with the discount type. It represents the amount or percentage to be deducted from the regular price.
* **Maximum** **discount** **value**: sets an upper limit on the total discount that can be applied, ensuring that discounts do not exceed a certain amount.

There are various tools you can use to export CSV files, including online tools, office software, and programming languages such as **Microsoft** **Excel**, **Google** **Sheets**, **LibreOffice** **Calc**, **Apple** **Numbers**, etc.

Here’s the example for a CSV file:

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

Now, your CSV file is ready to use!

### Step 2: Access YayPricing Plugin

Log in to your **WordPress dashboard > YayCommerce > YayPricing**

In the **Product** **Pricing** tab, click ‘**Add** **Your** **First Rule**’ button or ‘**Add** **Rule**' button to create a new rule for your promotional campaign.&#x20;

<figure><img src="/files/1iYSF9bEPwNftorFWknT" alt=""><figcaption></figcaption></figure>

### Step 3: Import Bulk Pricing Ranges

Here, In the **Name** field, you can enter a descriptive name for your pricing rule (optional).

About **Rule** **types** dropdown menus, select **Bulk** **Pricing**.

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

In the **Pricing** section, YayPricing facilitates the import of bulk pricing range data, significantly saving time and minimizing manual effort for users.

1. Clicking on **Choose** **file**.
2. Uploading the CSV file.
3. And then, hitting the **Import** button.

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

Once the file is uploaded, you will be prompted to map the columns from your CSV file to the corresponding fields in YayPricing.&#x20;

After mapping, YayPricing will process the data and apply the bulk pricing ranges to your products accordingly.

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

Happy import-ing! 🤩


---

# 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.yaycommerce.com/yaypricing/features/export-import-bulk-tiered-pricing-range-data.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.