SQL Statement for updating required shipping

[thomasaswain]

Hello,

What/Where is the SQL statement for updating required shipping? I've got about 18k products and going through each one is simply not possible.

Thanks for the help!

[abolabo]

to turn off use

Code Select Expand

UPDATE `ac_products` SET `shipping`= 0;

or 1 to turn on.

Where ac_ - your tables name prefix

[thomasaswain]

Thanks for the response.

Select 1 will turn shipping ON so I can use my price based shipping extension correct?

Thanks again for your help

[abolabo]

Select 1 will turn shipping ON so I can use my price based shipping extension correct?

1 means that your product requires shipping.

[thomasaswain]

Where do I access the coding section to key this?

[abolabo]

phpmyadmin

[thomasaswain]

On the admin page, where should I go? System then to one of the sub-fields?

[abolabo]

On the admin page, where should I go? System then to one of the sub-fields?

what for? To run SQL?
No. Just use phpmyadmin to run sql query.