How to Programmatically Export CSV File Category Name with Parent Category Name

 

<?php

use Magento\MediaStorage\Helper\File\Storage\Database;

use Magento\Framework\AppInterface;


try

{

    require_once __DIR__ . '/app/bootstrap.php';

}

catch (\Exception $e)

{

    echo 'Autoload error: ' . $e->getMessage();

    exit(1);

}

try

{

    header("Content-type: text/csv");

    header("Content-Disposition: attachment; filename=category_level.csv");

    header("Pragma: no-cache");

    header("Expires: 0");


    $bootstrap = \Magento\Framework\App\Bootstrap::create(BP, $_SERVER);

    $objectManager = $bootstrap->getObjectManager();

    $appState = $objectManager->get('\Magento\Framework\App\State');

    $appState->setAreaCode('frontend');

   

    $categoryData = [];

    $rootCategoryId = 2; //Pass Root Category Id

    $categoryManagement = $objectManager->get('Magento\Catalog\Api\CategoryManagementInterface');

    $getSubCategory = getCategoryData($categoryManagement, $rootCategoryId);


    foreach ($getSubCategory->getChildrenData() as $category) {

        $cat = $category->getName();

        $categoryData[$category->getId()] = [

            'name' => $category->getName(),

            'url' => $category->getUrl()

        ];


        if (count($category->getChildrenData())) {

            $getSubCategoryLevelDown = getCategoryData($categoryManagement, $category->getId());

            foreach ($getSubCategoryLevelDown->getChildrenData() as $subcategorylist1) {

                $cat1 = $cat . ',' . $subcategorylist1->getName();

                $categoryData[$subcategorylist1->getId()] = [

                    'name' => $cat . ',' . $subcategorylist1->getName(),

                    'url' => $subcategorylist1->getUrl()

                ];

                if (count($subcategorylist1->getChildrenData())) {

                    $getSubCategoryLevelDownl = getCategoryData($categoryManagement, $subcategorylist1->getId());

                    foreach ($getSubCategoryLevelDownl->getChildrenData() as $subcategorylist2) {

                        $cat2 = $cat1 . ',' . $subcategorylist2->getName();

                        $categoryData[$subcategorylist2->getId()] = [

                            'name' => $cat1 . ',' . $subcategorylist2->getName(),

                            'url' => $subcategorylist2->getUrl()

                        ];

                        if (count($subcategorylist2->getChildrenData())) {

                            $getSubCategoryLevelDownl = getCategoryData($categoryManagement, $subcategorylist2->getId());

                            foreach ($getSubCategoryLevelDownl->getChildrenData() as $subcategorylist3) {

                                $cat3 = $cat2 . ',' . $subcategorylist3->getName();

                                $categoryData[$subcategorylist3->getId()] = [

                                    'name' => $cat2 . ',' . $subcategorylist3->getName(),

                                    'url' => $subcategorylist2->getUrl()

                                ];

                            }

                        }

                    }

                }

            }

        }

    }

    

    $output = fopen('php://output', 'w');

    fputcsv($output, array('Id', 'Level 1', 'Level 2', 'Level 3', 'Level 4'));

    foreach ($categoryData as $datak => $datav) {

        $catLevel = $datak . ',' . $datav['name'];

        $catLevel = explode(',', $catLevel);

        fputcsv($output, $catLevel);

    }


    fclose($output);

    exit;

}

catch(\Exception $e)

{

    print_r($e->getMessage());

}

function getCategoryData($categoryManagement, $categoryId)

{

    try {

        $getSubCategory = $categoryManagement->getTree($categoryId);

    } catch (Exception $exception) {

        $getSubCategory = null;

    }

    return $getSubCategory;

}

Comments

Post a Comment

Popular posts from this blog

Add Admin User name and Action name in Order Comment Section through Action Performed from Sales Order Grid in Magento 2

  Step 1:  First, we need to create an “events.xml“ file inside our extension at the following path app\code\Vendor\Extension\etc\adminhtml\ Then add the code as follows. <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events.xsd">     <event name="sales_order_save_after">         <observer name="sales_order_save_after_comment_history_add"           instance="\Vendor\Extension\Observer\OrderSaveAfter" />     </event> </config> Step 2:  After that, we need to create an “OrderSaveAfter.php” file inside our extension at the following path app\code\Vendor\Extension\Observer\ And embed the code as given below. <?php  namespace Vendor\Extension\Observer;   use Magento\Framework\Event\ObserverInterface; use Magento\Framework\App\RequestInterface; use Magento\Backen...
Read more

How to Update Product Stock Programmatically in Magento 2

 Steps to Update Product Stock Programmatically in Magento 2: Step 1: We need to create a “Data.php” file inside our extension at the following path app\code\Vendor\Extension\Helper\ Now add the code as follows <?php namespace Vendor\Extension\Helper;   class Data extends \Magento\Framework\App\Helper\AbstractHelper {     protected $_productobj;     protected $_stockRegistry;       public function __construct(         \Magento\Framework\App\Helper\Context $context,         \Magento\Catalog\Model\Product $productobj,         \Magento\CatalogInventory\Api\StockRegistryInterface $stockRegistry,      ) {         $this->_productobj = $productobj;         $this->_stockRegistry = $stockRegistry;         parent::__construct($context);     }       public function updateProductStock($pr...
Read more

How to Set and Get Cookie in Magento 2

 <?php namespace Vendor\Extension\Model; class Customcookie {     private $customCookieManager;     private $customCookieMetadataFactory;     public function __construct(         \Magento\Framework\Stdlib\CookieManagerInterface $customCookieManager,         \Magento\Framework\Stdlib\Cookie\CookieMetadataFactory $customCookieMetadataFactory)    {         $this->customCookieManager = $customCookieManager;         $this->customCookieMetadataFactory = $customCookieMetadataFactory;     }     public function setCookie()     {         $customCookieMetadata = $this->customCookieMetadataFactory->createPublicCookieMetadata();         $customCookieMetadata->setDurationOneYear();         $customCookieMetadata->setPath('/');         $customCookieMe...
Read more