[ic] Track Product Views

Andrew Rich interchange-users@icdevgroup.org
Fri Sep 6 11:10:01 2002


> >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.
_______________________________________
>
> 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.
>
Thanks Michael

After months of using IC I am amazed at how little I really know about the
package.

When is Flypage accessed and therefore is this query counting products
viewed or placed in carts.  Actually I'm guessong it is viewed.  I just had
an idea! I could store date last accessed also via the same method which
would allow greater reporting power.

If I was correct about product view then maybe similar code placed on the
'Buy Now' would probably work for "in cart".

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>

_______________________________________
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. This email and any attachments are
also subject to copyright.  If you have received this email inadvertently or
you are not the intended recipient, you may not disseminate, distribute,
copy or in any way rely on it. Further, you should notify the sender
immediately and delete the email from your computer.  Whilst we have taken
precautions to alert us to the presence of computer viruses, we cannot
guarantee that this email and any files transmitted with it are free from
such viruses.