Sale price filter WooCommerce

Anonymous

#51316

Hello, just purchased the plugin – works great!

Have 1 question – is there any way to have filter for WooCommerce showing only the products that have sale price? Like a checkbox ‘Has sale price’ / ‘Hasn’t got sale price’?

Thank you! :0

Trevor

#51324

Is that value a standard WC field, or one added by a plugin for WC? It might be a Post Meta field.

Anonymous

#51371

Yes, that is the meta field.
It can be either NULL (if there is no sales price) or numeric (if there is one).
Possible to make filter, that checks not a specific value, but just if there is any value? 😉

Anonymous

#51372

The screenshot:
https://drive.google.com/file/d/0B8DDgBzO522pTm5PemtBMGFJNDg/view

Trevor

#51703

That meta key name looks wrong? In the list, does it also appear without the leading underscore?

Anonymous

#52107

The meta key name is correct.
The thing is that the plugin doesn’t allow to set ‘>0’ value or NULL value to show only the products that have sale price ;(

screenshot

Trevor

#52111

You must do it instead in the settings tabs. Called Post Meta you can add rules there.

Anonymous

#53351

Yes, found it. But this is only applicable to all loaded results, and I’m looking for the way user can do it. By a checkbox for example.
If checked – showing products that have sale price (>0). If not checked – showing all products.

Anonymous

#53353

Here is the screenshot
https://drive.google.com/open?id=0B8DDgBzO522pZlZnLVFoMHk5Y2c

Trevor

#53360

You would have to code this yourself, but it MAY be possible. I think another user did something similar in processing terms (to set the AND/OR setting):

https://support.searchandfilter.com/forums/topic/global-or-filter_operator-problem/

You might be able to figure something, but this is outside normal support.

[Author]

Posts