Unite price can't be used as sorting method

[vincent-dp]

Prerequisites

• I understand and accept the project's code of conduct
• I have already searched in existing features request and found no previous suggestion of this feature.

Is your feature request related to a problem?

Hello,

We cannot chose to sort product by its unite price.

Describe the solution you'd like

To be able to sort product by their unite price

Alternatives you've considered

I have tried to find/modify the method for a client, and I'm not able to follow the trace that leads to a sql query and I drown myself into the functions that build the search. So even if I wanted to add a column myself, the documentation is too rich/too poor to give me the oportunity to find a solution about productSearchQuery

Additional context

No response

Do you plan to work on this feature?

• I'm willing to contribute a formal specification.
• I'm willing to provide any wireframes or design assets required for this feature.
• I'm willing to submit a Pull Request that implements this feature.
• I'm willing to help verify that the implemented feature works as intended and produces no unintended side effects.

[hibatallahAouadni]

Hello @vincent-dp

Thank you for your suggestion. The Product Team will take it into consideration for future developments.
Please be aware that there is no guarantee that this feature will be developed anytime soon. If this is important to you, we strongly suggest you consider hiring a specialist to help you create it.

If you are willing to implement this feature into PrestaShop as a Pull Request, the teams will be happy to help you by ensuring that it is appropriate and coherent with the rest of the project. If that is the case, please let us know!

Thank you

[MatShir]

Now the unit price will be stored in the database with this PR #26762 for the next version. So after this PR is merged, we could rename this feature request 'can't sort with unit price' ;)

[vincent-dp]

Thank you, I have edited my request and the title

[jolelievre]

Hi @vincent-dp

as @MatShir told you we are introducing this unit price column in 8.0.0 However if you need it in your module for prior versions of PrestaShop you should be able to compute it in your SQL request. Similarly to what was done here for upgrade scripts PrestaShop/autoupgrade#441

You should be able to request something like this:

SELECT p.*, IF (`unit_price_ratio` != 0, `price` / `unit_price_ratio`, 0) AS unit_price FROM product p ORDER BY unit_price;

That's just a simple example (because you should also consider values from the product_shop table used for multishop, but that's the idea. Maybe it can help you in the meantime, if not you'll have to wait for the next 8.0.0 version to use this new column. You can test the develop branch once the #26762 is merged, and we'll add the Unit price field in the product page settings as soon as it's available.

[vincent-dp]

Thank you very much for answering.

Yes after reading the whole #26762 I was able to reproduce on an old release (1.7.5+) since it is pretty much straight forward.

About the sorting method,
the main problem of unite price (so far) is that it is not impacted by discounts (not directly as you made it into the db). For example, the price, when a discount is applied, get a value stored in ps_specific_price. This is very important because that's how the sorting method can adress the right numbers. otherwise, the sort by unite-price will be totally wrong if only based on the main ps_product table or even the ps_product_lang

I don't think I can make a module to make this sorting method works, since my client use another module for filtering search/catalog and it will be really messy to make all these works. So I think I have to wait for a release