private static function updateOptions($product) { $db = \App::get('db'); $productOptionGroups = $product->getOptionGroups(); $optionsSql = '(0'; foreach ($productOptionGroups as $ogId) { $optionGroup = new OptionGroup($ogId); $optionGroupOptions = $optionGroup->getOptions(); foreach ($optionGroupOptions as $option) { $optionsSql .= ", " . $db->quote($option->getId()); } } $optionsSql .= ')'; $productSkus = $product->getSkus(); $skusSql = '(0'; foreach ($productSkus as $sku) { $skusSql .= ", " . $db->quote($sku->getId()); } $skusSql .= ')'; $sql = "DELETE FROM `#__storefront_sku_options` WHERE `sId` IN {$skusSql} AND `oId` NOT IN {$optionsSql}"; $db->setQuery($sql); $db->query(); }