How to Insert Frontend Labels Conditionally in Magento 2

In this post, we'll explore how to insert records into the eav_attribute_label table in Magento 2. Specifically, we'll insert the frontend_label from the eav_attribute table, but only if the attribute_id does not already exist in eav_attribute_label.

Problem

You want to insert a new record into the eav_attribute_label table with three columns: attribute_id, store_id, and value. The value to insert is the frontend_label from the eav_attribute table. This insertion should only happen if the attribute_id does not already exist in eav_attribute_label.

Solution

Here's how you can achieve this with a MySQL query:

INSERT INTO eav_attribute_label (attribute_id, store_id, value)
SELECT eav.attribute_id, 1 AS store_id, eav.frontend_label
FROM eav_attribute eav
WHERE NOT EXISTS (
    SELECT 1 FROM eav_attribute_label eal
    WHERE eal.attribute_id = eav.attribute_id
);

Explanation

Let’s break down the query:

• INSERT INTO eav_attribute_label (attribute_id, store_id, value): Specifies the table and columns where you want to insert data.
• SELECT eav.attribute_id, 1 AS store_id, eav.frontend_label: Selects the attribute_id and frontend_label from the eav_attribute table. We are assigning a store_id value of 1.
• WHERE NOT EXISTS: Ensures that the insertion only happens if the attribute_id does not already exist in the eav_attribute_label table.
• SELECT 1 FROM eav_attribute_label eal WHERE eal.attribute_id = eav.attribute_id: Checks if the attribute_id is already present in the eav_attribute_label table. If it is, the insert is not performed.

Customization

You can adjust the query based on your specific needs:

• Modify the store_id as needed for your Magento 2 store.
• Ensure that the frontend_label from eav_attribute correctly maps to the value column in eav_attribute_label.

This approach helps you maintain data consistency by avoiding duplicate attribute_id entries while inserting new frontend labels into the eav_attribute_label table.