On my website's product list, each product has a "Retail price:" (which is a reference price only) and a "Wholesale Price:" (the final price that customer can buy).
Some products comes with a "Discount Price:" (price went down), as below shows,
When I go to the category list, and choose Sort by Price(low to high), the products are sorted by "Wholesale Price:" only. The "Discount Price:" doesn't work on sort orders.
How can I sort the products by price right?
Bookmarks