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 change "Is Call To Order" on all products at one time?

  1. 05-31-2012, 12:55 PM #1
    knuttall is offline Junior Member
    Join Date
    Feb 2011
    Posts
    7

    Default How to change "Is Call To Order" on all products at one time?

    I have over 2000 products that I need to change the "Is Call To Order" from no to yes. Is there a way to do this without going into each individual product to change it?

    Thanks in advance.
  2. 06-01-2012, 06:24 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    Do this on your test environment first to make sure the result is as you are expecting, and make a backup of your production db before doing it:

    Code:
    UPDATE Product
SET IsCallToOrder=1
    This will change ALL of your products to Call To Order. You say 2000 products; is that all of them or only a selection?
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!