Недавно тоже искал вариант удаления товаров из категории. Написал простой php скрипт. Кому-то пригодится.
Ocstore 2.1
<?php
$server = "localhost";
$db = "test";
$username = "vasya";
$password = "pupkin";
//Connect to Mysql
$link = mysqli_connect($server, $username, $password, $db);
if (mysqli_connect_errno()) {
printf("ERROR $server: %s\n", mysqli_connect_error());
exit();
}
mysqli_set_charset($link, "utf8");
$q1 = mysqli_query($link,"SELECT product_id from oc_product_to_category WHERE category_id='63'");
while ($f1 = mysqli_fetch_array($q1)){
$product_id = $f1[0];
mysqli_query($link,"DELETE FROM oc_product WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_attribute WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_description WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_discount WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_filter WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_image WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_option WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_option_value WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_related WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_related WHERE related_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_reward WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_special WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_to_category WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_to_download WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_to_layout WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_to_store WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_product_recurring WHERE product_id = " . (int)$product_id);
mysqli_query($link,"DELETE FROM oc_review WHERE product_id = '" . (int)$product_id . "'");
mysqli_query($link,"DELETE FROM oc_url_alias WHERE query = 'product_id=" . (int)$product_id . "'");
}
mysqli_close($link);
?>