How to change product data in Opencart at once?

Question

opencart

Hello, in opencart, when you open a product (admin panel) there is a data tab. And there is a checkbox - "Delivery required" and answer options yes no. In general, there are more than 400 product pages. Some have it and some don't. How can I set the property for this YES checkbox to all at once. For there are a lot of goods, manually is not an option

Answer 1

UPDATE oc_product SET shipping = 1

Answer 2

Enter the database through pykhmayadmin, find this property in the table and change it for everyone at once