How to bulk replace the SKU of Opencart products?

Question

SQL

There is a task to replace the SKU of products in a certain category. There are more than 1000 such products on the search. Handles sorting through everything is a dreary business. How to speed up the process? Maybe there is some query in the database or some module?

Answer 1

UPDATE товаров SET SKU = заменить WHERE категории = определенной

Answer 2

1) Get a list of product ids of the desired category:
SELECT `product_id` FROM `oc_product_to_category` WHERE `category_id` = '1111'
2) Next
UPDATE `oc_product` SET `sku` = '2222' WHERE `product_id` = '$id'