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

Thread: Changing stop date for products

  1. 03-16-2010, 05:00 AM #1
    endresultlaura is offline Junior Member
    Join Date
    Feb 2008
    Posts
    8

    Default Changing stop date for products

    We had been using stop dates for our products but have recently stopped using them. Is there a sql command that I can run to remove all of the stop dates for products entered? Changing them individually is taking forever.
  2. 03-16-2010, 07:05 AM #2
    John Reasons is offline Senior Member
    Join Date
    Oct 2009
    Posts
    119

    Default

    You can run this sql command to accomplish what your after, though I would highly recommend making a backup of the db before doing any direct table edits.

    update Product set AvailableStopDate = NULL where AvailableStopDate IS NOT NULL
  3. 03-17-2010, 05:53 AM #3
    endresultlaura is offline Junior Member
    Join Date
    Feb 2008
    Posts
    8

    Smile

    Thanks John, that was soooo much easier!
  4. 03-17-2010, 06:45 AM #4
    John Reasons is offline Senior Member
    Join Date
    Oct 2009
    Posts
    119

    Default

    Your very welcome.
  5. 04-26-2010, 10:08 AM #5
    MPH is offline Member
    Join Date
    Mar 2007
    Posts
    77

    Default

    Question 2: AvailableStopDate

    Instead of the SQL command to "Null" how could a statement be formed that instead displays/reports the items that have reached their respective AvailableStopDate?

    A custom report, or perhaps output to a topics page by modifying an XML file? WSI output?

    The problem is some products are phantoms where the Stop Date was never set? In fact, no product is set to stop.

    V 7.0.2.5