Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: How to revise sourec code to do view count and sell count

  1. #1
    laomao is offline Member
    Join Date
    Jan 2009
    Posts
    36

    Default How to revise sourec code to do view count and sell count

    Since ASPDNSF doesn't have a flag that will determine the viewing count and selling count in the Product table. I have to can add 2 fields (ViewCount and SellCount) on the product table so that ViewCount will be incremented whenever that product is click and SellCount incremented whenever the product is sold (order is placed).

    My question is that what programs I need to modify to achieve the goals I mentioned above and how?

  2. #2
    ASPDNSF Staff - Jon's Avatar
    ASPDNSF Staff - Jon is offline Senior Member
    Join Date
    Sep 2004
    Posts
    11,419

    Default

    The dbo.Product.Looks column maintains a count of product views. Product sales data can be queried by joining the Product table with the Order_ShoppingCart table. With this method, it'll take into account product returns and sales of multiple quantites.
    Jon Wolthuis