Forums / Built-in Shipping and Payment Modules / How to change shipping rules to massive products?

How to change shipping rules to massive products?

Locked

Results 1 to 2 of 2

This thread is locked. New replies are disabled.

30 Dec 2010, 5:40 AM

sjbglx

New Zenner

Join Date:: Sep 2010
Posts:: 70
Plugin Contributions:: 0

How to change shipping rules to massive products?

for example, If I have 1000 products with option "Yes, Always Free Shipping "selected and I want to change all of them to "No, Normal Shipping Rules". Can anybody teach me how to do it?

Thank you!

30 Dec 2010, 7:59 AM

rodg

Deceased

Join Date:: Jan 2007
Location:: Australia
Posts:: 6,263
Plugin Contributions:: 4

Re: How to change shipping rules to massive products?

sjbglx:

for example, If I have 1000 products with option "Yes, Always Free Shipping "selected and I want to change all of them to "No, Normal Shipping Rules". Can anybody teach me how to do it?

Thank you!

The following SQL command will do it:

UPDATE products set product_is_always_free_shipping = 0 ;

WARNING: Back up your database first. There is no other way to 'undo' this change.

Cheers
Rod