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.
in MultiStore by (170 points)

1 Answer

+1 vote
 
Best answer

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

 

by (13.5k points)
selected by
...