How do you remove the free shipping option from all products

Question

We have thousands of products available on our site with a cost of over $100.  We previously allowed free shipping on products over $100 so when we enter the product varient, we selected free shipping for that product.  How can I run a sql statement to remove that option for all the products we have in our database?

 

Thank you.

Answer 1

Make sure you've got a backup of the database first just in case, then this ought to do it:

 

UPDATE ProductVariant SET FreeShipping = 0