Magento: Display tier prices at category listing page

Magento: Display tier prices at category listing page

July 13, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento: Display tier prices at category listing page

Displaying Tier Prices on Magento Category Listing Page

If you’re trying to display all tier prices for products on your category listing page but only seeing single product prices, don’t worry - this is a common issue in Magento. Let’s dive into the problem and find a solution together.

The Problem: Incorrect Tier Price Display

When using print_r($_product->getTierPrice()) in your catalog/product/list.phtml file, you might expect to see multiple tier prices for each product. However, you’re likely seeing something like this:

Array
(
    [0] => Array
        (
            [price] => 0.5000
            [website_price] => 0.5000
            [price_qty] => 1
            [cust_group] => 32000
        )

)

This issue occurs because Magento’s default setup doesn’t automatically fetch tier prices for all products on the category listing page.

The Solution: Fetching Tier Prices Manually

To solve this problem, you need to manually query the database using Magento’s core resource model. Here’s how it can be done:

$resource = Mage::getSingleton('core/resource');
$query = 'SELECT * FROM ' . $resource->getTableName('catalog/product') . '_tier_price';
$_tier_prices = $resource->getConnection('core_read')->fetchAll($query);
var_dump($_tier_prices);

This code fetches all tier prices from the database and stores them in the $_tier_prices array. You can then iterate through this array to display the tier prices for each product.

Understanding Tier Prices

Before we proceed, let’s quickly understand what tier prices are in Magento.

Tier pricing is a feature that allows you to set different prices based on the quantity of products ordered. For example, if a customer buys more than 5 units of a product, they get a discount. This helps you create promotional offers and encourage bulk buying.

The catalog_product_tier_price table in your database stores these tier price values for each product.

Displaying Tier Prices in Your Template

To display the fetched tier prices on your category listing page, you can modify your template like this:

<?php foreach ($_product->getTierPrice() as $tierPrice) : ?>
    <p>Buy <?php echo $tierPrice['price_qty']; ?> units for only <?php echo Mage::helper('core')->currency($tierPrice['price'], true, false); ?></p>
<?php endforeach; ?>

This code fetches all tier prices and displays them as a list of “Buy X units for Y price” options.

Conclusion: Successful Tier Price Display

By manually querying the database using Magento’s core resources, you can successfully display all tier prices on your category listing page. This solution allows customers to see the discounted pricing structure at a glance before clicking through to individual product pages.

Remember to always test your changes in a development environment before deploying them to your live site. And don’t forget to optimize and cache your queries for improved performance.

If you’d like more advanced customizations or need help with other Magento issues, feel free to reach out to our team at Laravel Company. We’re always here to assist!

Catalog Database Themes Pricing

Our network