Can I set all products "Always Free Shipping"?

Hey Guys,
I want to set all products "Always Free Shipping" but it seems I need to edit these products one by one.
Is there any way to complete it all?
I've google it, and I followed one of the instruction:

In my zen cart admin go to Tools -> Install SQL Patches

Copy and pate the sql code with my added category ID number into the box and click on the “send” button.

"UPDATE products SET product_is_always_free_shipping = 1 WHERE master_categories_id = xx;"

But it NOT working for me. Anybody has better idea?
Thanks a lot!

If you want ALL Products to be Always Free Shipping, use:

UPDATE products SET product_is_always_free_shipping = 1;

Ajeh:

If you want ALL Products to be Always Free Shipping, use:

UPDATE products SET product_is_always_free_shipping = 1;

Cool, that works.
Thank you very much.
But what's wrong with previous code? What if I want only one category "Free Shipping"?
Maybe I just need to change the category number?

You needed to change the code for each master_categories_id ... but since you wanted ALL Products changed, you did not need the WHERE statement on it ... :smile:

Thanks for the update that this worked for you ...

Ajeh:

If you want ALL Products to be Always Free Shipping, use:

UPDATE products SET product_is_always_free_shipping = 1;

Where do I put this line of code?

Go to the Tools ... Install SQL Patches ... and paste that in there and hit SEND ...