I need to sort the view by the calculated sell price, is that possible?
If I add a price field I can select to "Display the calculated sell price for the current user"
But I can't find any way of sorting using the calculated price, the view can only be sorted by the product base price, which is pretty pointless if you have loads of discounts.
Maybe there is a way to do this currently and I've missed it? If not I think it would be a great (essential IMHO) feature.
Thanks for great module!

Comments

kevster’s picture

kevster commented

We have the same issue, currently we are trying to sort products in category views by lowest price first using (Referenced Product) Commerce Product: Discounted Price:amount (asc) but we also have products that are not discounted e.g. only have one original price, have tried many variants without success.

A product without a discount effectively has a null discount value - the sort comes out with products with original price first e.g. http://www.tapsandshowers.com/product-categories/basin-taps and then discounted price products in order.

One solution is to set all the non discounted prods to have a discount value the same as the orig but I dont see this as a very elegant solution.

Any help appreciated.

andyf’s picture

andyf commented

Hi, I found this issue while trying to do the same thing for products on sale via Commerce Sale Price. I've managed to get something working now and just thought I'd post a link to a sandbox module that explains the situation (hopefully) clearly and provides something workable (if not final).

HTH

czigor’s picture

czigor commented
Issue summary: View changes
Status: Active » Closed (duplicate)

See #1020050: Allow Views to sort / filter based on pre-calculated prices.