How to get Duplicate SKU products in Magento

How to get Duplicate SKU products in Magento

September 28, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to get Duplicate SKU products in Magento

Fetching Duplicate SKU Products in Magento

When managing your Magento store, you may encounter situations where multiple products share the same SKU code, which can lead to confusion and potential errors during inventory management or order processing. To identify these duplicate SKUs efficiently, you’ll need to query your database using SQL.

In your current approach, you are correctly using Magento’s core resource connection and crafting a SQL query to select entities with duplicate SKUs. However, there is an issue with your while loop logic that prevents it from retrieving all the rows for each unique SKU.

Understanding the Problem

The main problem lies in how you’re initializing the $counter variable and the condition used within the while loop. Here’s what’s happening:

  1. You set $counter = 1; before entering the loop.
  2. The loop condition checks if $counter < 10.
  3. Even though your query returns multiple rows for a given SKU, the $counter never increments because it remains stuck at 1.

Solving the Issue

To fix this, you need to modify your code in two key areas:

1. Fetch All Rows Instead of One

Currently, you’re fetching only one row using the fetch() method after each query execution. To retrieve all rows, use a while loop on the result set returned by the query.

Replace this part of your code:

$resultquery = $selectskuresult->fetch();

With:

$resultquery = $selectskuresult->fetchAll();  // Fetch all rows at once

2. Modify the While Loop Condition

Change the while loop condition to check if there are more rows to process in the result set, rather than using a static counter.

Replace this line:

while($counter < 10)

With:

foreach ($resultquery as $row) {
    // Process each row here
}

Improved Code Example

Here’s how your complete script should look after applying these changes:

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
set_time_limit(0);

require_once '/var/www/html/app/Mage.php';
umask(0);

Mage::app('default');

$connection = Mage::getSingleton('core/resource')->getConnection('core_write');

$sql = "SELECT entity_id, sku FROM catalog_product_entity WHERE sku IN (SELECT sku FROM catalog_product_entity GROUP BY sku HAVING COUNT(*) > 1)";
$result = $connection->query($sql);

foreach ($result as $row) {
    print_r($row);
}
?>

Conclusion

By fetching all rows at once and using a foreach loop to process each row, you can efficiently retrieve all the duplicate SKUs in your Magento store. This solution ensures that no rows are missed during the retrieval process.

Remember to backup your database before running any SQL queries, especially when fetching or manipulating data directly from the database.

For more advanced data manipulation techniques and best practices in Magento development, consider visiting LaravelCompany for comprehensive guides and tutorials.

Catalog Database Orders Errors

Our network