to purchased product relational table, and when you select a product to
view, they query the relational table for matches in the same category. It
wouldn't be difficult to do, but unless you limit the relational table to
recent purchases or only those in the same category, it would get huge in a
hurry.
At 03:12 AM 5/19/04, you wrote:
>When you look around Amazon.com, and show an interest in something, there's
>always a part of the page that says "people who bought this also bought that
>.."
>
>How do they do that?
>
>Do they really build tables of related items dynamically from purchases? Or
>do they have products categorised and just randomly pick products out of
>categories similar to the one you're looking at?
>
>Or do they do it another way? Or how do other online stores do this?
>
>Reason for asking: I am building an on-line store, and think it would be
>good to add this functionality if it's not too difficult.
>
>
>
>Cheers
>
>Mike Kear
>
>AFP Webworks
>
>Windsor, NSW, Australia
>
>http://afpwebworks.com
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:4:163600>This Message]
>[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=1523.1443.4>Fast
>Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
>
>----------
><http://www.houseoffusion.com/banners/view.cfm?bannerid=36>2ba1c4.jpg
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
