Mass update simple product "status" via MySQL query

Mass update simple product "status" via MySQL query

July 1, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Mass update simple product "status" via MySQL query

Automatically Enabling Mass Imported Products in Magento

Mass updating product status after an import can be a tedious task that eats into your productivity time. In this post, we’ll explore how to quickly enable all imported products using a simple MySQL query.

Identifying the Relevant Database Table

In Magento, the core table that stores basic product information is catalog_product_entity. This is where you’ll find fields like entity_id (product ID), sku, name, and of course, status.

The status field in this table uses an integer to represent different states. For your case:

  • Disabled = 2
  • Enabled = 1

Crafting the Query to Enable All Products

To enable all products at once, you’ll update the status column with a value of 1 for every row in the catalog_product_entity table.

Here’s the MySQL query that accomplishes this:

UPDATE catalog_product_entity
SET status = 1;

This command is straightforward. It targets the entire catalog_product_entity table and sets the status field to enabled (1) for every single product.

Executing the Query

To run this query, you have a few options:

  1. PhpMyAdmin: Log in to your Magento database via phpMyAdmin. Click on the SQL tab, paste the query above, click Go.

  2. MySQL Command Line: Connect to the server using mysql -u <username> -p and enter the password when prompted. Then run the update command.

  3. Magento’s Query Tool (for advanced users): Magento provides a built-in query tool under System -> Tools -> Query Monitor. You can paste your SQL queries here as well.

Things to Consider

While this method is quick and efficient, it’s essential to proceed with caution:

  • Always backup your database before running an update like this.
  • Double-check the table and field names to ensure you’re targeting the correct location.
  • If you have multiple websites or store views in Magento, the product status might be managed differently. In that case, you may need to adjust the query accordingly.

Conclusion

Automating repetitive tasks is a key part of streamlining your e-commerce workflows. With this technique, you can quickly enable all imported products and save yourself hours of manual labor.

Remember, whenever dealing with database changes, always prioritize data integrity by backing up first and proceeding with care.

For further guidance on optimizing Magento performance and improving import/export processes, check out our comprehensive Magento Development Services at Laravel Company.

Catalog Database Admin Import/Export

Our network