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