Question:

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


Answer:

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: https://bsscommerce.com/extensions.html