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();
}
