The problem I see with doing it that way (favorites column in product database table) is, what if 2 users favorite the same product at the same time? That would lead to issues…
Additionally, I asked in a separate thread on how best to do this and consensus was a separate table: What's the best way to create a "favorite" function? - #4 by Joyce
But regardless of which way, how do I link to it to my static product pages? Because I am already having these static product pages from a static product collection that I want to show for seo purposes. But how do I link to these static pages from my (dynamic) favorite product page / collection? As even if I have a “favorites” column" that has to be dynamic?
I hope this makes sense…