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 3 of 3

Thread: Date Range for BestSellers.aspx

  1. 03-16-2010, 10:40 AM #1
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default Date Range for BestSellers.aspx

    Hi

    Our website holds seasonal sales that affect our best selling items. Is it at all possible to somehow put in a date range within the bestsellers page so that it only pulls out that info (say 2009-10)?
  2. 03-16-2010, 10:47 AM #2
    George the Great is offline Senior Member
    Join Date
    Nov 2006
    Location
    Cleveland, OH
    Posts
    1,792

    Default

    By default, the xmlpackage responsible for the results displayed on the bestsellers.aspx page - page.bestsellers.xml.config - calls the aspdnsf_BestSellers stored procedure which takes a first parameter - @since - that is an integer value representing the number of days from today that you want to review for the best sellers. The default value is 180, which means it will determine the best sellers over the last 180 days and these are the products that will be displayed. You can change this number in the xmlpackage directly in the query to the aspdnsf_BestSellers stored procedure, or you can modify the stored procedure (or create a new one that mimics aspdnsf_BestSellers) to accept a @since and @to parameter so that you could pass in a date range for which to retrieve best sellers.
    <a href="http://www.aspdotnetstorefront.com">Shopping Cart Software</a>
  3. 03-18-2010, 03:25 AM #3
    deanfp is offline Senior Member
    Join Date
    May 2009
    Location
    Sweden
    Posts
    556

    Default

    Thanks!

    Managed to change this to the last month which is exactly what we wanted. However in the appconfig I have selected to show images to true but I'm getting no images shown even though all products have a icon, medium and large image.

    Any ideas on how we can get these images up?