The selection of a main variant doesn't have any effect

[SchlafSchaf]

PHP Version

PHP 8.3

Shopware Version

6.6.2.0

Expected behaviour

If i set a main variant in my variant listing configs, it should be preselect on the first load of a product page.

Actual behaviour

It doesn't, because there is a bug in the method checkVariantListingConfig on line 127 and 141 within the Content/Product/SalesChannel/Detail/ProductDetailRoute.php:

$productData = $this->connection->fetchAssociative( SELECT variant_listing_config as variantListingConfig, parent_id as parentId FROM product ...

This query always leeds to a return value null within the following condition on line 141:

if (empty($productData) || empty($productData['parentId']) || $productData['variantListingConfig'] === null) { return null; }

This is because a product can have a database entry in parent_id (x)or in variant_listing_config, but never in both. So the method always return null.

How to reproduce

Try to define a specific variant as main variant in the variant listing config and you will see, that this setting will have no effect. If you request a product page with the parent url, a random variant will be choosen and displayed.

[shopware-issue-bot]

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

• "Choose main variant" only allows for 25 variants
• Pre-Selection of a Product Variant
• Frontend: Variant selection changes unexpectedly
• Search for products with selected main variant misleading
• Enable developers to choose which variant will be displayed on a parent article
• When switching variants from product detail the old variant is still shown, but it shows as switched
• Main variant not displayed on filtered product listing
• Automatic change of main variant if out of stock / Automatischer Wechsel der Hauptvariante bei Abverkauf
• Main variant is ignored after setting a filter
• Variant selection Shopware 6.4.10.1