Variantenattribute werden nicht erstellt

Shopware 6 (German)
, ,
1

Hallo Leute,
folgendes Query liefert mir all diejenigen Variantenattribute -und Werte, die über das Backend mit Standardmethoden nicht mehr verändert werden können:

SET @languageID='XXXXXXXXXXXXXXXXXXXXX';
SELECT product.product_number,property_group_translation.name AS Attribut,property_group_option_translation.name AS Attributwert FROM product
LEFT JOIN product_configurator_setting
ON product_configurator_setting.product_id=product.id
LEFT JOIN product_option
ON product_option.product_id=product.id
LEFT JOIN property_group_option
ON property_group_option.id=product_option.property_group_option_id
LEFT JOIN property_group_option_translation
ON property_group_option_translation.property_group_option_id=property_group_option.id
LEFT JOIN property_group
ON property_group.id=property_group_option.property_group_id
LEFT JOIN property_group_translation ON
property_group_translation.property_group_id=property_group.id
WHERE product.product_number='XXXXXXXXXX'
AND property_group_translation.language_id=UNHEX(@languageID)
AND property_group_option_translation.language_id=UNHEX(@languageID);

Über folgenden DAL Code versuche ich jetzt, Variantenattribute -und Werte programmatisch anzulegen. Es wird zwar keine Exception geworfen, aber das Query liefert nur noch NULL für die Neuanlegungen, Was läuft da schief? Muss ich auch noch DAL Code für das product.option Repository erzeugen?

    public function assignAttributes2Variants(Context $context, $arItem2BeUsedForAssigningValues): int {
        $counter = 0;
        try {
            for ($i = 0; $i < count($arItem2BeUsedForAssigningValues); $i++) {
                $valueAttribut = $arItem2BeUsedForAssigningValues[$i]['Attributwert'];
                $valueProductNumber = $arItem2BeUsedForAssigningValues[$i]['variantNumber'];
                $productId = $this->getProductIdByProductNumber($context, $valueProductNumber);
                $attributeId = $this->getAttributeValueIdByName($context, $valueAttribut);
                $versionId = $this->getVersionIdByProductNumber($context, $valueProductNumber);
                if (empty($attributeId) || empty($productId) || empty($versionId)) {
                    file_put_contents($this->logFile(), $this->getDateNTime() . "::No Variant Attribute assigning possible:Value for productId:$productId, Value forattributeId:$attributeId, Value for VeersionId:$versionId" . PHP_EOL, FILE_APPEND);
                } else {
                    $propertyGroupoptionID = $this->getAttributeValueIdByName($context, $valueAttribut);
                    try {
                        $this->productConfiguratorSetting->create([
                            [
                                'id'        => Uuid::randomHex(),
                                'versionId' => $versionId,
                                'optionId'  => $propertyGroupoptionID,
                                'productId' => $productId,
                            ]
                        ],
                            $context);
                        $counter++;
                    } catch (DriverException $er) {                   
                        file_put_contents($this->logFile(), $this->getDateNTime() . "::AttributValue $valueAttribut already has been assigned to variant product $valueProductNumber " . PHP_EOL, FILE_APPEND);
                    }
                }
            }
            return $counter;
        } catch (Throwable $er) {
            file_put_contents($this->logFile(), $this->getDateNTime() . "::" . $er->getMessage() . " in file " . __FILE__ . " at line " . __LINE__ . PHP_EOL, FILE_APPEND);
            exit(-1);
        }
    }

Vorab vielen Dank für jeden Hinweis…