[ic] Track Product Views
Michael Goldfarb
interchange-users@icdevgroup.org
Fri Sep 6 10:41:03 2002
>Hi Guys
>RH 7.3
>IC 4.8.5
>This may be in a manual somewhere but, how can I track which products
have
>been viewed and also which products have been placed in the cart.
>We seem to be getting products viewed and not purchased so we need to
>assess
>what the customers are actually interested in so we can market better
too
>them. i.e. We may have wrong products on Special.
>Regards
_______________________________________
>Andrew Rich
>Maps Downunder
>Ph: +61 3 9748 0422 Fax: +61 3 9748 0422
><mailto:andrew@mapsdownunder.com.au>
><http://www.mapsdownunder.com.au>
_______________________________________
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]
I don't know if this is the best way to handle it, but it works well for
what our client needed.