How to change the price of all products from a certain category in minishop2?

Question

MODX

Hello, I need to change the bulk prices for all products from the category with id 24.
Increase the price by 8%?

$product = $modx->getObject('msProduct', тут id);
$oldPrice = $product->get('price');
$product->set('price', $oldPrice  + $oldPrice*0.08);

Is this the correct code for one item? And how to write for everyone from one category?
I was told that it is possible to execute the script in console.

Thanks in advance!

Answer 1

$query = $modx->newQuery('msProduct');
$query->limit(10000);
$query->where(array(
    'parent' => 4, // тут ID категории
));
$docs = $modx->getCollection('msProduct',$query);
foreach($docs as $doc){
    $oldPrice = $doc->get('price');
    $doc->set('price', $oldPrice  + $oldPrice*0.08);
    $doc->save();
}