Orsdxy

I have one custom table, that table have a column name category which contains the events category like entertainment, national events. Now I need to create category from the table?

note: create category itself enough, don't need to add any products.

I tried with create one category by object manager if the category not exist but it does not work.

    $parentCategory = $this->_objectManager

         ->create('MagentoCatalogModelCategory')

         ->load('115');

    $category = $this->_objectManager

         ->create('MagentoCatalogModelCategory');

    $cate=$category->getCollection()->addAttributeToFilter('name',$d["type"])

    ->getFirstItem();

    if(!isset($cate))

    {

    $category->setPath($parentCategory->getPath())

    ->setParentId('115')

    ->setName($d["type"])

    ->setIsActive(true);

    $category->save();

    }

how to deal with automatically create category from table, if not exist already.

Thanks

We need to identify the id of category tree root. Then, we
created an instance of the category, set its path, parent_id, name, etc.

/**

 * Id of category tree root

 */

$parentId = MagentoCatalogModelCategory::TREE_ROOT_ID;



$parentCategory = $this->_objectManager

                      ->create('MagentoCatalogModelCategory')

                      ->load($parentId);

$category = $this->_objectManager

                ->create('MagentoCatalogModelCategory');

//Check exist category

$cate = $category->getCollection()

            ->addAttributeToFilter('name','test')

            ->getFirstItem();



if(!isset($cate->getId())) {

    $category->setPath($parentCategory->getPath())

        ->setParentId($parentId)

        ->setName('test')

        ->setIsActive(true);

    $category->save();

}

it will help me to add create category programaticaly.

// catagory name

$cat_name = ucfirst($cat_val);

$site_url = strtolower($cat_val);

$clean_url = trim(preg_replace('/ +/', '', preg_replace('/[^A-Za-z0-9 ]/', '', urldecode(html_entity_decode(strip_tags($site_url))))));

$category_factory=$objectManager->get('MagentoCatalogModelCategoryFactory');

// Add a new sub category under root category

$category_obj = $category_factory->create();

$category_obj->setName($cat_name);

$category_obj->setIsActive(true);

$category_obj->setUrlKey($clean_url);

$category_obj->setData('description', 'description');

$category_obj->setParentId($root_cat_id->getId());

$mediaAttribute = array ('image', 'small_image', 'thumbnail');

$category_obj->setImage('/catagory_img.png', $mediaAttribute, true, false);

// add image at Path of  pub/meida/catalog/category/catagory_img.png

// add store id 

$category_obj->setStoreId($store_Id);

$category_obj->setPath($root_cat_id->getPath());

// save category

$category_obj->save();

Consider using the Factory pattern for this instead of the object manager (unless you're putting this function in a factory class itself)

class MyClass 

{



    protected $storeManager;



    protected $categoryFactory;



    public function __construct(

        MagentoStoreModelStoreManagerInterface $storeManager,

        MagentoCatalogModelCategoryFactory $categoryFactory

    ) {

        $this->storeManager = $storeManager;

        $this->categoryFactory = $categoryFactory;

    }



    public function fetchOrCreateProductCategory($categoryName)

    {

        // get the current stores root category

        $parentId = $this->storeManager->getStore()->getRootCategoryId();



        $parentCategory = $this->categoryFactory->create()->load($parentId);



        $category = $this->categoryFactory->create();

        $cate = $category->getCollection()

            ->addAttributeToFilter('name', $categoryName)

            ->getFirstItem();



        if (!$cate->getId()) {

            $category->setPath($parentCategory->getPath())

                ->setParentId($parentId)

                ->setName($categoryName)

                ->setIsActive(true);

            $category->save();

        }



        return $category;

    }

When working with names I think it's better to use like

//Check exist category

$cate = $category->getCollection()

            ->addAttributeToFilter('name',['like' => $value])

            ->getFirstItem();

    $categories = array(



array(



'name' => 'Homedfd Appliances fsdfsdfd',



'parent' => 97,



'child' => array(



'Television',



'AC & Coolers',



'Refrigerator',



'Microwave Oven',



'Fans', 'Kitchen Appliances',



'Other Appliances' )



),



array(



'name' => 'Compudfdter dsfd',



'parent' => 97,



'child' => array(



'Monitor',



'Hard Drive',



'Printer',



'Wireless & Networking',



'Webcams',



'Keyboard',



'Mouse'



)



),



array(



'name' => 'Groomsfding Products',



'parent' => 97,



'child' => array(



'Trimmers & Shavers',



'Hair Styling Tools'



)



),



array(



'name' => 'Moddbile & Tabs',



'parent' => 97,



'child' => array()



)



);

/** Calling to magento functionalities*/use MagentoFrameworkAppBootstrap;include('./app/bootstrap.php');

$bootstrap = Bootstrap::create(BP, $_SERVER);

$objectManager = $bootstrap->getObjectManager();

$url = MagentoFrameworkAppObjectManager::getInstance();

$storeManager = $url->get('MagentoStoreModelStoreManagerInterface');

$mediaurl = $storeManager->getStore()->getBaseUrl(MagentoFrameworkUrlInterface::URL_TYPE_MEDIA);

$state = $objectManager->get('MagentoFrameworkAppState');



$state->setAreaCode('frontend');

$websiteId = $storeManager->getWebsite()->getWebsiteId();

$store = $storeManager->getStore();

$storeId =  $store->getStoreId();

$rootNodeId = $store->getRootCategoryId();

$categoryModel = $objectManager->get('MagentoCatalogModelCategory');

$rootCategoryInfo = $categoryModel->load($rootNodeId);

$outputFile = fopen('catCreateResult.txt', 'w');

foreach($categories as $cat){

     $name=ucfirst($cat['name']); 

     $url=strtolower($cat['name']); 

     $cleanurl = trim(preg_replace('/ +/', '', preg_replace('/[^A-Za-z0-9 ]/', '', urldecode(html_entity_decode(strip_tags($url)))))); 

     $categoryFactory = $objectManager->get('MagentoCatalogModelCategoryFactory'); 

     /// Add a new sub category under root category 

     $categoryTmp = $categoryFactory->create(); 

     $categoryTmp->setName($name); 

     $categoryTmp->setIsActive(true); 

   /* * If you want to include category description please ucomment below line 

   * As well as include a key with description value in category array and provide it on here. 

   */

    //$categoryTmp->setData('description', 'description'); 

     $categoryTmp->setParentId($cat['parent']); 

     $mediaAttribute = array ('image', 'small_image', 'thumbnail');

     /* * You can also set an category image. */

     //$categoryTmp->setImage('/m2.png', $mediaAttribute, true, false);

     // Path pub/meida/catalog/category/m2.png $categoryTmp->setStoreId($storeId); 

     $parentCategoryInfo = $categoryModel->load($cat['parent']); 

     $categoryTmp->setPath($parentCategoryInfo->getPath()); 

     $output = $categoryTmp->save(); 

     $newId = $output->getEntityId(); 

     if(count($cat['child']) > 0){ 

        foreach($cat['child'] as $sub_child){ 

        $name=ucfirst($sub_child); 

        $categoryFactory = $objectManager->get('MagentoCatalogModelCategoryFactory'); 

        $categoryTmp = $categoryFactory->create(); 

        $categoryTmp->setName($name); 

        $categoryTmp->setIsActive(true); 

        $categoryTmp->setParentId($newId); 

        $mediaAttribute = array ('image', 'small_image', 'thumbnail'); 

        //$categoryTmp->setImage('/m2.png', $mediaAttribute, true, false);   // Path pub/meida/catalog/category/m2.png 

        $categoryTmp->setStoreId($storeId); 

        $parentCategoryInfo = $categoryModel->load($newId); 

        $categoryTmp->setPath($parentCategoryInfo->getPath()); 

        $categoryTmp->save(); 

       } 

    }

}

For More Description you may visit here.