[ic] Track Product Views

[Mike Heins]

Quoting Dave LaTourette (dave@davesport.com):
> > -----Original Message-----
> > From: interchange-users-admin@icdevgroup.org
> > [mailto:interchange-users-admin@icdevgroup.org]On Behalf Of Michael
> > Goldfarb
> > Sent: Friday, September 06, 2002 7:41 AM
> > To: interchange-users@icdevgroup.org
> > Subject: RE: [ic] Track Product Views
> > We did this for one of our clients by adding a column to the products
> > table and then running a sql query on flypage.
> >
> > We added a column labeled "number_accessed" and then placed the
> > following query on flypage.
> >
> > [query st=db sql="update products
> > set number_accessed = '[calc][item-field number_accessed] + 1[/calc]'
> > where sku = '[item-code]'
> > "]
> > [/query]
> >
> 
> Hello Michael,
> 
> In reference to your above email (from quite a while ago), I'm also trying
> to track product views. I am using the default database though. I created a
> views field in my products database, and used your query on the flypage
> after changing the sql to gdbm and the field name to views.

That is a bad move. You don't want to be constantly writing your products
database. Especially with GDBM.

You should move it to a separate table, or rely on UserTrack.

> 
> My question is how did you then view the results? I can't seem to figure out
> the custom report function in IC (my store is Foundation based).
> 

In general, I think the best way to do this is custom setup on your 
web log, leaving Interchange out of it. There are pieces of software
designed to do exactly this kind of thing, and they are the best way
to accomplish it.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

People who want to share their religious views with you
almost never want you to share yours with them. -- Dave Barry