}
// update existing category
$category->data['category_name'] = myTrim(convertEncoding($row['cat_name']));
$category->save();
}
$stmt->close();
}
*/
$stmt = SqlQuery::select($cube_db, 'cubecart_inventory');
if ($stmt) {
$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
$product = new Product($db);
$product->loadByExtId($row['productId']);
// import new product
if (!$product->is_loaded) {
$product->data['product_ext_id'] = $row['productId'];
$product->data['product_name'] = myTrim(convertEncoding($row['name']));
$product->data['product_price'] = parseFloat($row['price']);
$category = loadCategory($row['cat_id']);
if (isset($category)) {
$product->data['product_category_id'] = $category->ival('category_id');
}
$new++;
} else {
$updated++;
}
$product->data['product_description'] = convertEncoding($row['description']);
$product->data['product_image'] = $row['image'];
$zCategory->data['category_alias_id'] = $a->ival('alias_id');
$zCategory->save();
}
}
$categories_tree = Category::getCategoryTree($db);
/*
possibly update all stock numbers to zero here?
*/
/* produkty */
foreach ($xml->products->product as $product) {
$save_product = true;
$zVariant = null;
$prod_total += 1;
$prod_id = intval(trim($product->ean));
$zProduct = new Product($db);
$zProduct->loadByExtId($prod_id);
$price_sales = trim($product->price_sales);
$price_eus = trim($product->price_eus);
$product_price = $price_sales ? $price_sales : $price_eus;
$product_name = trim($product->name);
$product_stock = intval(trim($product->stock));
/* varianty */
if (strpos($product_name, ' var.') > 0) {
list($prodname, $variant_name) = explode(' var.', $product_name);
$product_name = trim($prodname);
$variant_name = trim($variant_name);
if (strlen($variant_name) > 0) {
$zVariant = new ProductVariant($db);
$zVariant->loadByExtId($prod_id);
if ($zVariant->is_loaded) {
$zProduct->loadById($zVariant->ival('product_variant_product_id'));
