It’s inevitable that a person is going to end up with (nearly) duplicate entries for products. It would be nice to have a “cleanup” function where you could select products and combine them/make them the same.

I export my data to a spreadsheet at year end to do financial analysis. I sort by product name and rename any duplicate ones that have similar names at that point