Zen Cart Logo
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

Views: 608

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

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 ...

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
:-)