Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this community
Executed query -
SELECT GROUP_CONCAT(parent_id SEPARATOR ',') AS parent_id
FROM catalog_product_super_link AS super_link
WHERE super_link.product_id = 914066
The issue is there are records where "row id" & "entity id" is different. Any thoughts what can be the reason ?
The row_id only available in the enterprise edition(Adobe Commerce).There is no rule for row_id and entity_id should be the same or not the same. Most entries have the same row_id and entity_id and some have different enity_id and row_id. So it is not a problem.
Magento 2: What is the difference between the row_id and entity_id in the %_entity tables?
If you are developing a custom extension in Magento EE, keep this in mind, eav tables values are mapped with row_id not entity_id.
Please check this answer for the difference between row_id and entity_id. It is mainly used for content staging.
Example: You want to change a product name for a month. You can schedule that change using the content staging by specifying a different product name for the date range needed. Behind the scenes, Magento will utilize that row_id (among other meta data to support this feature) to store the scheduled change. If a customer visits the site during the time the product name was scheduled to be changed, Magento will end up loading the row_id corresponding to the how the product was scheduled to "look" at that point in time.
