Question:

After installing the Multiple Store View Pricing extension, my site fails reindexing:

Started reindex of: catalog_product_price
Reindex finished with error message "SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db-1`.`catalog_product_index_tier_price_store`, CONSTRAINT `FK_CAT_PRD_IDX_TIER_PRICE_STORE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) 

REFERENCES `catalog_product_entity` (`entit)". catalog_product_price


So modules are enabled and the store cannot show category pages.


Answer:

Could you please remove the foreign key entity_id in catalog_product_index_tier_price_store table as shown in the screenshot below?



For more information about product, please refer Multiple Store View Pricing page.

If you need any further assistance, please feel free to contact us.

Please visit our site for more useful Magento 1 Extensions: https://bsscommerce.com/extensions.html