> 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

How to migrate from other WooCommerce plugins

### 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="https://2582339638-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FagGARFBou99u1ioIn7vL%2Fuploads%2FhXnZwgGOUllj4YYcl6A9%2Fimage3.png?alt=media&amp;token=4268e046-0522-4eff-a4e4-cc58cb659709" 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="https://2582339638-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FagGARFBou99u1ioIn7vL%2Fuploads%2Fk2L8t06SK2djt5k52aFE%2Fimage4.png?alt=media&amp;token=6e464e9c-c6f2-4f6c-8b7e-928fc011b5ee" 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="https://2582339638-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FagGARFBou99u1ioIn7vL%2Fuploads%2FztA5CxsHzwP3MaG4S3Gp%2Fimage1.png?alt=media&amp;token=d9b80c42-12bf-4d8b-81a6-19b45a687823" 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="https://2582339638-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FagGARFBou99u1ioIn7vL%2Fuploads%2F3C3pKPDQb8BHj19EQyBa%2Fimage5.png?alt=media&amp;token=f62066fe-1d68-44aa-bbf5-fdb2bddcf810" 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="https://2582339638-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FagGARFBou99u1ioIn7vL%2Fuploads%2F6mUAinWqo1pD1XdoHq9E%2Fimage2.png?alt=media&amp;token=1df17e6f-d19a-4988-9c5f-4059aaa1eff0" alt=""><figcaption></figcaption></figure>

Happy import-ing! 🤩