Display All On Sale/Special Price items in Magento

Display All On Sale/Special Price items in Magento

July 10, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Display All On Sale/Special Price items in Magento

Displaying On Sale Items in Magento

Special prices are a powerful feature in Magento that allows you to set discounted prices for your products for specific time periods. If you want to create a layered navigation link to display all items currently on sale, this guide will walk you through the process.

Understanding Special Prices in Magento

In Magento, when you set a special price, you’re essentially defining a temporary discount for a particular product. This is different from regular pricing and can be used for limited-time promotions or seasonal sales.

To add a special price to an item:

  1. Navigate to the catalog > Manage Products.
  2. Select your product and click on “Special Price”.
  3. Enter the desired discounted price in the “Price” field.
  4. Set the start and end dates for the special price promotion under “Start Date” and “End Date”.

Once you’ve set these details, the product will appear as ‘On Sale’ during the specified time frame.

Creating a Layered Navigation Filter

Layered navigation allows customers to filter products based on various attributes, including special prices. To create an “On Sale” link:

  1. Enable Layered Navigation: First, ensure that layered navigation is enabled for your store’s catalog.

    • Go to Stores > Configuration > Catalog > Frontend.
    • Set “Use Flat Catalog Category” and “Use Flat Catalog Product” to ‘Yes’.
    • Click Save Config.
  2. Create the Attribute: Magento doesn’t have a built-in attribute for special prices, but we can create one.

    • Navigate to Stores > Attributes > Manage Attributes.
    • Click on “Add New Attribute”.
    • Enter details like Name (e.g., “Is On Sale”), Catalog Input Type for Store Owner (Dropdown), and Available in Storefront as a Layered Navigation Filter (Yes).
    • Save the new attribute.
  3. Assign the Attribute: Next, you need to assign this new attribute to your products.

    • Go back to catalog > Manage Products.
    • Select your product(s) that are currently on sale.
    • Click on “Attributes” in the left sidebar.
    • Find and click on the new attribute (e.g., “Is On Sale”).
    • Set it to ‘Yes’ for all products with special prices.
  4. Create a Layered Navigation Filter: Finally, you need to create the actual link.

    • Go back to Stores > Configuration > Catalog > Frontend.
    • Under Layered Navigation, expand the section for your store view.
    • In “Layered Navigation” set the “Display Mode in Product Listing Page” to ‘Yes’.
    • Set “Use Layered Navigation” to ‘Yes’ and click Save Config.

Displaying On Sale Items

Now that you’ve completed these steps:

  • All products with special prices will be tagged as ‘On Sale’ on your website.
  • When a customer visits your store, they will see an “Is On Sale” link in the layered navigation sidebar or top menu (depending on your theme’s configuration).

Clicking this link will filter the product list to display only items that are currently offering special prices.

Conclusion

Setting up special prices and creating a layered navigation filter for sale items is a great way to enhance the user experience and drive conversions during promotions. The process requires some setup, but it’s straightforward once you understand how Magento handles special pricing and layered navigation.

Remember to keep your special price attributes updated regularly to ensure customers always see accurate information about on-sale products.

Happy selling!

For more advanced tips on Magento development and e-commerce strategies, check out our blog at Laravel Company.

Catalog Configuration Customers Pricing

Our network