How to massively change the value of the product property "new" and "hit" in 1s-Bitrix?

Question

1C-Bitrix

Good afternoon.
Initially (for some reason) the "default" value for new products and bestsellers was Y, since all products now have this value, the default value will be changed, but how can I bypass all products and change Y to N?
Where is this in mysql? Or maybe there is a built-in API for such things?

Answer 1

Kind.
Loop through all the elements from the directory and rearrange the value of the property. More or less like this:

CModule::IncludeModule('iblock');
$PROPERTY_VALUES = [
  "NEW" => "N",
  "HIT" => "N"
];
$arFilter = ["IBLOCK_ID" => id_каталога];
$res = CIBlockElement::GetList(false, $arFilter, ['IBLOCK_ID','ID']);
while($el = $res->GetNext())
{
  CIBlockElement::SetPropertyValuesEx($el['ID'], id_каталога, $PROPERTY_VALUES);
}