Conflict between Magestore Giftvoucher and Multiple Store View Pricing extension

Created by Robin Hoang, Modified on Thu, 18 Jan 2018 at 11:54 AM by Robin Hoang


We are having problem when trying to reindex our store. We only are able to reindex successfully when we truncate the corresponding tables before we do the reindex. If there is data in this tables we get this error:

Reindex finished with error message "SQLSTATE23000: Integrity constraint violation: 1062 Duplicate entry '31196-0-1' for key 'PRIMARY', query was: INSERT INTO`catalog_product_index_price_idx` SELECT `catalog_product_index_price_final_idx`.`entity_id`, `catalog_product_index_price_final_idx`.`customer_group_id`, `catalog_product_index_price_final_idx`.`website_id`, `catalog_product_index_price_final_idx`.`tax_class_id`, `catalog_product_index_price_final_idx`.`orig_price` AS `price`, `catalog_product_index_price_final_idx`.`price` AS `final_price`, `catalog_product_index_price_final_idx`.`min_price`, `catalog_product_index_price_final_idx`.`max_price`, `catalog_product_index_price_final_idx`.`tier_price`, `catalog_product_index_price_final_idx`.`group_price` FROM `catalog_product_index_price_final_idx`". catalog_product_price


We suppose that the root of the problem is due to a conflict between the Magestore_Giftvoucher module on your site and our Multiple Store View Pricing extension. Because of this Gift Voucher module, there is a new product type named giftvoucher, which has been not supported by the Multiple Store View Pricing extension yet.

In order to fix this conflict, could you please replace the attached files with the corresponding ones in these below folders?

- app/code/local/Bss/MultiStoreViewPricingPriceIndexer/etc/config.xml

- app/code/local/Bss/MultiStoreViewPricingPriceIndexer/Model/Resource/Product/Indexer/Base/Giftvoucher.php

- app/code/local/Bss/MultiStoreViewPricingPriceIndexer/Model/Resource/Product/Indexer/Price/Giftvoucher.php

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:

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 atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article