Removing free shipping from multiple products

[Kromak]

Hi,

Can't seam to find an answer for this. I have a lot of products set up to be free shipping, but this is no longer the case so I need to take them off free shipping. Is there an easy way to do this or do I have to go through each product?

Many thanks,

Al

[Ajeh]

If you want to change ALL Products to NOT use Always Free Shipping, backup your database and then you can run in the Tools ... Install SQL Patches ...

UPDATE products SET product_is_always_free_shipping = 0;

[Kromak]

Worked a treat!

Thanks very much