yes, you can move recordset code to be in the repeat region It will get created in the head, so you need to manually it to the repeat region.
for the update, you could create a comma separated list of the product IDS inside the repeat region and as a hidden form element. you would need to hand code the update SQL for this using:
UPDATE yourTable SET processed = 1 WHERE productID IN($_POST['idList'])