Hi There,

I've got a client who has decided he wants to start selling outside the UK.

I've set up his shipping for him so he has free shipping to the UK and can charge for over seas shipping using Zones shipping.

The problem is he's been using the setting "Yes, Always Free Shipping" in his product settings which now needs to be changed to "No, Normal Shipping Rules".

I've changed a few products to check shipping works ok and it does, but he has over 2000 products in his shop.

Is there an easy way of changing this with an SQL patch? I'm not all that hot with SQL but from what I've read I'm guessing that something like:

"update products set product_is_always_free_shipping = 1"

Would work in change this attribute store wide?

I'd be very grateful if somebody could confirm the above is correct or tell me what is.

Kindest Regards

Hylton