<?xml version="1.0" encoding="utf-8"?> 
<SHOP>
  <SHOPITEM>
     <PRODUCT>Nokia 5800 XpressMusic</PRODUCT>
     <DESCRIPTION>Klasický s plným dotykovým uživatelským rozhraním</DESCRIPTION>
      <URL>http://obchod.cz/mobily/nokia-5800-xpressmusic</URL>
      <IMGURL>http://obchod.cz/mobily/nokia-5800- xpressmusic/obrazek.jpg</IMGURL>
      <PRICE>5000</PRICE>
      <PRICE_VAT>6000</PRICE_VAT>
      <VAT>0,20</VAT>
      <MANUFACTURER>NOKIA</MANUFACTURER>
           <ITEM_TYPE>new</ITEM_TYPE>
      <CATEGORYTEXT>Elektronika/Mobilní telefony</CATEGORYTEXT>
      <EAN>6417182041488</EAN>
      <DELIVERY_DATE>2</DELIVERY_DATE>
   </SHOPITEM>
   <SHOPITEM>
   ...
   </SHOPITEM>
 </SHOP>

 //category
$categories = $db->Execute("select c.categories_id,c.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " f where f.products_id = '" . (int)$product_id . "' and f.categories_id = c.categories_id AND c.language_id = '" . $_SESSION['languages_id']. "'");
$thecategory_id = $categories->fields['categories_id'];
$fullcategory = ''; // this will have the entire category stack for froogle
for( $categorylevel=1; $categorylevel<7; $categorylevel++){
if (!empty($thecategory_id)){
$sql2 = "SELECT categories_name
FROM ".TABLE_CATEGORIES_DESCRIPTION."
WHERE
categories_id = " . $thecategory_id . " AND
language_id = " . (int)$_SESSION['languages_id'] ;
$result2 = $db->Execute($sql2);
$row2 = $result2->fields['categories_name'];
// echo $row2['categories_name'];
// only set it if we found something
$temprow['v_categories_name_' . $categorylevel] = $row2['categories_name'];
// now get the parent ID if there was one
$sql3 = "SELECT parent_id
FROM ".TABLE_CATEGORIES."
WHERE
categories_id = " . $thecategory_id;
$result3 = $db->Execute($sql3);
$row3 = $result3->fields['parent_id'];
$theparent_id = $row3;
if ($theparent_id != ''){
// there was a parent ID, lets set thecategoryid to get the next level
$thecategory_id = $theparent_id;
} else {
// we have found the top level category for this item,
$thecategory_id = false;
}
//$fullcategory .= " > " . $row2['categories_name'];
$fullcategory = $row2 . " / " . $fullcategory;
} else {
$temprow['v_categories_name_' . $categorylevel] = '';
}
}
// now trim off the last ">" from the category stack
$fullcategory = substr($fullcategory,0,strlen($fullcategory)-3);
//end of category

<categorytext>  . $fullcategory . </categorytext>

$fullcategory = $row2 . " / " . $fullcategory;