Sort by pseudoprice

Shopware 5 International (English Only)
1

Hello
I am trying to add a new sorting method to list all products which have a pseudoprice.

I am using this plugin which adds more sorting method and the ability to use sql queries:
Enhanced sorting | System | Administration | Extensions | Shopware Community Store

Can any one guide me with an sql query to select the all products which  have pseudoprice?

Thank you!

2

Hi,

as described in the support email the SQL code is: (listing_price.pseudoprice> 0) DESC
And you have to use a price sorting field to make the listing_price.pseudoprice avaible in the SQL-Call.

Best wishes

1 „Gefällt mir“