Looking for old forum posts and information? View the old forum archive here ยป
Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

A static copy of our previous forums website is available online for reference. Click here to access the forum archive.

Learn more about...


How do you remove the free shipping option from all products

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.
asked Apr 6, 2017 in MultiStore by jonathn6 (160 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


answered Apr 6, 2017 by Vortx ScottS (13,500 points)
selected Apr 7, 2017 by jonathn6