Change product always free shipping setting.

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

Hi There,

Can't believe I missed a post where it tells me exactly what I needed to know.

So my problem is now solved and my code worked (Shock).

Regards

Hylton

Thanks for the update that you have this working now ... :smile: