Integrity constraint violation: 1062 Duplicate entry '4974-134' for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID'

Integrity constraint violation: 1062 Duplicate entry '4974-134' for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID'

September 28, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Integrity constraint violation: 1062 Duplicate entry '4974-134' for key 'UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID'

Solving Magento Duplicate Entry Error: A Step-by-Step Guide

If you’re encountering the “Integrity constraint violation” error while adding configurable products in Magento, don’t worry—you’re not alone. This issue is quite common and can be resolved with some strategic troubleshooting. Let’s dive into understanding this problem and finding a solution.

Understanding the 1062 Duplicate Entry Error

The 1062 Duplicate entry error occurs when you’re trying to insert data that violates a unique key constraint in your database. In this case, it seems there is a conflict with the UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID index.

What’s Going Wrong?

The key value 4974-134 doesn’t exist in the catalog_product_super_attribute table. This suggests that either the product or attribute IDs are being referenced incorrectly during the product creation process.

A Comprehensive Troubleshooting Approach

Step 1: Check for Hidden Errors

Ensure you’re not missing any critical errors. Navigate to System > Error Reports in your Magento admin panel. Look for any recent errors, especially those related to the catalog or attribute model.

Step 2: Inspect the Catalog Product Entity Table

You mentioned that the catalog_product_entity table is being populated with new IDs. To verify this:

  • Navigate to your database management tool.
  • Select the catalog_product_entity table.
  • Execute a SELECT * FROM catalog_product_entity ORDER BY entity_id DESC LIMIT 10; This will show you the last ten inserted products and their corresponding attributes.

Step 3: Examine the Product Creation Sequence

The error suggests that the simple product is being created before the configurable product, which is counter to Magento’s intended workflow. Always create the parent configurable product first, then add its children (simple) products.

Step 4: Clear Cache and Reindex

While you mentioned this in your question, let’s re-emphasize it:

  • Navigate to System > Cache Management and click on ‘Flush Magento Cache’.
  • Go to System > Index Management, select all indexes, and click on ‘Reindex All’.

Step 5: Check for Conflicting Extensions

If you’ve recently installed or updated any extensions related to product creation (like Better Configurable Products or Configurable Swatches), ensure they are compatible with your Magento version.

Best Practices for Configurable Product Creation

  1. Always create the parent configurable product first. This ensures the ID is created and available for the child products.
  2. Double-check attribute assignments. Ensure all attributes assigned to the simple products match those defined in the configurable product settings.
  3. Maintain a clean database. Regularly optimize your database tables using tools like Magento’s built-in indexer or dedicated extensions.

When to Seek Professional Help

If you’ve exhausted these troubleshooting steps and are still experiencing issues, it might be time to consider professional support. The team at Laravel Company specializes in Magento development and can provide expert assistance with complex issues.

Conclusion

The “Integrity constraint violation” error is a common but frustrating issue in Magento. By understanding the underlying cause, following the troubleshooting steps outlined above, and adhering to best practices for product creation, you should be able to resolve this issue quickly.

Remember, Magento’s architecture requires a specific workflow when creating configurable products—always create the parent before the children. If you find yourself stuck, don’t hesitate to reach out to professional Magento developers who can provide tailored assistance.

Happy coding!

Catalog Database Admin Configuration

Our network