Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

SQL Statement for updating required shipping

Started by thomasaswain, December 06, 2016, 02:23:26 PM

Previous topic - Next topic

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

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.

thomasaswain

Where do I access the coding section to key this?

abolabo


thomasaswain

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

abolabo

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.

Forum Rules Code of conduct
AbanteCart.com 2010 -