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

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article