Disable Magento Category from the Database

Disable Magento Category from the Database

August 23, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Disable Magento Category from the Database

Disable Magento Category Programmatically: A Step-by-Step Guide

If you’re looking to enable or disable categories programmatically in your Magento store, you’ve come to the right place. In this post, we’ll guide you through the process of creating a cron job that actively manages your category visibility based on your business needs.

Understanding Magento Category Management

In Magento, each category has an attribute called is_active. This Boolean value determines whether the category is visible in the frontend or not. By default, it’s set to true for all categories during installation.

To find out why you couldn’t locate this information in the database, let’s take a closer look at the relevant tables:

  • catalog_category_entity: Stores basic category data, including entity_id (unique identifier) and is_active.
  • catalog_category_entity_int: Contains additional integer values for various attributes.
  • catalog_category_entity_varchar: Stores string-based category attributes.

The is_active column is located directly in the catalog_category_entity table. However, it’s important to note that Magento uses a complex data structure to store and retrieve categories efficiently.

Disabling a Category via the Database

To disable a specific category, you simply need to update this field to 0 (false). Here’s an example SQL query:

UPDATE catalog_category_entity SET is_active = 0 WHERE entity_id = <CATEGORY_ID>;

Replace <CATEGORY_ID> with the actual ID of the category you want to disable.

Note: Be extremely careful when running direct SQL queries on your live database. Always backup your data first and test changes in a development environment before applying them to production.

Creating an Automatic Category Management Script

Now, let’s create a script that can be scheduled as a cron job to periodically activate new categories and disable obsolete ones based on predefined rules.

Here’s a basic PHP script that demonstrates this process:

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

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

/** @var Magento\Framework\App\ResourceConnection $resource */
$resource = $objectManager->get('Magento\Framework\App\ResourceConnection');
$connection = $resource->getConnection();

$currentDate = date('Y-m-d H:i:s');

/* Disabling old categories (example: 30 days since last update) */
$disableQuery = "
UPDATE catalog_category_entity
SET is_active = 0
WHERE updated_at < DATE_SUB(?, INTERVAL 30 DAY)";
$connection->query($disableQuery, [$currentDate]);

/* Activating new categories (example: created today) */
$enableQuery = "
UPDATE catalog_category_entity
SET is_active = 1
WHERE created_at >= ?";
$connection->query($enableQuery, [$currentDate]);

This script first disables all categories that haven’t been updated in the last 30 days and then activates any new categories created on the current day.

Scheduling Your Script

To schedule this script as a cron job, follow these steps:

  1. Upload the PHP file to your server (e.g., magentocron.php).
  2. Open your server’s crontab file using your preferred text editor.
  3. Add a new line with the following command (assuming you want it to run daily at 3 AM):
0 3 * * * php /path/to/your/php/interpreter magento cron:run > /dev/null

Replace /path/to/your/php/interpreter with the actual path to your PHP interpreter.

  1. Save and close the file.
  2. Verify that the script is running correctly by checking your server logs or the database changes after 3 AM each day.

Conclusion

Programmatically managing category visibility in Magento allows you to automate important tasks like activating promotional categories during sales events or removing seasonal categories when they’re no longer relevant.

Remember, while this example demonstrates a basic approach, you should always customize it according to your specific business rules and test thoroughly before deploying. For more advanced Magento development insights and tutorials, be sure to check out our blog at https://laravelcompany.com.

Happy coding!

Catalog Database Cron Import/Export

Our network