Sorting by price in backend items list is not OK

Hello,

In the backend, the product are stored via the value stored in the "product sort price". It's a standard price generated on the default currency, for guest users, for a single quantity, without any tax or discount.
If you do have special prices or discounts, the sort might looks incorrect even if it's not really.
In order to provide good performances, we generate and use that "sort price" so we don't have to process all product prices of your store (which could be huge) to then perform a sorting.

Regards,

Hi,

The problem is that different users can have different discounts. And the "product sort price" is calculated in the backend when you create/edit the product and there is only one sort price for one product.

Now, you can use mass actions to change the sort price to whatever you want. If you create a mass action with an action "display the values" with the product_id, product_name, price_value and product_sort_price, once you process the mass action, you'll get a table where you can double click on a cell of the sort price column and change it to whatever you want and the fiilter will then take that change into account.