---
title: "Quantity Discounts"
description: "Display volume-discount price tiers next to products so customers can see exactly how much they save when they buy more."
url: "https://docs.j2commerce.com/v6/apps-and-extensions/apps/qtydiscount"
markdown_url: "https://docs.j2commerce.com/v6/apps-and-extensions/apps/qtydiscount.md"
last_updated: "2026-10-23T02:33:38+00:00"
version: "J2Commerce 6"
breadcrumbs:
  - title: "Home"
    url: "https://docs.j2commerce.com/"
  - title: "J2Commerce 6"
    url: "https://docs.j2commerce.com/v6"
  - title: "Apps and Extensions"
    url: "https://docs.j2commerce.com/v6/apps-and-extensions"
  - title: "Apps"
    url: "https://docs.j2commerce.com/v6/apps-and-extensions/apps"
  - title: "Quantity Discounts"
    url: "https://docs.j2commerce.com/v6/apps-and-extensions/apps/qtydiscount"
---

# Quantity Discounts

The Quantity Discounts app shows a pricing table on your product pages and category listings so customers can immediately see what they pay for different order quantities. When a shopper sees that buying 10 units costs less per item than buying 1, they are more likely to increase their order size.

The app reads the tiers you already set up in **Advanced Pricing** and renders them as a responsive table. It handles optional date windows, customer-group-specific pricing, and live table updates when a shopper switches between product variants.

## Prerequisites

- J2Commerce installed and active
- At least one product with **Advanced Pricing** rows configured on its master variant (see [Advanced Pricing](https://docs.j2commerce.com/index.php?option=com_content&view=article&id=558&catid=48))

## Purchase and Download

**Step 1:** Go to our [**J2Commerce** website](https://www.j2commerce.com/extensions) **->** **Extensions**

**Step 2:** Locate the **Quantity Discount** **->** click **View Details -> Add to cart -> Checkout**.

**Step 3:** Go to your **My Downloads** under your profile button at the top right corner and search for the app. Click **Available Versions -> View Files -> Download Now**

## Install the App

Go to **System > Install -> Extensions**

Upload the `app_qtydiscount.zip` package file or use the Install from URL option.

![Custom Tabs](https://docs.j2commerce.com/images/docs/v4/assets/user-group-3%20%287%29.webp)

## Configure the Plugin

The plugin installs and enables automatically.

Once you have installed the plugin, there are **two** ways you can access it.

**Option A:** Go to the **J2Commerce** icon at the top right corner **-> Apps**

**Option B:** Go to **Components** on the left sidebar **-> J2Commerce -> Apps**

![Enable custom tab app](https://docs.j2commerce.com/images/docs/shared/tabs-apps.webp)

## Configuration

Open the plugin settings by clicking **Quantity Discounts** in the Apps list.

> **Tip:** Click the **Toggle Inline Help** button in the toolbar and the app will show a description below each field as you configure it.

### Show Discount Table In

Controls which pages display the quantity discount table.

Below shows the Options and what they do.

**Product View Only:** Table appears only on single-product pages. Best for stores where the table would clutter category grid layouts.

**Category View Only:** Table appears in category and tag listing pages but not on single-product pages. Rarely needed on its own.

**Product and Category Views:** Table appears everywhere. Good when products are typically bought in bulk and you want the pricing visible at every stage.

**Recommended:** Start with **Product View Only** (the default). Move to **Product and Category Views** if your customers frequently browse category pages before deciding on quantity.

### Date Format

An optional PHP date format string used when a pricing tier has a start or end date. Leave the field empty to inherit the format from J2Commerce global settings.

Common formats and their Example Output are listed below:

`d-M-Y`: 01-Jan-2026

`d/m/Y`: 01/01/2026

`F j, Y`: January 1, 2026

`Y-m-d`: 2026-01-01

If you have no date-restricted tiers, this setting has no visible effect — the date column only appears in the table when at least one tier has a start or end date set.

### Debug Mode

Writes diagnostic information to `administrator/logs/plg_j2commerce_app_qtydiscount.php`. Turn this on temporarily when troubleshooting a table that is not appearing, then turn it off again in production.

Click **Save** after adjusting any setting.

## Enabling the Table on a Specific Product

The plugin-level **Show Discount Table In** setting controls which page types can show the table. You also need to switch the table on for each individual product where you want it to appear.

1. Go to **J2Commerce** -> **Catalog** -> **Products**.
2. Open the product you want to configure.
3. Click the **Apps** accordion tab in the product editor.
4. Find the **Quantity Discounts** section and set **Display Quantity Discounts** to **Yes**.
5. Click **Save** or **Save & Close**.

The table is disabled by default on every product. This means you can install the plugin and configure it without anything appearing on your storefront until you explicitly turn it on product by product.

## Setting Up Quantity Tiers

The Quantity Discounts app only displays tiers — it does not create them. You set up the actual price breakpoints in **Advanced Pricing**.

Go to **J2Commerce** -> **Catalog** -> **Advanced Pricing** and add rows for the product variant you want to discount. Each row specifies:

- **Quantity From** — the minimum quantity for this price to apply
- **Quantity To** — the maximum quantity (leave empty for an open-ended "N and above" tier)
- **Price** — the per-unit price for this quantity range
- **Date From / Date To** — optional date window (leave empty for no date restriction)
- **Customer Group** — optional group restriction (leave empty for all customers)

See [Advanced Pricing](https://docs.j2commerce.com/index.php?option=com_content&view=article&id=558&catid=48) for full instructions on creating tiers.

Once your Advanced Pricing rows exist and the product has **Display Quantity Discounts** set to **Yes**, the table appears automatically on the front end.

## How the Table Looks

The discount table is a clean, responsive Bootstrap table that appears below the product price.

### Quantity column

Each row shows the quantity range for that tier:

- If **Quantity To** is set: displays as `5 - 9`
- If **Quantity To** is empty on the last tier: displays as `10 and above`
- If **Quantity To** is empty on a mid-tier row: the upper bound is derived from the next row's **Quantity From** minus one

### Valid column (date-restricted tiers only)

The date column is hidden completely when none of the tiers have date restrictions. It appears automatically as soon as any tier has a start or end date, showing the active window for that row only.

### Price column

Prices are formatted using your J2Commerce currency settings, exactly as they appear elsewhere on the store.

### Variant switching

When a shopper selects a different variant (color, size, etc.) on a Flexible Variable, Variable, or Configurable product, the table updates instantly without a page reload to show the tiers for the newly selected variant.

## Customer Group Pricing

Advanced Pricing supports creating tiers that only apply to specific customer groups — for example, wholesale pricing visible only to members of a "Trade" group. The Quantity Discounts table respects these restrictions automatically.

- A tier with **no customer group set** is visible to all visitors including guests.
- A tier with a **specific customer group** is only shown to logged-in users who belong to that group.

If a logged-out visitor views a product that has only group-restricted tiers, the discount table does not appear (there are no tiers to show them). This means you can have separate public and wholesale pricing tables on the same product without any extra configuration — each group simply sees its own applicable tiers.

## Troubleshooting

### The discount table does not appear on the product page

Work through this checklist in order:

1. **Plugin enabled** — Go to **J2Commerce** -> **Apps** and confirm the Quantity Discounts plugin status is enabled.
2. **Product toggle on** — Open the product in the editor, expand the **Apps** accordion, and confirm **Display Quantity Discounts** is set to **Yes**.
3. **Advanced Pricing rows exist** — Go to **J2Commerce** -> **Catalog** -> **Advanced Pricing** and verify rows exist for the product's master variant. The table cannot display tiers that do not exist.
4. **Display location setting** — In the plugin settings, confirm **Show Discount Table In** includes the page type you are viewing (Product View, Category View, or Both).
5. **Customer group match** — If all your tiers are assigned to a specific customer group, log in as a user in that group. Guests see only tiers with no group restriction.
6. **Date window** — If your tiers have **Date From** or **Date To** values, confirm today's date falls within the active window. Expired or future tiers are filtered out automatically.
7. **Debug mode** — Enable **Debug Mode** in the plugin settings, reload the product page, then open `administrator/logs/plg_j2commerce_app_qtydiscount.php` to read the diagnostic output.

### The table shows for some variants but not others

Each variant has its own Advanced Pricing rows. The table reads tiers for the currently selected variant. If a variant has no rows in Advanced Pricing, the table will not appear when that variant is selected. Add Advanced Pricing rows for each variant that should show volume discounts.

### The date column shows for some products but not others

The date column appears only when at least one visible tier on that product has a start or end date set. Products whose tiers have no date restrictions will never show the date column — this is intentional to keep the table as simple as possible.

### Prices are not formatted correctly

The app uses your J2Commerce currency settings. Go to **J2Commerce** -> **Configuration** -> **Store** and verify the currency symbol, decimal places, and thousands separator are configured correctly.

## What Is New in J2Commerce

The J2Commerce version of this app is a complete rewrite from the J2Store original with several improvements:

- **Customer group rules with no group set are now visible.** The J2Store version silently hid these rules. Any tier with no customer group is now correctly shown to all visitors.
- **Explicit quantity_to support.** J2Commerce uses the `quantity_to` column directly when it is set. The J2Store version always derived the upper bound from the next row, which could produce incorrect ranges on the last tier.
- **Zero-date safe.** Tiers stored with a `0000-00-00` date (a common database artifact) are now treated as having no date restriction rather than being incorrectly filtered out.
- **No N+1 queries on category pages.** The app caches price rows per variant for the entire page request. A category page with many products triggers one query per unique variant, not one query per product.
- **Vanilla JavaScript.** The variant-switching update uses no jQuery. It works with any Joomla 6 template.
- **Parameterized queries throughout.** All database access uses bound parameters, following Joomla 6 security standards.
- **Debug logging with the Joomla 6 Log API.** When debug mode is on, diagnostic entries go to the standard Joomla log directory in a dedicated log file.