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

Thread: New Arrivals category only display items uploaded within 30 days.

  1. 05-11-2010, 06:04 PM #1
    witchikikoy is offline Junior Member
    Join Date
    Oct 2009
    Posts
    14

    Default New Arrivals category only display items uploaded within 30 days.

    Hello everyone...

    I would just like to ask some ideas on how to control the display of products in the category pages based on the Product's date of creation... This is what i'm trying to do.. I have a "New Arrivals" Category and I want that only the products that have been uploaded 30 days after its creation will be the only one to be displayed on that category page... Is there a way to unmap or hide the products that are created more than 30 days earlier?

    Thanks in advance for the help...

    Any ideas would be greatly appreciated...
  2. 05-11-2010, 06:52 PM #2
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    Sure, that's possible. There are couple of ways to do this: 1. You can set the "Stop Date" of those products that you do not want to display to an earlier date, 2. Unpublished them, 3. Modify the particular XMLPackage you're using for your product display and add a WHERECLAUSE condition from the Aspdnsf_Getproducts to filter out the CreatedOn field from the product table.
  3. 05-12-2010, 12:15 AM #3
    witchikikoy is offline Junior Member
    Join Date
    Oct 2009
    Posts
    14

    Default

    Sorry if I miss led you on my first question... What I actually want is to automatically remove the mapping of the product to the New Arrivals category after 30 days. The Product shouldn't be deleted or unpublished. It stays visible on its other mappings exept in the New Arrivals Category...
  4. 05-12-2010, 07:06 AM #4
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    There's no built-in way to do that through the admin site I'm afraid. The easiest way to do this would be with a DB trigger. Check the 'created on' date for the product in the Products table, and if it's more than 30 days ago, delete the row from ProductCategory where ProductID=# and CategoryID=#
    ECommerce Shopping Cart