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.

Categories

Most popular tags

aspdotnetstorefront shipping xml-package checkout v10 xmlpackage email paypal sql order promotions customer shopping-cart search product xml real-time-shipping add-to-cart categories kit-product kit multistore coupon error products navigation mobile aspx appconfig seo onepagecheckout free-shipping topic template price customer-level orders admin responsive smartcheckout inventory minicart skin iis 9 css account variant display admin-console gift-cards payment tax upgrade page discount subcategories code aspdnsf 9-5-1 pay-pal-express rt-shipping redirect url-rewrite ups dotfeed title excel cart config javascript google-analytics-ecommerce log-in contact-form product-mapping recurring server-error error-message stored-procedure homepage tracking skins related-products address wsi import database aspdotnetstorefrontcore promotion receipt server menu url security images xml-config custom-reports credit-cards tracking-code topic-editor

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.
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
 | Snow Theme by Q2A Market
Powered by Question2Answer
...