Подсчет должен делать opencart при выводе категорий. Я пишу загрузчик в back end.
$this->db->query("INSERT INTO " . DB_PREFIX . "product SET model = '" .$row[0]. "', sku = '" .$row[0]. "', upc = '', ean = '', jan = '', isbn = '', mpn = '', location = '', quantity = '" .$row[2]. "', minimum = '1', subtract = '0', stock_status_id = '" .$sstatus_id. "', date_available = '0', manufacturer_id = '" .$manufacturer_id. "', shipping = '1', price = '" .$product_price. "', points = '0', weight = '0.00', weight_class_id = '0', length = '0.00', width = '0.00', height = '0.00', length_class_id = '0', status = '1', tax_class_id = '0', sort_order = '100', date_added = NOW()"); $product_id = $this->db->getLastId();
$this->db->query("INSERT INTO " . DB_PREFIX . "product_description SET product_id = '".$product_id."', language_id = '".$language_id."', name = '".$row[1]."', description = '', tag = '', meta_title = '', meta_h1 = '', meta_description = '', meta_keyword = ''");
$this->db->query("INSERT INTO " . DB_PREFIX . "product_to_store SET product_id = '".$product_id."', store_id = '".$store_id."'");
$this->db->query("INSERT INTO " . DB_PREFIX . "product_to_category SET product_id = '".$product_id."', category_id = '".$category_id."', main_category = '1'");
А что пишется в таблицу oc_category_path? Подозреваю , что проблема в том что в эту таблицу ничего не пишу