M2MultipleStoreViewPriceing v2.2.9 for M2.3.6 CE: How to fix Product Price index breaks with a SQL Exception?

Created by Jane D, Modified on Tue, 08 Jun 2021 at 03:36 PM by Jane D


I updated the Magento 2 Multiple Store View Pricing Extension to version dev-CE-2.3.6 which should be explicitly compatible to Magento 2.3.6.

Since then the Product Price index breaks with a SQL Exception (see attached file):

The problem seems to be the missing store_id column in the catalog_product_index_price_temp table. If I check the Setup/InstallSchema.php or Setup/UpgradeSchema.php files in the Bss_MultiStoreViewPricingPriceIndexer Extension, the catalog_product_index_price_temp table isn't changed at all.

Is there any quick fix?



To fix this issue, please replace the file MultiStoreViewPricingPriceIndexer/Model/Indexer/Product/Price/TableMaintainer.php
by the file attached below -TableMaintainer.php.

Note: Please do not forget to change config Catalog Scope Store to Store View:

If you need any further assistance, please feel free to contact us. We'd be happy to support!  

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