Changing shipping settings of all products using SQL

6 Feb 2012, 4:31 PM

New Zenner

Join Date:: Jan 2012
Posts:: 63
Plugin Contributions:: 0

Changing shipping settings of all products using SQL

I found a solution for product quantity boxes here.

It worked well for me. I was wondering if there was an sql script to change the shipping for all of my products. I want to change all of my product's Always Free Shipping in the Product Admin to No.

Thanks

6 Feb 2012, 4:34 PM

ajeh

Oba-san

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

Re: Changing shipping settings of all products using SQL

You could run in the Tools ... Install SQL Patches ...

UPDATE products SET product_is_always_free_shipping = 0;

NOTE: you should always backup your database before running things like this ...

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!

6 Feb 2012, 4:53 PM

bigstore

New Zenner

Join Date:: Jan 2012
Posts:: 63
Plugin Contributions:: 0

Re: Changing shipping settings of all products using SQL

Worked great.

Thank you sir!

BTW is there a Zen Cart SQL guide/ wiki anywhere?