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: DB query to move product to another category

  1. 10-26-2010, 08:51 AM #1
    caraj is offline Member
    Join Date
    Dec 2009
    Posts
    79

    Default DB query to move product to another category

    HI all
    I cant find the command to enter in the db query to move a product to a different category.

    I remember it here somewhere in this forum but I cant find it.
    Thanks
  2. 10-26-2010, 11:40 AM #2
    chrismartz is offline Senior Member
    Join Date
    Apr 2010
    Posts
    339

    Default

    Wouldnt you just update the ProductCategory table?

    i.e. UPDATE ProductCategory SET CategoryID = # WHERE ProductID = #


    Obviously change # to be the correct number for categoryID as well as ProductID
    Chris Martz
    United Art & Education
  3. 11-09-2010, 12:50 PM #3
    caraj is offline Member
    Join Date
    Dec 2009
    Posts
    79

    Default

    Awesome! Thanks for your response. It worked great
    ANd sorry about the delay in getting back to you.