filter for sale products

Anonymous

#224730

Hi,

Is it possible to filter “on sale” products ? I can not find any option to do that, nor meta field, which could help me to resolve this issue.

Regards,

Trevor

#224787

This reply has been marked as private.

Trevor

#224789

Sadly, WooCommerce does not have a meta key to indicate ‘on sale’ (AFAIK) so there is not a lot that can be done.

If you were to look at the code for the WooCommerce [sale_products] shortcode, you would see how convoluted it is to work out which ones are on sale. It also creates a lot of query calls to the database.

Anonymous

#224808

Sorry for license expiration. It should be active now.

I understand. But all other filter plugins has this option.
It could be enough to check if sale_price is not NULL.

I think that as robust filter as S&F is, should have this option, even for the “price” of more DB requests (maybe with warning note for users).

Is it really impossible to achieve this feature with S&F (nor with simple plugin update) ?
Maybe if you can hint me for plugin update I should shift these hints to my programmer.

I hope, that my license reactivation was not useless :/

Trevor

#224812

You might be able to use the Post Meta settings tab and check if Sale_Price >= 0

But this would be a fixed filter (not user selectable). Otherwise, it cannot be done for now.

Anonymous

#224816

Ok, thank you, but you not make me happy.

I think to add custom “on sale” product attribute, and make taxonomy filter for it.
But it won’t be so dynamic, and bring me more administrative effort.

Trevor

#224822

I understand and I am sorry that it looks like our plugin can’t yet do what you want.

[Author]

Posts