Issue with reindex after installing Multiple Store View Pricing extension

Created by Robin Hoang, Modified on Wed, 11 Oct, 2017 at 4:27 PM by Robin Hoang

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