Hello!
I have the script below for exporting product xml feed for magento 1.9.2
The problem is that I cannot export the category path for each product
The scipt is:
<?php require 'app/Mage.php'; Mage::app(); $storename = 'default'; $file = "products.xml"; if (file_exists($file)) { unlink($file); } try { $products = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('*') ->setPageSize(20) ->setCurPage(1) ->setOrder('id', 'ASC') ->addAttributeToFilter('status', array('eq' => '1')); $doc = new DOMDocument(); $doc->encoding = 'utf-8'; $doc->formatOutput = true; $root = $doc->createElement("root"); $doc->appendChild($root); $productsX = $doc->createElement("catalog"); $root->appendChild($productsX); foreach ($products as $_product) { $product = $doc->createElement("product"); $id = $doc->createElement("id"); $id->appendChild( $doc->createTextNode($_product->getId()) ); $product->appendChild($id); $url = $doc->createElement("url"); $url->appendChild( $doc->createTextNode(trim($_product->getData('url_key'))) ); $product->appendChild($imageURL); $imageURL = $doc->createElement("image"); $imageURL->appendChild( $doc->createTextNode($_product->getImageURL()) ); $product->appendChild($url); $urlPath = $doc->createElement("url_path"); $urlPath->appendChild( $doc->createTextNode(trim($_product->getProductUrl())) ); $product->appendChild($urlPath); $title = $doc->createElement("title"); $title->appendChild( $doc->createTextNode(trim($_product->getName())) ); $product->appendChild($short_description); $short_description = $doc->createElement("description"); $short_description->appendChild( $doc->createTextNode(trim($_product->getShort_description())) ); $product->appendChild($title); $sku = $doc->createElement("sku"); $sku->appendChild( $doc->createTextNode($_product->getSku()) ); $product->appendChild($category); $category = $doc->createElement("category"); $category->appendChild( $doc->createTextNode(trim($_product->getCategoryName())) ); $product->appendChild($sku); $formatedpriceprice = $doc->createElement("price"); $formatedpriceprice->appendChild( $doc->createTextNode(trim((int)$_product->getFormattedPrice())) ); $product->appendChild($price); $formatedprice = $doc->createElement("price_with_vat"); $formattedPrice = Mage::helper('core')->currency($_product->getPrice(), true, false); $formatedprice->appendChild( $doc->createTextNode(trim($formattedPrice)) ); $product->appendChild($formatedprice); $productsX->appendChild($product); } file_put_contents($file, $doc->saveXML(), FILE_APPEND); } catch (Exception $e) { echo 'Eroror : - '; echo $e->getMessage(); }
Debug the code that, into your script do you get the category path of the product or not.