@paul_n I got this working by following your advise. So I have mass updated the metafileds for all the products.
Now I need a practical solution so that very product when updated, the flow pics it up and adjust the metafields accordingly.
the following flow is picking the same hundred products everytime even though we updated all the product pricing just today with Bulk editor
