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.

Learn more about...

AspDotNetStorefront
DotFeed

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

 

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