AbanteCart Community

eCommerce construction => Installation and Configuration => Topic started by: thomasaswain on December 06, 2016, 02:23:26 PM

Title: SQL Statement for updating required shipping
Post by: thomasaswain on December 06, 2016, 02:23:26 PM

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!

Title: Re: SQL Statement for updating required shipping
Post by: abolabo on December 07, 2016, 04:23:09 AM

to turn off use

Code: [Select]

UPDATE `ac_products` SET `shipping`= 0;
or 1 to turn on.

Where ac_ - your tables name prefix

Title: Re: SQL Statement for updating required shipping
Post by: thomasaswain on December 07, 2016, 07:27:07 AM

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

Title: Re: SQL Statement for updating required shipping
Post by: abolabo on December 07, 2016, 08:35:53 AM

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.

Title: Re: SQL Statement for updating required shipping
Post by: thomasaswain on December 07, 2016, 02:16:44 PM

Where do I access the coding section to key this?

Title: Re: SQL Statement for updating required shipping
Post by: abolabo on December 07, 2016, 03:00:15 PM

phpmyadmin

Title: Re: SQL Statement for updating required shipping
Post by: 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?

Title: Re: SQL Statement for updating required shipping
Post by: abolabo on December 12, 2016, 12:29:52 PM

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.