Removing free shipping from multiple products

1 Feb 2011, 9:27 AM

New Zenner

Join Date:: Feb 2011
Posts:: 15
Plugin Contributions:: 0

Removing free shipping from multiple products

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,

1 Feb 2011, 2:42 PM

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Removing free shipping from multiple products

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;

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

1 Feb 2011, 5:08 PM

kromak

New Zenner

Join Date:: Feb 2011
Posts:: 15
Plugin Contributions:: 0

Re: Removing free shipping from multiple products

Worked a treat!

Thanks very much