Show only single category posts on WordPress archive page

/in /by

To display only a single category’s posts on a WordPress archive page, you can modify your theme’s functions.php file or create a custom template. The best approach is to use the pre_get_posts hook, which allows you to filter the query before WordPress retrieves posts. Here’s an optimized way to do it:

function filter_archive_by_category( $query ) {
if ( !is_admin() && $query->is_archive() && $query->is_main_query() ) {
$query->set( 'cat', 12 ); // Replace 12 with your category ID
}
}
add_action( 'pre_get_posts', 'filter_archive_by_category' );

This snippet ensures that only posts from a specific category appear on archive pages while maintaining performance and compatibility. You can replace the category ID (12) with the desired category’s ID, which can be found in the WordPress admin panel under Posts > Categories. This method is ideal for keeping your theme lightweight and SEO-friendly without modifying core files.

Magento2 admin account disabled error

/in , /by

Magento2 admin account disabled error:

Hello All,

If you get issue something below on the Magento2 login page

 

 

Simply below query to database via phpmyadmin.

Example is for reset password for admin user.

UPDATE admin_user SET password = CONCAT(SHA2(‘xxxxxxxxNewPassword’, 256), ‘:xxxxxxxx:1’) WHERE username = ‘admin’;

NewPassword : Replace it with your password.

 

Hope it will work.

Get Magento catalog image

/in , , /by

Today  I will show you how you can get the magento catalog image via code on any page. Please use below code and you will be done!!

 

Mage::helper('catalog/image')->init($product, 'thumbnail')->resize(100);

Exclude a category id from category collection in Magento

/in , , /by

Please use the below code for exclude a category id from category collection in Magento

<?php
      $allCategories = Mage::getModel('catalog/category')
                       ->getCollection()
                       ->addAttributeToSelect('*')
                       ->addAttributeToFilter('level',2)
                       ->addAttributeToFilter('entity_id', array('nin' => 69))
                       ->addIsActiveFilter(); 

?>

Get Categories and Its Sub Categories in Magento

/in , , /by

Get Categories and Its Sub Categories in Magento:

To retrieve categories and their subcategories in Magento, you can use Magento’s built-in repository classes and helper functions. Using the Magento\Catalog\Model\CategoryRepository and Magento\Catalog\Model\ResourceModel\Category\CollectionFactory, you can efficiently fetch category data, including subcategories, in a structured way. Here’s a basic approach:

use Magento\Catalog\Model\ResourceModel\Category\CollectionFactory;
use Magento\Framework\App\State;

class CategoryHelper
{
protected $categoryCollectionFactory;

public function __construct(
CollectionFactory $categoryCollectionFactory,
State $state
) {
$this->categoryCollectionFactory = $categoryCollectionFactory;
$state->setAreaCode('frontend'); // Required if running in non-frontend context
}

public function getCategoriesWithSubcategories()
{
$categories = $this->categoryCollectionFactory->create()
->addAttributeToSelect(['name', 'is_active'])
->addAttributeToFilter('is_active', 1)
->setOrder('position', 'ASC');

$categoryData = [];
foreach ($categories as $category) {
if ($category->getParentId() == 2) { // Root category check
$subCategories = [];
foreach ($categories as $subCategory) {
if ($subCategory->getParentId() == $category->getId()) {
$subCategories[] = ['id' => $subCategory->getId(), 'name' => $subCategory->getName()];
}
}
$categoryData[] = [
'id' => $category->getId(),
'name' => $category->getName(),
'subcategories' => $subCategories
];
}
}
return $categoryData;
}
}

This method ensures that only active categories are retrieved, sorted in the desired order, and structured to include their subcategories efficiently. This approach is optimal for displaying category navigation menus, filters, or hierarchical category structures in Magento stores.