[ic] Track Product Views

[Michael Goldfarb]

>> -----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.
>
>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).
>
>Thank you,

Hey Dave -

Where would you like to view the results? Are you wanting to display
them on the flypage? Access them in the Admin. UI somehow?