Globally Change Activation Mode

Hi,

I was wondering if there's a way to globally change the Activation mode on "Files to Sell"? Our customer has 900+ items in her store but mistakenly set them all to "Manually" as she was adding them. She now realizes that the Activation mode should have been set to "After full payment" but we haven't found a way to make the change other then one by one. Is there another way?

Thanks!

I don't use/sell files but have you looked into the database whereas you can use a query to replace the setting?

Thanks. I got it and all have been changed

Use the following query in the phpMyAdmin:

UPDATE cscart_product_files SET activation_type = 'P';