Magento mass-assign products to category

Magento mass-assign products to category

September 17, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento mass-assign products to category

Mass-Assigning Products to Category in Magento: A Developer’s Guide

As an experienced e-commerce developer who specializes in Magento, I frequently encounter scenarios where clients need to mass-assign products to categories efficiently. The built-in admin interface allows for one-by-one editing, but this process can be time-consuming when dealing with a large number of SKUs.

In this post, we’ll explore two efficient methods to achieve this: using PHPMyAdmin and creating a custom script using the Magento API. Let’s dive into each approach.

Using PHPMyAdmin

PHPMyAdmin is an excellent tool for database administrators who want to quickly manipulate data in a MySQL database. Here’s how you can use it to mass-assign products to a category:

  1. Open your PHPMyAdmin interface and navigate to the catalog_category_product table.

  2. Click on the “Structure” tab, then click on the “Insert” tab above.

  3. Insert the following data:

    • category_id: The ID of the target category
    • product_id: The ID(s) of the product(s) you want to assign
  4. Click on “Go” to insert the record(s).

Here’s an example:

INSERT INTO catalog_category_product (category_id, product_id)
VALUES ('123', '456'), ('123', '789');

This query assigns products with IDs 456 and 789 to the category with ID 123.

Creating a Custom Script

For a more robust solution, consider creating a custom script using the Magento API. This approach provides better security and ensures that data integrity is maintained.

First, enable the Magento SOAP API by going to System > Web Services > SOAP XML-RPC Configuration and setting the “API Enabled” field to “Yes”.

Next, create a PHP script with the following content:

<?php

require_once 'app/Mage.php';
Mage::init();

$categoryId = 123;
$productIds = array(456, 789);

try {
    $category = Mage::getModel('catalog/category')->load($categoryId);
    foreach ($productIds as $productId) {
        $category->addProduct(Mage::getModel('catalog/product')->load($productId));
    }
    $category->save();
} catch (Exception $e) {
    echo 'Error: ' . $e->getMessage();
}

Replace 'app/Mage.php' with the actual path to your Magento installation’s Mage.php file.

This script loads a specified category, adds multiple products to it using the addProduct() method, and then saves the updated category. The $productIds array should contain the IDs of the products you want to assign to the category.

Conclusion

In this post, we’ve explored two methods for mass-assigning products to categories in Magento: using PHPMyAdmin for quick data manipulation and creating a custom script using the Magento API for a more secure and maintainable solution.

Remember that manipulating the database directly can have unintended consequences if not done carefully. Always ensure you have proper backups before making any changes, especially when working with production databases.

For more in-depth guidance on Magento development and best practices, feel free to explore our Magento-related posts at LaravelCompany.com.

Catalog Database Security API

Our network