Forums / Built-in Shipping and Payment Modules / What is the mySQL command to reset "Always Free Shipping" NO

What is the mySQL command to reset "Always Free Shipping" NO

Started by oavs on 28 Jan 2014, 12:47 AM · Views: 616

Results 1 to 3 of 3
28 Jan 2014, 12:47 AM
#1
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

What is the mySQL command to reset "Always Free Shipping" NO

Hi

I have a lot of products already set to "Always Free Shipping" >> YES

What is the mySQL command to reset all products to "Always Free Shipping" >> NO

Thanks

Downunder QLD

28 Jan 2014, 2:21 AM
#2
ajeh avatar

ajeh

Oba-san

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

Re: What is the mySQL command to reset "Always Free Shipping" NO

You can use:

UPDATE products SET product_is_always_free_shipping = 0;

in the Tools ... Install SQL Patches ... to change all Products to not Always Free Shipping ...

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!

28 Jan 2014, 11:13 PM
#3
oavs avatar

oavs

Totally Zenned

Join Date:
Jan 2006
Location:
Downunder - QLD - Gold Coast
Posts:
921
Plugin Contributions:
0

Re: What is the mySQL command to reset "Always Free Shipping" NO

Xxxxxxx
:-)

Downunder QLD