How to remove all related product links from Magento?

How to remove all related product links from Magento?

October 17, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to remove all related product links from Magento?

Magento’s product linking system is powerful for creating relationships between products. However, when mistakes happen during data import or export, you might find yourself with orphaned links that need to be removed. This guide will walk you through the process of deleting all related product links from your Magento store.

Understanding the Error: A Foreign Key Constraint Failure

The error message you’re encountering is a common one in Magento when dealing with foreign key constraints:

SQLSTATE[23000]: Integrity constraint violation: 1452
Cannot add or update a child row: a foreign key constraint fails
(catalog_product_link, FK_CAT_PRD_LNK_LNKED_PRD_ID_CAT_PRD_ENTT_ENTT_ID)
FOREIGN KEY (linked_product_id) REFERENCES catalog_product_entity(entity_id) ON DELETE CASCADE

This occurs because Magento is trying to create a link between two products, but the second product (linked_product_id) doesn’t exist or has been deleted. The foreign key constraint prevents this orphaned data from being inserted into the catalog_product_link table.

The most straightforward way to delete all related product links is by executing a direct SQL query on your Magento database. Here’s how:

  1. Connect to your MySQL server using a client like phpMyAdmin or MySQL Workbench.

  2. Select the catalog_product_link table.

  3. Execute the following DELETE query:

DELETE FROM catalog_product_link;

This command will remove all rows from the catalog_product_link table, effectively deleting every related product link in your store.

Warning: Always backup your database before running any bulk delete operations to prevent data loss.

Using Magento’s Command Line Interface (CLI) for Deletion

If you prefer a more Magento-specific approach, you can use the CLI to achieve this. Here are the steps:

  1. Navigate to your Magento root directory in the terminal.
  2. Run the following command:
php bin/magento indexer:reindex catalog_product_flat

This command rebuilds the product flat index, which will remove orphaned links from the database.

To avoid encountering this issue in the future:

  1. Use Unique Identifiers: Always use unique identifiers when linking products to prevent duplicate entries.
  2. Validate Product Existence: Before creating a link, validate that both the primary product and linked product exist.
  3. Error Handling: Implement proper error handling in your import scripts to catch and handle foreign key constraint violations.

Deleting all related product links is a straightforward process once you understand the cause of the error. Using either SQL queries directly on the database or Magento’s CLI can achieve this efficiently.

Remember, always backup your data before performing bulk operations to ensure you can revert changes if needed. With proper validation and error handling, you can prevent orphaned links from occurring in the future.

For more advanced techniques in managing product relationships and for professional support with your Magento implementation, consider Laravel Company’s Magento development services. Our team of experienced developers is ready to help streamline your e-commerce operations.

Catalog Database Admin Import/Export

Our network