$ean_found++;
$pdata = $class_ean->getProductArticle($products_ean);
$products_id = $pdata['products_id'];
$articles_id = $pdata['articles_id'];
if ($products_id > 0) {
$ean_match++;
$sp_products_id = '';
$sp_articles_id = $columns[translateExcelColumnToArrayColumn($col_location['sp_articles_id'])];
$sp_stock = $columns[translateExcelColumnToArrayColumn($col_location['sp_stock'])];
$sp_open_orders = $columns[translateExcelColumnToArrayColumn($col_location['sp_open_orders'])];
$sp_ordered = $columns[translateExcelColumnToArrayColumn($col_location['sp_ordered'])];
$sp_delivered = $columns[translateExcelColumnToArrayColumn($col_location['sp_delivered'])];
$sp_canceled = $columns[translateExcelColumnToArrayColumn($col_location['sp_canceled'])];
$sp_sales = $columns[translateExcelColumnToArrayColumn($col_location['sp_sales'])];
$sp_returned = $columns[translateExcelColumnToArrayColumn($col_location['sp_returned'])];
$class_jc->importDataAdd($jng_sp_id, $products_ean, $products_id, $articles_id, $sp_products_id, $sp_articles_id, $sp_stock, $sp_open_orders, $sp_ordered, $sp_delivered, $sp_canceled, $sp_sales, $sp_returned);
}
}
}
}
$class_jd->updateDownloadImported($download_id);
$messagebox->add('Uploaded file "' . $file['name'] . '" is successfully Imported! ' . $ean_found . ' EAN found, ' . $ean_match . ' imported.', 'green');
} else {
$messagebox->add('Uploaded file "' . $file['name'] . '" contains no retrievable data!');
}
}
}
}
if (isset($_POST['me_action'])) {
if ($_POST['me_action'] == 'SETASNMANUAL') {
$spid = tep_db_prepare_input($_POST['spid']);
