Экспорт данных в Yandex Market (Яндекс Маркет). Проверено на Joomla 2.5 + JoomShopping 3.6.1 - страница 8 - Импорт-экспорт данных

<yml_catalog date="2015-06-25 17:55"><parsererror xmlns="http://www.w3.org/1999/xhtml" style="display: block; white-space: pre; border: 2px solid #c77; padding: 0 1em 0 1em; margin: 1em; background-color: #fdd; color: black"><h3>This page contains the following errors:</h3><div style="font-family:monospace;font-size:12px">error on line 21 at column 9: Extra content at the end of the document
</div><h3>Below is a rendering of the page up to the first error.</h3></parsererror>
<shop>
<name>название</name>
<company>компания</company>
<url>mysite.ru</url>
<currencies>
<currency id="RUR" rate="1"/>
<currency id="USD" rate="CBRF"/>
<currency id="EUR" rate="CBRF"/>
</currencies>
<categories>
<category id="1" parentId="6">Столы компьютерные</category>
<category id="2" parentId="6">Столы обеденные</category> 
</categories>
<offers>

{$tb_product}.delivery_times_id='2'

$query = "
		SELECT
			{$extra_select}
			{$tb_product}.product_id,
			{$tb_product}.`name_ru-RU` as product_name,
			{$tb_manufacturer}.`name_ru-RU` as mf_name,
			{$tb_manufacturer}.`manufacturer_id`,
			tmp.`category_id`,
			{$tb_product}.`product_price`, 
			{$tb_product}.`product_publish` as product_publish, 
			{$tb_product}.`product_id` as product_sku,
			{$tb_product}.`product_quantity`,
			{$tb_product}.`product_full_image` as product_full_image,
			{$tb_product}.`description_ru-RU` as product_s_desc
		FROM
			{$tb_product}	
		LEFT JOIN tmp ON {$tb_product}.product_id = tmp.product_id			
		LEFT JOIN {$tb_manufacturer}
			ON {$tb_product}.product_manufacturer_id = {$tb_manufacturer}.manufacturer_id
 
		WHERE {$tb_product}.product_publish='1' 
		GROUP BY {$tb_product}.product_id
		";

while ($row= $res->fetch(PDO::FETCH_ASSOC)) {

<?php
header ("Content-Type:text/xml");

include 'configuration.php';
$cfg = new JConfig();

$cfg_name 		= '';
$cfg_company 	= $cfg->sitename; //Полное наименование компании, владеющей магазином. Не публикуется, используется для внутренней идентификации.
$cfg_url 		= ''; //URL-адрес главной страницы магазина без http://
$bid 			= '11'; // Ставка за клик (в центах)
$currency 		= 'RUR';
$hostname 		= $cfg->host;
$username 		= $cfg->user;
$password 		= $cfg->password;
$dbName 		= $cfg->db;
$category 		= $cfg->dbprefix."jshopping_categories";
$tb_product 	= $cfg->dbprefix."jshopping_products";
$tb_product_category_xref	= $cfg->dbprefix."jshopping_products_to_categories";
$tb_product_image 			= $cfg->dbprefix."jshopping_products_images";
 
try { 
    $pdo = new PDO("mysql:host={$hostname};dbname={$dbName}", $username, $password);
	// Исправьте, если у вас другая кодировка в БД
	$pdo->exec('SET NAMES utf8');
 
	echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
	echo "<!DOCTYPE yml_catalog SYSTEM \"shops.dtd\">\n";
	echo "<yml_catalog date=\"";
	echo date('Y-m-d H:i');
	echo "\">\n";
	echo "<shop>\n";
	echo "<name>$cfg_name</name>\n";
	echo "<company>$cfg_company</company>\n";
	echo "<url>$cfg_url</url>\n";
 
	// курсы валют, приравнены к курсу ЦБРФ
	echo "<currencies>\n";
	echo "<currency  id=\"RUR\" rate=\"1\"/>\n";
	echo "</currencies>\n";
 
	// Секция категорий
	echo "<categories>\n";
		$res = $pdo->query("SELECT * FROM $category WHERE category_publish = 1"); 
		while ($row_cat= $res->fetch(PDO::FETCH_ASSOC)) {
			$cat_parent_id=$row_cat['category_parent_id'];
			$parent = ($cat_parent_id != 0)? " parentId=\"{$cat_parent_id}\"" : "";
			echo "<category id=\"{$row_cat['category_id']}\"{$parent}>{$row_cat['name_ru-RU']}</category>\n";
		}
		unset($res);
	echo"</categories>\n";
 
	// Секция описания товаров
	echo"<offers>\n";
 
 
	$res = $pdo->query("SELECT id, `name_ru-RU` as name FROM {$cfg->dbprefix}jshopping_products_extra_fields"); 
	
	$extra_select = '';
	$extra_info = $res->fetchAll(PDO::FETCH_ASSOC);
	
	if($extra_info){
		foreach($extra_info as $ei){
			$extra_select .= "{$tb_product}.extra_field_{$ei['id']},";
		}
	}
	$query = "
		SELECT
			{$extra_select}
			{$tb_product}.product_id,
			{$tb_product}.`name_ru-RU` as product_name,
			{$tb_product}.`product_price`, 
			{$tb_product}.`product_id` as product_sku,
			{$tb_product}.`product_quantity`,
			(SELECT image_name FROM {$tb_product_image} as pi WHERE pi.product_id = {$tb_product}.product_id ORDER BY ordering LIMIT 0,1) as product_full_image, 
			{$category}.category_id,
			{$category}.category_publish,
			{$tb_product}.`short_description_ru-RU` as product_s_desc
		FROM
			{$tb_product}	
		LEFT JOIN 
			{$category} ON 
			{$category}.category_id = (SELECT category_id FROM {$tb_product_category_xref} WHERE {$tb_product_category_xref}.product_id = {$tb_product}.product_id LIMIT 0,1)
			
		WHERE {$tb_product}.product_publish='1' AND category_publish = 1
		GROUP BY {$tb_product}.product_id
		";

	$product_log = Array();
	$res = $pdo->query($query); 
	while ($row= $res->fetch(PDO::FETCH_ASSOC)) {
		if (!in_array($row['product_id'],$product_log) && ($row['product_price']) && $row['product_price'] > 0) {	
			$product_log[] = $row['product_id'];
			$product_price = substr($row['product_price'], 0, -3);
			echo "\n<offer id=\"".$row['product_id']."\" available=\"true\" bid=\"$bid\">\n";
			echo "<url>http://$cfg_url/component/jshopping/product/view/{$row['category_id']}/{$row['product_id']}</url>\n";
			echo "<price>$product_price</price>\n";
			// Валюта в которой указаны Ваши цены
			echo "<currencyId>".$currency."</currencyId>\n";
			echo "<categoryId>".$row['category_id']."</categoryId>\n";
 
			if(!empty($row['product_full_image'])) {
				echo "<picture>http://$cfg_url/components/com_jshopping/files/img_products/{$row['product_full_image']}</picture>\n";
			}
 
			// Возможность доставки
			echo "<delivery>true</delivery> \n";
			echo "<name>".$row['product_name']."</name>\n";
			// echo "<description>".htmlspecialchars(strip_tags($row['product_s_desc']))."</description>\n";

			if($extra_info){
				foreach($extra_info as $ei){
					if($row['extra_field_'.$ei['id']])
						echo "<param name=\"{$ei['name']}\">".htmlspecialchars($row['extra_field_'.$ei['id']])."</param>\n";
				}
			}
			
			echo "</offer>\n";
		}
	}
 
 
	echo"</offers>\n";
	echo"</shop>\n";
	echo"</yml_catalog>\n";
 
} catch (Exception $e) { 
    echo $e->getMessage(); 
}
 
?>

<offers>
<offer id="23" available="true" bid="11">
<url>
http://site.com/component/jshopping/product/view/17/23
</url>
<price>75299.000</price>
<currencyId>UAH</currencyId>
<categoryId>17</categoryId>
<picture>
http://site.com/components/com_jshopping/files/img_products/CSVE9NKE-600x600.png
</picture>
<delivery>true</delivery>
<name>Кондиционер Panasonic CS-VE9NKE / CU-VE9NKE</name>
<param name="Класс">1</param>
<param name="Площадь помещения (кв.м.)">2</param>
<param name="Мощность охлаждения (кВт.)">3</param>
<param name="Мощность обогрева (кВт)">4</param>
<param name="Инверторное управление">5</param>
<param name="Потребляемая мощность (кВт)">0,51</param>
<param name="Тип хладагента">7</param>
<param name="Размеры внутреннего блока">870x290x214</param>
<param name="Размеры наружного блока">780x542x289</param>
<param name="Минимальный уровень шума внутреннего блока (ДБ)">20</param>
<param name="Наличие и типы фильтров">8</param>
<param name="Антибактериальное поктытие">9</param>
<param name="Цвет">11</param>
<param name="Дополнительные опции">12</param>
<param name="Гарантия (мес.)">15</param>
<param name="Страна производитель">19</param>
</offer>