Jump to content

On sale products only in special block and prices-drop.php


Recommended Posts



I just need some help with on sale products. At the moment my product prices are configured in a way, that each product has a couple of special prices - quantity to percentage discount, different in each group of users. I got what I need elsewher but the problem is, that specials block displays generally all the products in a shop as all of them have special prices.


I would like to limit products in specials block and prices-drop.php (listing of discounted products) only to those who are on sale. How to achieve that?


I see no class I could use here. A custom function would be a solution? How to build a sql query to have only on sale products?


Any help appreciated.

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...