Crease29

UPDATE product AS mainProduct
SET main_variant_id = (
    SELECT p.id
    FROM product AS p
             INNER JOIN product_option AS po
                        ON p.id = po.product_id
             INNER JOIN property_group_option AS pgo
                        ON po.property_group_option_id = pgo.id
    WHERE p.parent_id = mainProduct.id
      AND (p.active IS NULL OR p.active = 1)

Crease29

<?php
// ===================================================
// = place this file in the root of your OXID eShop! =
// ===================================================

require_once 'bootstrap.php';

// CONFIG
$sTheme  = 'my_custom_theme';
// CONFIG END

Crease29

<?php
// ===================================================
// = place this file in the root of your OXID eShop! =
// ===================================================

require_once 'bootstrap.php';

// CONFIG
$sTheme  = 'azure';
$iLangId = 0; // German