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

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 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 by Vortx ScottS (13,280 points)
selected Apr 7 by jonathn6
...