Вариант двумя запросами (в примере всем товарам прописывается опция 12)
INSERT INTO `oc_product_option` (`product_id`, `option_id`, `required`)
SELECT `product_id`, o.`option_id`, 1
FROM `oc_product` p, `oc_option` o, `oc_option_value` ov
WHERE o.`option_id` = ov.`option_id` AND o.`option_id` = 12;
INSERT INTO `oc_product_option_value`
(`product_option_id`, `product_id`, `option_id`, `option_value_id`,
`quantity`, `subtract`,
`price`, `price_prefix`,
`points`, `points_prefix`,
`weight`, `weight_prefix`)
SELECT
`product_option_id`, `product_id`, `option_id`, `option_value_id`,
1 `quantity`, 1 `subtract`,
0 `price`, '+' `price_prefix`,
0 `points`, '+' `points_prefix`,
0 `weight`, '+' `weight_prefix`
FROM `oc_product_option`
JOIN `oc_option_value` USING (`option_id`)
WHERE `option_id` = 12;