Always pre-select a available variant on the product detail page

[niklaswolf]

PHP Version

8.2

Shopware Version

6.5.7.4

Expected behaviour

There is always a available variant selected by default on a product detail page (if there are any available).

Actual behaviour

The cheapest variant is selected by default, disregarding the availability

How to reproduce

https://github.com/shopware/shopware/blame/trunk/src/Core/Content/Product/SalesChannel/Detail/ProductDetailRoute.php#L145
This is because this is the generated SQL:

ORDER BY IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC, `product`.`available` DESC,

If the two sortings get reversed, it works correctly.

ORDER BY `product`.`available` DESC, IFNULL((ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100), (ROUND((ROUND(CAST((COALESCE((JSON_UNQUOTE(JSON_EXTRACT(`product.parent`.`price`, "$.cb7d2554b0ce847cd82f3ac9bd1c0dfca.gross")) + 0.0))) as DECIMAL(30, 20)), 2)) * 100, 0) / 100)) ASC

[shopware-issue-bot]

We found the following existing issues which may help or are related to your topic:

• Pre-selection of variant-options after redirection to product detail page
• Pre-Selection of a Product Variant
• Variant handling on the product detail page
• Cheapest price for variant products
• In case of a manual product selection, a non-purchasable parent product/variant can be selected
• Enable developers to choose which variant will be displayed on a parent article
• productlisting - automaticly showing variant with stock
• New generated product variants should have the same storefront order as set in the properties based on priority.
• The variant prices should be displayed individually in the search drop-down
• Frontend: Variant selection changes unexpectedly

[kingschnulli]

I think i fixed that already:

#3352

[niklaswolf]

@kingschnulli not entirely in my case. As I described I have to switch order, the sortings are added to the criteria. Only after that it works correctly.
This only occurs, if the variants of a product have different prices. Then the availability-sorting is applied AFTER the price-sorting, which leaves us with a selected unavailable variant, if all variants with the cheapest price are unavailable.

[kingschnulli]

Ah good catch, never saw that case. You can use my pr as a starting point for yours, sounds like the tests need some love here as well