1) Find someone who bought product X. 2) Find an order that person made. 3) Pick a random item from that order. 4) ????? 5) Profit.
On Tue, Apr 7, 2009 at 5:21 PM, Mike Kear <afpwebwo...@gmail.com> wrote: > > How do e-commerce sites do those "people who bought this also bought > this .." selections for cross-selling? I have been doing this > with a lot of work on the categories in my databases, so that when > someone selects one item, they are shown several other (randomly > selected) items in the same category. > > Is that the best way to do it? I guess a vast site like Amazon has > enough traffic to very quickly assemble enough transactions that they > can actually HAVE a 'people who bought this also bought that' because > for even very new items, its highly likely that someone will have > bought it. But what about lesser sites where new items might not make > sales for a day or two? How do they assemble this information? > > Is it in the categorising? Product keywords? A random select? > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
