} // 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'));