So I want to run a query that add a bunch of product using SKU number (comma separated) into a specific category ID number 21.
How do i do that? I know how to move them before category using this query. I like to know how to use the comma separated sku in the query, to move them into a category.
INSERT INTO catalog_category_product( category_id, product_id, position ) ( SELECT 652 , product_id, position FROM catalog_category_product WHERE category_id IN ( 650 ) ) ON DUPLICATE KEY UPDATE category_id = 652
Any help would be appreciate it.