QUESTION:

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?


ANSWER:

 

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!