Thank you very much Ryan, worked great on mysql and was exactly what I was looking for
So now I’ve put it into a php script for anyone looking to update pricing by category. Please note your COST and PRICE as well as the actual category ID you would like to apply the changes too.
// Create connection
// Check connection
echo "Failed to connect to MySQL: " . mysqli_connect_error();
mysqli_query($con,"update catalog_product_entity_decimal as d1
join catalog_product_entity_decimal as d2
on d1.entity_id = d2.entity_id
set d1.value = d2.value +20
where d1.attribute_id = 75 and d2.attribute_id = 79 and
d1.entity_id IN (select product_id from catalog_category_product
where category_id = 103)");
So now if you wanted to update the price by a %, you would need to modify the following line:
set d1.value = d2.value *1.1
I believe that should do a 10% markup.
Thanks again guys!