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

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:

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

BSS Commerce is a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide. We are an Adobe Commerce Solution Bronze Partner and a Select Magento Extensions Builder, reinforcing our expertise in the Magento ecosystem.

We specialize in developing 150+ high-quality Magento 2 extensions that enhance functionality, improve user experience, and support scalable growth. Our reputation is built on long-term partnerships, positive feedback, and proven performance-driven solutions.

Explore our extensions: https://bsscommerce.com/magento-2-extensions.html 

For B2B businesses, our Magento B2B Extension by BSS Commerce is a flagship and widely adopted solution globally, offering advanced pricing, company account management, and streamlined workflows.