Как экспортировать продукт csv с полным url продукта

Я хочу экспортировать CSV-файл продукта с полным url-адресом продукта, включая базовый url (я не хочу делать это вручную).

Можно ли настроить код так, чтобы экспорт продукта имел полный url-адрес?

2 2
csv export magento

2 ответа:

<?php

// Load the Magento core

require_once 'app/Mage.php';
umask(0);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
$userModel = Mage::getModel('admin/user');
$userModel->setUserId(0);

// Load the product collection

$collection = Mage::getModel('catalog/product')
 ->getCollection()
 ->addAttributeToSelect('*') //Select everything from the table
 ->addUrlRewrite(); //Generate nice URLs

/*
 For this example I am generating a CSV file,
 but you can change this to suit your needs.
*/

echo "title,sku,id,url\n" ."<br>";

foreach($collection as $product) {
 //Load the product categories
 $categories = $product->getCategoryIds();
 //Select the last category in the list
 $categoryId = end($categories);
 //Load that category
 $category = Mage::getModel('catalog/category')->load($categoryId);

 echo '"'.$product->getTitle().'","'.
  $product->getSku().'",'.
  $product->getId().',"'.
  //This will the proper URL, the base url is optional, though make sure you remove the trailing export.php (or whatever you name this file)
  str_replace('export.php/','',Mage::getBaseUrl()).$product->getUrlPath($category).'"'.
  "\n" ."<br>";
}


?>
4
Create export.csv on root ..write a code to export csv the new thing is that you have to hardcode base url in the path of the product..

for example ..existing path category/product/

base url/category/product/

But remember to keep the code correct..
1