Magento Reports - Products - Products Ordered issue: Item (Mage_Catalog_Model_Product) with the same id already exist

Magento Reports - Products - Products Ordered issue: Item (Mage_Catalog_Model_Product) with the same id already exist

July 14, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento Reports - Products - Products Ordered issue: Item (Mage_Catalog_Model_Product) with the same id already exist

Solving Magento Reports - Products Ordered Issue: Item (Mage_Catalog_Model_Product) with the same id already exist

Understanding the Magento Reports - Products Ordered Issue

The error you’re encountering in your Magento admin panel is a common one that arises during report generation via Reports > Products > Products Ordered. The root cause of this issue lies within the core Mage_Eav_Model_Entity_Collection_Abstract class and its handling of entity loading and item addition.

Analyzing the Error Log

The error log you provided reveals a stack trace indicating a conflict in item id during report processing. This occurs when the system attempts to add a product with an existing id to the collection, resulting in a unique constraint violation:

Item (Mage_Catalog_Model_Product) with the same id "45" already exist

The issue stems from the Magento core handling of products and collections within the Mage_Eav_Model_Entity_Collection_Abstract class during report generation.

Troubleshooting Steps for Resolving the Issue

Step 1: Identify Duplicate Products

To begin troubleshooting, you need to identify if there are any duplicate product entries in your database. Run the following query to locate products with the same id:

SELECT * FROM catalog_product_entity WHERE entity_id IN (SELECT entity_id FROM catalog_product_entity GROUP BY entity_id HAVING COUNT(*) > 1);

Step 2: Cleanse and Repair Database

If duplicate product entries are found, you’ll need to cleanse your database. You can use the Magento magento-cleanup tool, which is designed to remove unnecessary data from the database. To run this command:

./magento-cleanup

Step 3: Reindex and Update Inventory

After cleansing the database, reindex all indexes in your Magento installation using the following commands:

php bin/magento indexer:reindex
php bin/magento setup:upgrade

Next, update your inventory data to ensure consistency:

TRUNCATE TABLE cataloginventory_stock_item;

Step 4: Clear Cache and Rebuild

Clear all Magento cache using the following command:

php bin/magento cache:flush

Then, rebuild the indexer:

php bin/magento indexing:reindex

Conclusion

The Magento Reports - Products Ordered issue is typically resolved by identifying and removing duplicate product entries from your database. By utilizing the magento-cleanup tool, reindexing, updating inventory, clearing cache, and rebuilding indexes, you can effectively address this error.

Remember to test these steps in a development environment before applying them to your live Magento store.

For more advanced troubleshooting and optimization techniques for your Magento setup, consider exploring the resources available at LaravelCompany.

Catalog Database Admin Orders

Our network