Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
Here is the setup. Users can rate products on a 1-10 scale. If a user says he likes product x, I would like to lookup all of the other users who liked x (based on if they rated x above say 9/10). Then look at all of those users'(the ones who rated x 9+) ratings to pick out the some other highly rated products that all people who like x have in common.
The part that is beyond me is how I would approach the issue of seeing what multiple users like in common.
Does this make sense at all?
For each A_i find all customers who also like A_i, store in array C
Loop through array C and find all other things those customers liked, store in hash L (item sku is key, how many of them liked each thing is value)
Return the hash L sorted by the number of people who liked each thing.
If you have a lot of customers and products this will take time so you might do it nightly and store the results for each customer in a seperate table.