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

[knuttall]

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.

[esedirect]

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:

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?