Change shipping rules on all products

[osdude]

How would you change the shipping rules on ALL products?

I enabled free shipping on every item and now, I need to change the shipping rules to "No, Normal Shipping Rules".


I would think, SQL would be the best method, but I know next to nothing about SQL.

In PHPMyAdminSQL the field I "think" I need to change is:

zen_products >> product_is_always_free_shipping

and change the free_shipping field for all items to '0'. I think '0' is "No, Normal Shipping Rules"

I searched, but I may have missed the proper terminology.

ANy help is appreciated. It 'seems' like it should be easy, but I'm afraid of messing up my DB since I know so little about SQL

[osdude]

I think this might work? But maybe someone who can read SQL can let me know if this isn't going to have me restoring the database

UPDATE `CHANGETOTHENAMEOFYOURDB`.`zen_products` 
SET `product_is_always_free_shipping` = '0' 
WHERE `zen_products`.`product_is_always_free_shipping` =1 ; 

[osdude]

OK, a quick back up to the DB and I ran the above statement and...

BINGO - it worked

[Kim]

Thanks for posting your solution and the outcome.

[osdude]

No problem. Maybe it will help someone else in the future