create category programmatically if not exist - magento 2

Question

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('Magento\Catalog\Model\Category')
         ->load('115');
    $category = $this->_objectManager
         ->create('Magento\Catalog\Model\Category');
    $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

Answer 1

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 = \Magento\Catalog\Model\Category::TREE_ROOT_ID;

$parentCategory = $this->_objectManager
                      ->create('Magento\Catalog\Model\Category')
                      ->load($parentId);
$category = $this->_objectManager
                ->create('Magento\Catalog\Model\Category');
//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();
}

Answer 2

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(
        \Magento\Store\Model\StoreManagerInterface $storeManager,
        \Magento\Catalog\Model\CategoryFactory $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;
    }

Answer 3

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('\Magento\Catalog\Model\CategoryFactory');
// 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();

Answer 4

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

//Check exist category
$cate = $category->getCollection()
            ->addAttributeToFilter('name',['like' => $value])
            ->getFirstItem();

Answer 5

    $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 \Magento\Framework\App\Bootstrap;include('./app/bootstrap.php');
$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();
$url = \Magento\Framework\App\ObjectManager::getInstance();
$storeManager = $url->get('\Magento\Store\Model\StoreManagerInterface');
$mediaurl = $storeManager->getStore()->getBaseUrl(\Magento\Framework\UrlInterface::URL_TYPE_MEDIA);
$state = $objectManager->get('\Magento\Framework\App\State');

$state->setAreaCode('frontend');
$websiteId = $storeManager->getWebsite()->getWebsiteId();
$store = $storeManager->getStore();
$storeId =  $store->getStoreId();
$rootNodeId = $store->getRootCategoryId();
$categoryModel = $objectManager->get('Magento\Catalog\Model\Category');
$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('\Magento\Catalog\Model\CategoryFactory'); 
     /// 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('\Magento\Catalog\Model\CategoryFactory'); 
        $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.