Hello
We can’t modify “wc_product_meta_lookup.min_price” directly , as product price can depend on role or cart contents (for example, category discount only if cart totals>100 ).
But if your rules use only “Product filter” + “Product discount” (supported by shortcode [adp_product_onsale]) – we can implement correct sorting via hook “woocommerce_get_catalog_ordering_args”.
Please submit your rules (json text) as new ticket to https://algolplus.freshdesk.com/
Use >WooCommerce>Pricing Rules>Tools>Backup to get it.
Hello,
I also tested the issue on your official demo
https://demo.algolplus.com/
Even when applying only a simple “Product discount” rule (no cart, no role, no conditions), products are still ordered incorrectly by price. This confirms that the issue is not related to custom rules or theme overrides on our side.
It is unexpected that a pricing/discount plugin does not allow correct price-based product sorting, even in this basic and deterministic scenario.
Additionally, I would like to report that your demo site currently shows a visible message stating “HACKED BY LOST32X”, which might indicate a security issue.
Thank you for checking both points.
Hello
1. Don’t worry about demo, it’s impossible to hack it.
We allowed visitors to test features of our another plugin (Phone Orders), so “demo” user can add products/posts, even with title “hacked”.
2. >>It is unexpected that a pricing/discount plugin does not allow correct price-based product sorting
It’s common problem for WooCommerce pricing plugins.
You can check our competitors.
We don’t have ready solution too.
3. We can fix product sorting for simple “Product discount” rules .
Submit your rules as new ticket our helpdesk and we’ll prodive updated version for tests next week.
I saw your settings, thank you!
We’ll reply tomorrow.