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!
to turn off use
UPDATE `ac_products` SET `shipping`= 0;
or 1 to turn on.
Where ac_ - your tables name prefix
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
Quote from: thomasaswain on December 07, 2016, 07:27:07 AM
Select 1 will turn shipping ON so I can use my price based shipping extension correct?
1 means that your product requires shipping.
Where do I access the coding section to key this?
phpmyadmin
On the admin page, where should I go? System then to one of the sub-fields?
Quote from: thomasaswain on December 12, 2016, 09:40:43 AM
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.