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, 8 Jun, 2021 at 3:36 PM by Jane D

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!

Attachments (1)

php

TableMaintainer.php
7.82 KB