Automated invoice updating system

So, I have recently been tasked with fixing our costing at my restaurant job. Nothing is currently automated, I am manually updating everything.

I would like to create an Excel sheet that automatically updates a list of products from various providers with pricing and amount from invoices that we scan in

I understand that the process should work in Microsoft power automate to pull data from invoices as I add them to a folder. What I am confused about is how I can get the prices to update without adding more rows of the same product.

For example: week 1 I order 20# of chicken for $30. Week 2 I order the same product, however price has increased to $35. I would like this new information to override the old information instead of create a new line with a different cost. The PLU# would stay the same week to week so it seems like it would be doable by just overriding info that has the same PLU# I'm just not sure how I would go about doing that.

Thanks for any advice