I am using wix store. With a product page, that has a recommending related products. now I do not want it to be manualy filled or randomly filled. I am looking on how to fill the related items to be shown as an alghorithem of collaborative filtering recommendation, which it for example: I user A buys product x and y. after this, if user B comes and buy product x, i'd like to show item y in his related items bar like (you may also like : Product y). So i am thinking about everytime a customer purchases item, his user id and product id would be imported to a database lets call it : BoughtItmes. So when another customer click on item and get to the product page , a query runs and searches in the database for customers who already bought this item, and check what else they did buy and show this products in the recommenders bar. is this possible? is there a way to do that thing that everytime a product is bought i can import his id and the products id to a data base? and use a query like this??
or even if there's a easier way , i'd be glad to hear it. Regards