FROM `' . _DB_PREFIX_ . 'ebay_category` ');
if (!is_array($ref_cats) || !count($ref_cats)) {
return;
}
foreach ($ref_cats as $cat) {
$ref_categories[$cat['id_category_ref']] = $cat['id_ebay_category'];
}
$i = 0;
$sql = 'REPLACE INTO `' . _DB_PREFIX_ . 'ebay_category_configuration` (`id_country`, `id_ebay_category`, `id_category`, `percent`, `date_add`, `date_upd`) VALUES ';
if (is_array($category_list) && count($category_list)) {
/* while categoryList */
foreach ($category_list as $category) {
if (!isset($category_config_list[$category['id_category']]) || !$category_config_list[$category['id_category']]['id_ebay_category']) {
if (isset($product_test[$category['id_category']]) && !empty($product_test[$category['id_category']])) {
echo $category['id_category'] . '$';
$id_category_ref_suggested = $ebay_request->getSuggestedCategory($category['name'] . ' ' . $product_test[$category['id_category']]['name']);
$id_ebay_category_suggested = isset($ref_categories[$id_category_ref_suggested]) ? $ref_categories[$id_category_ref_suggested] : 1;
if ((int) $id_ebay_category_suggested > 0) {
if ($i) {
$sql .= ', ';
}
$sql .= '(8, ' . (int) $id_ebay_category_suggested . ', ' . (int) $category['id_category'] . ', 0, NOW(), NOW()) ';
$i++;
}
}
}
}
if ($i) {
Db::getInstance()->execute($sql);
}
echo $ebay->l('Settings updated');
